This table contains various attributes related to dates, providing detailed temporal information. Each record represents a calendar date and its component parts (year, quarter, month, week, day).
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
day_id (PK) |
SMALLINT | PK | Unique identifier for a specific day. | Yes |
day_timestamp |
DATE | Timestamp representing the start of the day. | Yes | |
day_of_year |
SMALLINT | Day number within the year (1-366). | No | |
day_of_month |
SMALLINT | Day number within the month (1-31). | Yes | |
day_of_week |
SMALLINT | Day number within the week (for example, 1 for Monday). | No | |
day_of_week_short |
VARCHAR | Short name for the day of the week (for example, "Mon"). | No | |
day_of_week_long |
VARCHAR | Long name for the day of the week (for example, "Monday"). | No | |
day_display_name |
VARCHAR | User-friendly display name for the day. | No | |
week_id |
SMALLINT | Unique identifier for a specific week. | Yes | |
week_timestamp |
DATE | Timestamp representing the start of the week. | Yes | |
week_of_year |
SMALLINT | Week number within the year (1-53). | No | |
week_of_year_short |
VARCHAR | Short representation of the week of the year. | No | |
week_of_year_long |
VARCHAR | Long representation of the week of the year. | No | |
week_display_name |
VARCHAR | User-friendly display name for the week. | No | |
month_id |
SMALLINT | Unique identifier for a specific month. | Yes | |
month_timestamp |
DATE | Timestamp representing the start of the month. | Yes | |
month_of_year |
SMALLINT | Month number within the year (1-12). | Yes | |
month_of_year_short |
VARCHAR | Short representation of the month of the year. | No | |
month_of_year_long |
VARCHAR | Long representation of the month of the year (for example, 'Jan'). | No | |
month_display_name |
VARCHAR | User-friendly display name for the month (for example, 'January'). | No | |
quarter_id |
SMALLINT | Unique identifier for a specific quarter. | Yes | |
quarter_timestamp |
DATE | Timestamp representing the start of the quarter. | Yes | |
quarter_of_year |
SMALLINT | Quarter number within the year (1-4). | No | |
quarter_short |
VARCHAR | Short representation of the quarter. | No | |
quarter_long |
VARCHAR | Long representation of the quarter. | No | |
quarter_display_name |
VARCHAR | User-friendly display name for the quarter. | No | |
year_id |
SMALLINT | Unique identifier for a specific year. | Yes | |
year_timestamp |
DATE | Timestamp representing the start of the year. | Yes | |
year_of_era |
SMALLINT | Year number within its era. | Yes | |
year_display_name |
VARCHAR | User-friendly display name for the year. | No | |
weekyear_id |
SMALLINT | Unique identifier for a specific week-year. | Yes | |
weekyear_timestamp |
DATE | Timestamp representing the start of the week-year. | Yes | |
weekyear_of_era |
SMALLINT | Week-year number within its era. | No | |
weekyear_display_name |
VARCHAR | User-friendly display name for the week-year. | No |