Calendar_Date

72715 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Date_Id int identity 4 √ null
VW_Calendar_Date.date_id Implied ConstraintR
Date_Value datetime 16,3 √ null
Date_Value_V1 char 8 √ null
Date_Value_V2 char 12 √ null
Day_Value char 2 √ null
Month_Value char 2 √ null
Year_Value char 4 √ null
WEEKDAY varchar 20 √ null
WEEK_NBR int 4 √ null
ISO_WEEK_NBR int 4 √ null
Leap_Year_Ind bit 1 √ null
Month_Name varchar 20 √ null
Month_Days int 4 √ null
Quarter_Nbr int 4 √ 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

Indexes

Constraint Name Type Sort Column(s)
PK_Calendar_Date Primary key Asc Date_Id

Relationships

Close relationships within degrees of separation