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 |