Table: Month_Info
Basic information about calendar months (in English.) This information is useful for drop down lists, etc and is used mostly in Filtering.
Tags: read-only

Content:
11000000000001 jJanuary
22000000000002 jFebruary
33000000000003 jMarch
44000000000004 jApril
55000000000005 jMay
66000000000006 jJune
77000000000007 jJuly
88000000000008 jAugust
99000000000009 jSeptember
1010000000000010 iOctober
1111000000000011 iNovember
1212000000000012 iDecember
Columns
NameTypeConstraintsDescription
month_info_KEYintNOT NULLThe number of the month (1 for January, 12 for December.)
month_info_idnvarchar (11)NOT NULLThe same value as month_info_KEY as a string (1 for January, 12 for December.)
month_info_id_sortablenvarchar (48)NOT NULLA representation of the month_info_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of month_info_id.
descriptionnvarchar (250)NOT NULLThe name of the month (January, December, etc.)
Primary key
NameColumnsDescription
PK_Month_Info$month_info_KEYmonth_info_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Month_Info$month_info_id_sortablemonth_info_id_sortable

Schema diagram