gift_history

0 rows


Description

One row per update event on the node gift table. Receiver and deposit are only populated once the gift is sent successfully

Columns

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

Primary key: node gift_history_id offset by node_id * 100000000
gift_id int4 10 null
gift.gift_id gift_history_gift_id_fkeyR

Ref: gift.gift_id
dim_gift_status_id int4 10 √ null
dim_gift_status.dim_gift_status_id gift_history_dim_gift_status_id_fkeyR

Ref: dim_gift_status
receiver_customer_encoded_id text 2147483647 √ null
customer.customer_encoded_id gift_history_receiver_customer_encoded_id_fkeyR

The customer whom the gift has been received by
deposit_encoded_id text 2147483647 √ null
reward_account_bucket.deposit_encoded_id reward_account_bucket_deposit_encoded_id_fkeyR
deposit.deposit_encoded_id gift_history_deposit_encoded_id_fkeyR

The deposit on the receiving customers side
gift_expiry_timestamp timestamptz 35,6 √ null
gift_history_timestamp timestamptz 35,6 √ null

When this history row was created
gift_history_event_timestamp timestamptz 35,6 √ null

When the underlying event occurred

Indexes

Constraint Name Type Sort Column(s)
gift_history_pkey Primary key Asc gift_history_id
gift_history_deposit_encoded_id_unique Must be unique Asc deposit_encoded_id

Relationships

Close relationships within degrees of separation