ccdw_fact_customer_registration
This table records customer registration events.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
registration_id (PK) | BIGINT | PK | Unique identifier for a customer registration. | No |
utc_registration_timestamp | TIMESTAMP | UTC timestamp of the registration. | No | |
utc_registration_day_id | SMALLINT | FK | Foreign key to ccdw_dim_date for the UTC registration day. | No |
utc_registration_time_id | SMALLINT | FK | Foreign key to ccdw_dim_time for the UTC registration time. | No |
utc_update_timestamp | TIMESTAMP | Last modified UTC timestamp of this record. | Yes | |
std_registration_timestamp | TIMESTAMP | Timestamp of the registration, in standard time. | No | |
std_registration_day_id | SMALLINT | FK | Foreign key to ccdw_dim_date for the standard registration day. | No |
std_registration_time_id | SMALLINT | FK | Foreign key to ccdw_dim_time for the standard registration time. | No |
std_registration_timezone_id | SMALLINT | FK | Foreign key to ccdw_dim_timezone for the standard registration time zone. | No |
registration_site_id | SMALLINT | FK | Foreign key to ccdw_dim_site where the registration occurred. | No |
visitor_id | VARCHAR | Anonymous visitor ID. | No | |
customer_id | BIGINT | FK | Foreign key to ccdw_dim_customer . | No |
locale_id | SMALLINT | FK | Foreign key to ccdw_dim_locale . | No |
user_agent_id | INTEGER | FK | Foreign key to ccdw_dim_user_agent . | No |