Table: dbo.Quarter | |||
This table holds the description of quarters. It is used by the user interface and as a foreign key constraint. | |||
Columns | |||
Name | Type | Constraints | Description |
quarter_KEY | tinyint (1) | NOT NULL | The natural key for the quarter based on one-based counting |
description | nvarchar (12) | NOT NULL | The common, ordinal, name of the quarter |
Primary key | |||
Name | Columns | Description | |
PK_Quarter | quarter_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Quarter$description | description |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Valid_7200_Period__Quarter__quarter_KEY | quarter_KEY | Valid_7200_Period |