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