# ccdw_dim_user_agent

This table stores details about user agents, which describe the client software making a request.

| Column Alias            | Data Type | Key    | Description                                                                | Index? |
| ----------------------- | --------- | ------ | -------------------------------------------------------------------------- | ------ |
| `user_agent_id (PK)`    | INTEGER   | **PK** | Unique identifier for a user agent.                                        | Yes    |
| `nuser_agent_id`        | VARCHAR   |        | Normalized user agent identifier.                                          | Yes    |
| `ua_engine`             | VARCHAR   |        | Rendering engine of the user agent (for example, "WebKit", "Gecko").       | No     |
| `ua_version`            | VARCHAR   |        | Full version string of the user agent.                                     | No     |
| `ua_version_major`      | INTEGER   |        | Major version number of the user agent.                                    | No     |
| `ua_class`              | VARCHAR   |        | Classification of the user agent (for example, "Browser", "Crawler").      | No     |
| `ua_class_code`         | VARCHAR   |        | Code for the user agent classification.                                    | Yes    |
| `ua_family`             | VARCHAR   |        | Family name of the user agent (for example, "Chrome", "Firefox").          | No     |
| `ua_family_code`        | VARCHAR   |        | Code for the user agent family.                                            | Yes    |
| `ua_family_vendor`      | VARCHAR   |        | Vendor of the user agent family.                                           | No     |
| `ua_family_vendor_code` | VARCHAR   |        | Code for the user agent family vendor.                                     | Yes    |
| `crawler_category`      | VARCHAR   |        | Category of the crawler (if applicable).                                   | No     |
| `crawler_category_code` | VARCHAR   |        | Code for the crawler category.                                             | Yes    |
| `os_family`             | VARCHAR   |        | Operating system family (for example, "Windows", "macOS").                 | No     |
| `os_family_code`        | VARCHAR   |        | Code for the operating system family.                                      | Yes    |
| `os`                    | VARCHAR   |        | Specific operating system (for example, "Windows 10", "iOS").              | No     |
| `os_code`               | VARCHAR   |        | Code for the operating system.                                             | No     |
| `os_family_vendor`      | VARCHAR   |        | Vendor of the operating system family.                                     | No     |
| `os_family_vendor_code` | VARCHAR   |        | Code for the operating system family vendor.                               | Yes    |
| `device_class`          | VARCHAR   |        | Classification of the device (for example, "Desktop", "Mobile", "Tablet"). | No     |
| `device_class_code`     | VARCHAR   |        | Code for the device classification.                                        | Yes    |
| `device_market_name`    | VARCHAR   |        | Market name of the device (for example, "iPhone", "Galaxy S").             | No     |
| `device_brand`          | VARCHAR   |        | Brand of the device (for example, "Apple", "Samsung").                     | No     |
| `device_brand_code`     | VARCHAR   |        | Code for the device brand.                                                 | Yes    |