gift_purchase_status_history

0 rows


Description

Status transitions for a gift purchase — one row per status change.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
gift_purchase_status_history_id int4 10 null
gift_purchase_id int4 10 null
gift.gift_purchase_id gift_purchase_status_history_gift_purchase_id_fkeyR

Ref: gift.gift_purchase_id
dim_gift_purchase_status_id int4 10 √ null
dim_gift_purchase_status.dim_gift_purchase_status_id gift_purchase_status_history_dim_gift_purchase_status_id_fkeyR

Ref: dim_gift_purchase_status
gift_purchase_status_history_timestamp timestamptz 35,6 √ null
gift_purchase_status_history_event_timestamp timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
gift_purchase_status_history_pkey Primary key Asc gift_purchase_status_history_id

Relationships

Close relationships within degrees of separation