| 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 |
| Name | Type | Definition |
|---|---|---|
| dimension_date_pkey | PRIMARY KEY | PRIMARY KEY (date_dim_id) |
| 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) |