customer_communication_preference

-1 rows


Description

Table represents customers communication preferences

Columns

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

Primary key: cluster-wide unique identifier for this record
customer_id int4 10 null
customer.customer_id customer_communication_preference_customer_id_fkey R

Ref: one-to-one with customer
dim_lottery_id int4 10 null
dim_lottery.dim_lottery_id customer_communication_preference_dim_lottery_id_fkey R

Which lottery this preference applies to, see table: dim_lottery
customer_communication_preferences json 2147483647 √ null

A JSON object defining communication flags. Keys: {direct_mail,email,phone,push,sms}; values: Boolean
customer_communication_preference_timestamp timestamptz 35,6 null

When this record was created

Indexes

Constraint Name Type Sort Column(s)
idx_customer_communication_preference_customer_id Performance Asc customer_id
idx_customer_communication_preference_dim_lottery_id Performance Asc dim_lottery_id

Relationships

Close relationships within degrees of separation