dim_device_platform

3 rows


Description

Table represents a dimension of the possible devices customer can use when accessing the site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_device_platform_id serial 10 √ nextval('dim_device_platform_id'::regclass)
customer_action.dim_device_platform_id customer_action_dim_device_platform_id_fkey R

Primary Key: an identifier for this record
dim_device_platform_name text 2147483647 null

Name of the platform
is_mobile bool 1 null

Was the platform accessed via mobile (e.g.: platform could still be web, but accessed via mobile)
is_mobile_application bool 1 null

Was the platform a mobile application

Indexes

Constraint Name Type Sort Column(s)
dim_device_platform_pkey Primary key Asc dim_device_platform_id

Relationships

Close relationships within degrees of separation