dim_recurring_purchase_type

-1 rows


Description

A dimension table to normalise recurring purchase types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_recurring_purchase_type_id int4 10 null
recurring_purchase.dim_recurring_purchase_type_id recurring_purchase_dim_recurring_purchase_type_id_fkey R
wager.dim_recurring_purchase_type_id wager_dim_recurring_purchase_type_id_fkey R
wager_cancelled.dim_recurring_purchase_type_id wager_cancelled_dim_recurring_purchase_type_id_fkey R

An identifier for this dimension
version int4 10 √ null

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

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

When this dimension applies to
recurring_purchase_type_name text 2147483647 √ null

Plaintext recurring_purchase_type name

Indexes

Constraint Name Type Sort Column(s)
dim_recurring_purchase_type_pkey Primary key Asc dim_recurring_purchase_type_id
idx_dim_recurring_purchase_type_id Performance Asc dim_recurring_purchase_type_id
idx_recurring_purchase_type_name Performance Asc recurring_purchase_type_name

Relationships

Close relationships within degrees of separation