dim_pricing

-1 rows


Description

A dimension table to normalise pricing types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_pricing_id int8 19 null
migrated_ticket_sales.dim_pricing_id migrated_ticket_sales_dim_pricing_id R
syndicate_sales.dim_pricing_id syndicate_sales_dim_pricing_id_fkey R
ticket_sales.dim_pricing_id ticket_sales_dim_pricing_id_fkey R
wager.dim_pricing_id wager_dim_pricing_id_fkey R
wager_cancelled.dim_pricing_id wager_cancelled_dim_pricing_id_fkey R

An identifier for this dimension
version int4 10 √ null

Version of this dimension as it applies to dim_pricing_id
date_from timestamp 29,6 √ null

When this dimension applies from
date_to timestamp 29,6 √ null

When this dimension applies to
pricing_name text 2147483647 √ null

Plaintext pricing name

Indexes

Constraint Name Type Sort Column(s)
dim_pricing_pkey Primary key Asc dim_pricing_id
idx_dim_pricing_lookup Performance Asc pricing_name
idx_dim_pricing_tk Performance Asc dim_pricing_id

Relationships

Close relationships within degrees of separation