# 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the UTC registration day.                                                                                  | No     |
| `utc_registration_time_id`     | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the standard registration day.                                                                             | No     |
| `std_registration_time_id`     | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) for the standard registration time.                                                                            | No     |
| `std_registration_timezone_id` | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_timezone`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_timezone.md) for the standard registration time zone.                                                               | No     |
| `registration_site_id`         | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md) 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_customer.md). 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md).                                                                                                           | No     |
| `user_agent_id`                | INTEGER   | **FK** | Foreign key to [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md).                                                                                                   | No     |