public.dimension_date

public.dimension_date

Description

Columns

Name Type Default Nullable Children Parents Comment
date_dim_id integer false
date_actual date false
epoch bigint false
day_suffix varchar(4) false
day_name varchar(9) false
day_of_week integer false
day_of_month integer false
day_of_quarter integer false
day_of_year integer false
week_of_month integer false
week_of_year integer false
week_of_year_iso character(10) false
month_actual integer false
month_name varchar(9) false
month_name_abbreviated character(3) false
quarter_actual integer false
quarter_name varchar(9) false
year_actual integer false
first_day_of_week date false
last_day_of_week date false
first_day_of_month date false
last_day_of_month date false
first_day_of_quarter date false
last_day_of_quarter date false
first_day_of_year date false
last_day_of_year date false
mmyyyy character(6) false
mmddyyyy character(10) false
weekend_indr boolean false

Constraints

Name Type Definition
dimension_date_pkey PRIMARY KEY PRIMARY KEY (date_dim_id)

Indexes

Name Definition
dimension_date_pkey CREATE UNIQUE INDEX dimension_date_pkey ON public.dimension_date USING btree (date_dim_id)
dimension_date_date_actual_idx CREATE INDEX dimension_date_date_actual_idx ON public.dimension_date USING btree (date_actual)

    • Related Articles

    • public.subuserusagedata

      Description Subscription Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key date timestamp without time zone true Date userlogin varchar(50) true User GUID licensename varchar(200) true ...

    • public.wfmauditdata

      Description Audit Table for WFM Schedule Change Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(150) false Primary Key modifiedby varchar(50) true Schedule GUID scheduleid varchar(50) true addorremove varchar(10) true ...

    • public.userpresencedetaileddata

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...

    • public.flowdetails

      Description Flow Details Columns Name Type Default Nullable Children Parents Comment id varchar(255) false Flow ID name varchar(255) false Flow Name divisionid varchar(50) true Division ID description varchar(500) true Flow Description type ...

    • public.flowoutcomedata

      Description Conversation Flow Outcome Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false conversationid varchar(50) true Conversation GUID conversationstartdate timestamp without time zone false Conversation ...