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:
1 | 1 | 000000000001 j | January
2 | 2 | 000000000002 j | February
3 | 3 | 000000000003 j | March
4 | 4 | 000000000004 j | April
5 | 5 | 000000000005 j | May
6 | 6 | 000000000006 j | June
7 | 7 | 000000000007 j | July
8 | 8 | 000000000008 j | August
9 | 9 | 000000000009 j | September
10 | 10 | 000000000010 i | October
11 | 11 | 000000000011 i | November
12 | 12 | 000000000012 i | December
Columns
Name | Type | Constraints | Description
month_info_KEY | int | NOT NULL | The number of the month (1 for January, 12 for December.)
month_info_id | nvarchar (11) | NOT NULL | The same value as month_info_KEY as a string (1 for January, 12 for December.)
month_info_id_sortable | nvarchar (48) | NOT NULL | A 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.
description | nvarchar (250) | NOT NULL | The name of the month (January, December, etc.)

Primary key
Name | Columns | Description
PK_Month_Info$month_info_KEY | month_info_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Month_Info$month_info_id_sortable | month_info_id_sortable |