This table records the activation of source codes.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
source_code_activation_id |
BIGINT | PK | Unique identifier for a source code activation event. | Yes |
nsource_code_id |
VARCHAR(50) | Normalized source code identifier. | No | |
utc_activation_timestamp |
TIMESTAMP | UTC timestamp of the source code activation. | No | |
utc_activation_day_id |
SMALLINT | FK | Foreign key to ccdw_dim_date for the UTC activation day. |
Yes |
utc_activation_time_id |
SMALLINT | FK | Foreign key to ccdw_dim_time for the UTC activation time. |
No |
utc_update_timestamp |
TIMESTAMP | Last modified UTC timestamp of this record. | Yes | |
std_activation_timestamp |
TIMESTAMP | Timestamp of the source code activation, in standard time. | No | |
std_activation_day_id |
SMALLINT | FK | Foreign key to ccdw_dim_date for the standard activation day. |
Yes |
std_activation_time_id |
SMALLINT | FK | Foreign key to ccdw_dim_time for the standard activation time. |
No |
std_activation_timezone_id |
SMALLINT | FK | Foreign key to ccdw_dim_timezone for the standard activation time zone. |
No |
source_code_group_id |
INTEGER | FK | Foreign key to ccdw_dim_source_code_group. |
Yes |
source_code_status |
VARCHAR(50) | Status of the source code activation. | No | |
activation_site_id |
SMALLINT | FK | Foreign key to ccdw_dim_site where the source code was activated. |
Yes |
visitor_id |
VARCHAR(100) | 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. |
Yes |
locale_id |
SMALLINT | FK | Foreign key to ccdw_dim_locale. |
Yes |
user_agent_id |
INTEGER | FK | Foreign key to ccdw_dim_user_agent. |
Yes |