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