dim_channel

-1 rows


Description

A dimension table to normalise PBJ sales and supplier channels

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_channel_id int4 10 null
deposit.dim_channel_id deposit_dim_channel_id_fkey R
scheduled_purchase.dim_channel_id scheduled_purchase_dim_channel_id_fkey R
wager.dim_channel_id wager_dim_channel_id_fkey R
wager.initial_dim_channel_id Implied Constraint R
wager_cancelled.dim_channel_id wager_cancelled_dim_channel_id_fkey R
wager_cancelled.initial_dim_channel_id Implied Constraint R

An identifier for this dimension
version int4 10 √ null

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

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

When this dimension applies to
channel_name text 2147483647 √ null

Channel name

Indexes

Constraint Name Type Sort Column(s)
dim_channel_pkey Primary key Asc dim_channel_id
idx_dim_channel_id Performance Asc dim_channel_id
idx_dim_channel_name Performance Asc channel_name

Relationships

Close relationships within degrees of separation