ccdw_dim_date
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 |