reward_account_bucket

0 rows


Description

One row per reward bucket — a bucket is tied to a single reward deposit

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_bucket_id int8 19 null
reward_account_bucket_transaction.account_bucket_id reward_account_bucket_transaction_account_bucket_id_fkeyR
deposit_encoded_id text 2147483647 √ null
deposit.deposit_encoded_id reward_account_bucket_deposit_table_encoded_id_fkeyR
gift_history.deposit_encoded_id reward_account_bucket_deposit_encoded_id_fkeyR

Links to gift_history.deposit_encoded_id for gift buckets
dim_account_bucket_category_id int4 10 √ null
dim_account_bucket_category.dim_account_bucket_category_id reward_account_bucket_dim_account_bucket_category_id_fkeyR

Ref: dim_account_bucket_category (e.g. ACCOUNT_BUCKET_CATEGORY_REWARDS_GIFT, _BONUS)
dim_account_bucket_type_id int4 10 √ null
dim_account_bucket_type.dim_account_bucket_type_id reward_account_bucket_dim_account_bucket_type_id_fkeyR

Ref: dim_account_bucket_type
account_bucket_expires_at timestamptz 35,6 √ null
account_bucket_deposit_amount numeric 15,2 √ null

Indexes

Constraint Name Type Sort Column(s)
reward_account_bucket_pkey Primary key Asc account_bucket_id

Relationships

Close relationships within degrees of separation