dim_entry_offer

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

dim_entry_offer_id

bigserial

19

√

nextval('dim_entry_offer_dim_entry_offer_id_seq'::regclass)

syndicate_dividend.dim_entry_offer_id	syndicate_dividend_dim_entry_offer_id_fkey	R
ticket_dividend.dim_entry_offer_id	ticket_dividend_dim_entry_offer_id_fkey	R

An identifier for this dimension

version

int4

10

√

null

Version of this dimension as it applies to dim_entry_offer_id

date_from

timestamp

29,6

√

null

When this dimension applies from

date_to

timestamp

29,6

√

null

When this dimension applies to

entry_offer_names

text

2147483647

√

null

An array of entry_offer names

Constraint Name	Type	Sort	Column(s)
dim_entry_offer_pkey	Primary key	Asc	dim_entry_offer_id
idx_dim_entry_offer_lookup	Performance	Asc	entry_offer_names
idx_dim_entry_offer_tk	Performance	Asc	dim_entry_offer_id