recurring_purchase_event

-1 rows


Description

Table represents the recurring purchases events. Includes next anniversary dates and success/failures for every purchase attempt

Columns

Column Type Size Nulls Auto Default Children Parents Comments
recurring_purchase_event_id int4 10 √ null

Primary Key: an identifier for this record
dim_recurring_purchase_event_type_id int4 10 null
dim_recurring_purchase_event_type.dim_recurring_purchase_event_type_id recurring_purchase_event_drpeti_fkey R

Ref: see table dim_recurring_purchase_event_type
recurring_purchase_event_timestamp timestamptz 35,6 null

When this event occurred
recurring_purchase_id int4 10 null
recurring_purchase.recurring_purchase_id recurring_purchase_event_recurring_purchase_id_fkey R

Recurring purchase this event applies to
recurring_purchase_event_data json 2147483647 √ null

JSON object encapsulating event data. Schema varies depending on event type

Indexes

Constraint Name Type Sort Column(s)
idx_recurring_purchase_event_dim_recurring_purchase_event_type_ Performance Asc dim_recurring_purchase_event_type_id
idx_recurring_purchase_event_timestamp Performance Asc recurring_purchase_event_timestamp
idx_recurring_purchase_id Performance Asc recurring_purchase_id

Relationships

Close relationships within degrees of separation