Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| date_id | int identity | 4 | null |
|
|
|||||
| date_value | datetime | 16,3 | √ | null |
|
|
||||
| date_value_version1 | char | 8 | √ | null |
|
|
||||
| date_value_version2 | char | 12 | √ | null |
|
|
||||
| day_value | char | 2 | √ | null |
|
|
||||
| month_value | char | 2 | √ | null |
|
|
||||
| year_value | char | 4 | √ | null |
|
|
||||
| week_value | varchar | 20 | √ | null |
|
|
||||
| week_nbr | int | 4 | √ | null |
|
|
||||
| iso_week_nbr | int | 4 | √ | null |
|
|
||||
| leap_year_indicator | bit | 1 | √ | null |
|
|
||||
| month_name | varchar | 20 | √ | null |
|
|
||||
| month_days | int | 4 | √ | null |
|
|
||||
| quarter_nbr | int | 4 | √ | null |
|
|
||||
| quarter_code | varchar | 2 | √ | null |
|
|
||||
| quarter_year | varchar | 6 | √ | null |
|
|
||||
| work_week_start_date | datetime | 16,3 | √ | null |
|
|
||||
| work_week_end_date | datetime | 16,3 | √ | null |
|
|
||||
| calendar_week_start_date | datetime | 16,3 | √ | null |
|
|
||||
| calendar_week_end_date | datetime | 16,3 | √ | null |
|
|
||||
| month_start_date | datetime | 16,3 | √ | null |
|
|
||||
| month_end_date | datetime | 16,3 | √ | null |
|
|
||||
| quarter_start_date | datetime | 16,3 | √ | null |
|
|
||||
| quarter_end_date | datetime | 16,3 | √ | null |
|
|
||||
| time_stamp_ms | bigint | 8 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
