Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| date_id | int4 | 10 | null |
|
|
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
