dim_date


Description

Date dimension covering years 1900-2099

Columns

Column Type Size Nulls Auto Default Children Parents Comments
date_id int4 10 null
preview__fct_checkin.checkin_date_id Implied Constraint R
preview__fct_checkin.checkout_date_id Implied Constraint R
preview__fct_class_event.end_date_id Implied Constraint R
preview__fct_class_event.event_date_id Implied Constraint R
preview__fct_class_event.start_date_id Implied Constraint R

Primary key in YYYYMMDD format
date date 13 √ null

Actual date
year int4 10 √ null

Year component
month int4 10 √ null

Month component
day int4 10 √ null

Day component
year_month int4 10 √ null

Concatenated year and month in YYYYMM format
year_day int4 10 √ null

Concatenated year and day in YYYYDDD format
month_day int4 10 √ null

Concatenated month and day in MMDD format
day_number_of_year int4 10 √ null

Day number within the year (1-365/366)
day_number_of_week int4 10 √ null

Day number within the week as returned by extract(dow from date) (0=Sunday, 6=Saturday)
day_of_week varchar 256 √ null

Name of the day of the week
month_name varchar 256 √ null

Name of the month
weekday_name varchar 256 √ null

Name of the weekday
is_start_of_month bool 1 √ null

Flag indicating if the date is the first day of the month
is_end_of_month bool 1 √ null

Flag indicating if the date is the last day of the month
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation