recurring_purchase

-1 rows


Description

Table represents list of Autoplays/Subscriptions of customers

Columns

Column Type Size Nulls Auto Default Children Parents Comments
recurring_purchase_id int4 10 null
recurring_purchase_event.recurring_purchase_id recurring_purchase_event_recurring_purchase_id_fkey R
recurring_purchase_status_history.recurring_purchase_id recurring_purchase_status_history_recurring_purchase_id_fkey R
ticket_sales.recurring_purchase_id ticket_sales_recurring_purchase_id_fkey R

Primary key: an identifier for this record
recurring_purchase_timestamp timestamptz 35,6 null

When this recurring purchase began
customer_id int4 10 null
customer.customer_id recurring_purchase_customer_id_fkey R

Ref: many-to-one to table customer
starting_dim_draw_id int4 10 null
dim_draw.dim_draw_id recurring_purchase_starting_dim_draw_id_fkey R

Used for date indexing, applied to the first draw this recurring purcase applies to
dim_recurring_purchase_type_id int4 10 √ null
dim_recurring_purchase_type.dim_recurring_purchase_type_id recurring_purchase_dim_recurring_purchase_type_id_fkey R

See table dim_recurring_purchase_type
recurring_purchase_encoded_id text 2147483647 √ null

External reference to this recurring purchase

Indexes

Constraint Name Type Sort Column(s)
recurring_purchase_pkey Primary key Asc recurring_purchase_id
idx_recurring_purchase_customer_id Performance Asc customer_id
idx_recurring_purchase_dim_recurring_purchase_type_id Performance Asc dim_recurring_purchase_type_id
idx_recurring_purchase_recurring_purchase_encoded_id Performance Asc recurring_purchase_encoded_id
idx_recurring_purchase_recurring_purchase_timestamp Performance Asc recurring_purchase_timestamp
idx_recurring_purchase_starting_dim_draw_id Performance Asc starting_dim_draw_id

Relationships

Close relationships within degrees of separation