customer_event

-1 rows


Description

Table represents customers events

Columns

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

Not a primary, no foreign key allowed
dim_customer_event_type_id int4 10 null
dim_customer_event_type.dim_customer_event_type_id customer_event_dim_customer_event_type_id_fkey R

Type for the customer event, see table: dim_customer_event_type
customer_event_timestamp timestamptz 35,6 null

When this event occurred
customer_id int4 10 null
customer.customer_id customer_event_customer_id_fkey R

Ref: many-to-one to customer
administrator_id int4 10 √ null
administrator.administrator_id customer_event_administrator_id_fkey R

Ref: many-to-one to administrator
customer_event_data text 2147483647 √ null

A JSON object holding details about the event. Schema varies depending on the event type
customer_event_comment text 2147483647 √ null

Holds additional contextual information about a customer event

Indexes

Constraint Name Type Sort Column(s)
customer_event_ceti Performance Asc dim_customer_event_type_id
customer_event_ci Performance Asc customer_id

Relationships

Close relationships within degrees of separation