gift

0 rows


Description

Gift attributes — one row per gift

Columns

Column Type Size Nulls Auto Default Children Parents Comments
gift_id int4 10 null
gift_history.gift_id gift_history_gift_id_fkeyR

Primary key: node gift_id offset by node_id * 100000000
gift_purchase_id int4 10 √ null
gift_purchase_status_history.gift_purchase_id gift_purchase_status_history_gift_purchase_id_fkeyR

Ref: gift_purchase_status_history
gift_purchase_encoded_id text 2147483647 √ null
checkout_id int4 10 √ null
account_transaction_id int8 19 √ null
account_transaction.account_transaction_id gift_account_transaction_id_fkeyR

Links to the purchase account transaction
sender_customer_encoded_id text 2147483647 √ null
customer.customer_encoded_id gift_sender_customer_encoded_id_fkeyR

The sender of the gift
gift_created_timestamp timestamptz 35,6 √ null
gift_purchase_timestamp timestamptz 35,6 √ null
gift_send_timestamp timestamptz 35,6 √ null
row_updated timestamptz 35,6 √ null

Source row_updated timestamp, used for incremental ETL
gift_amount numeric 12,2 √ null

Indexes

Constraint Name Type Sort Column(s)
gift_pkey Primary key Asc gift_id
gift_gift_purchase_id_unique Must be unique Asc gift_purchase_id

Relationships

Close relationships within degrees of separation