# ccdw_aggr_visit_user_agent

This table summarizes visits by user agent details.

> **Note:** This table is constrained by IP Address Filters configured in Business Manager.

| Column Alias         | Data Type | Key    | Description                                                                                                              | Index? |
| -------------------- | --------- | ------ | ------------------------------------------------------------------------------------------------------------------------ | ------ |
| `visit_date`         | DATE      |        | Date of the visit.                                                                                                       | No     |
| `site_id`            | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md).                               | No     |
| `registered`         | BOOLEAN   |        | Boolean indicating if the visitor was registered.                                                                        | No     |
| `device_class_code`  | VARCHAR   | **FK** | Foreign key to [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md).                   | No     |
| `locale_code`        | VARCHAR   | **FK** | Foreign key to [`ccdw_dim_locale`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md).                           | No     |
| `ua_class`           | VARCHAR   |        | User agent classification (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)). | No     |
| `ua_family`          | VARCHAR   |        | User agent family (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)).         | No     |
| `ua_engine`          | VARCHAR   |        | User agent engine (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)).         | No     |
| `ua_os`              | VARCHAR   |        | Operating system (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)).          | No     |
| `ua_os_family`       | VARCHAR   |        | Operating system family (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)).   | No     |
| `device_class_code`  | VARCHAR   |        | Device class code (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)).         | No     |
| `device_market_name` | VARCHAR   |        | Device market name (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)).        | No     |
| `device_brand`       | VARCHAR   |        | Device brand (from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md)).              | No     |
| `num_visits`         | INTEGER   |        | Total number of visits for this user agent.                                                                              | No     |