# ccdw_aggr_registration

This table summarizes customer registration activity.

| Column Alias        | Data Type | Key    | Description                                                                                                    | Index? |
| ------------------- | --------- | ------ | -------------------------------------------------------------------------------------------------------------- | ------ |
| `registration_date` | DATE      |        | Date of customer registration.                                                                                 | Yes    |
| `site_id`           | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md).                     | Yes    |
| `locale_code`       | VARCHAR   |        | Locale code from [`ccdw_dim_locale`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md).               | Yes    |
| `device_class_code` | VARCHAR   |        | Device class code from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md). | Yes    |
| `num_registrations` | INTEGER   |        | Total number of customer registrations.                                                                        | No     |