customer_action

-1 rows


Description

Table represents the actions that a customer has taken on the website

Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_action_id serial 10 √ nextval('customer_action_id'::regclass)

Primary Key; the identifier for this customer_action
dim_device_platform_id int4 10 √ null
dim_device_platform.dim_device_platform_id customer_action_dim_device_platform_id_fkey R

Foreign Key; the device the customer was logged in on at the time of the action (see table: dim_device_platform)
customer_action_type text 2147483647 null

Detail what type of action this is, ie deposit, ticket_purchase, withdraw etc. This is relative to the customer’s jumbo account
dim_date_id int4 10 null
dim_date.dim_date_id customer_action_dim_date_id_fkey R

Used for date indexing, applied to customer_action_timestamp (see table: dim_date)
dim_browser_id int4 10 √ null

See table: dim_browser
customer_action_timestamp timestamptz 35,6 null

Timestamp with timezone for when this customer_action occurred
customer_id int4 10 null
customer.customer_id Implied Constraint R

Foreign Key; the customer for whom this customer_action occurred to
utm_source text 2147483647 √ null

Urchin Tracking Module source
utm_medium text 2147483647 √ null

Urchin Tracking Module medium (e.g., email, website)
utm_term text 2147483647 √ null

Urchin Tracking Module term
utm_content text 2147483647 √ null

Urchin Tracking Module content
utm_campaign text 2147483647 √ null

Urchin Tracking Module unique campaign identifier
ticket_id int4 10 √ null
ticket_sales.ticket_id Implied Constraint R

Ref to the ticket (if any) this action applies to

Indexes

Constraint Name Type Sort Column(s)
customer_action_pkey Primary key Asc customer_action_id
customer_action_cat Performance Asc customer_action_type
customer_action_ci Performance Asc customer_id
customer_action_ddi Performance Asc dim_date_id
customer_action_ddpi Performance Asc dim_device_platform_id
customer_action_ti Performance Asc ticket_id

Relationships

Close relationships within degrees of separation