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		Unique identifier for a visitor session. This ID persists across sessions and is associated with an anonymous tracking cookie (for example, dwanonymous).	No
`customer_id`	BIGINT	FK	Foreign key to `ccdw_dim_customer`. For unregistered buyers, this value is `1` and can't distinguish one unregistered buyer from another.	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