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 |