dim_date


Description

Date dimension covering years 1900-2099

Columns

Column Type Size Nulls Auto Default Children Parents Comments
date_id int4 10 null
fct_checkin.checkin_date_id Implied Constraint R
fct_checkin.checkout_date_id Implied Constraint R
fct_class_appointment.created_date_id Implied Constraint R
fct_class_appointment.end_date_id Implied Constraint R
fct_class_appointment.start_date_id Implied Constraint R
fct_class_event.end_date_id fct_class_event_end_date_id_fkey R
fct_class_event.event_date_id fct_class_event_event_date_id_fkey R
fct_class_event.start_date_id fct_class_event_start_date_id_fkey R
fct_contract.cancellation_date_id fct_contract_cancellation_date_id_fkey R
fct_contract.cancellation_receipt_date_id fct_contract_cancellation_receipt_date_id_fkey R
fct_contract.created_date_id fct_contract_created_date_id_fkey R
fct_contract.end_date_id fct_contract_end_date_id_fkey R
fct_contract.pre_cancellation_end_date_id fct_contract_pre_cancellation_end_date_id_fkey R
fct_contract.start_date_id fct_contract_start_date_id_fkey R
fct_contract.start_date_of_use_id fct_contract_start_date_of_use_id_fkey R
fct_idle_period.end_date_id Implied Constraint R
fct_idle_period.start_date_id Implied Constraint R
fct_payment_run.effective_collection_date_id Implied Constraint R
fct_revenue.accounting_date_id fct_revenue_accounting_date_id_fkey R
fct_trainer_class_appointments.end_date_id Implied Constraint R
fct_trainer_class_appointments.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