Table: dbo.Quarter
This table holds the description of quarters. It is used by the user interface and as a foreign key constraint.
Columns
NameTypeConstraintsDescription
quarter_KEYtinyint (1)NOT NULLThe natural key for the quarter based on one-based counting
descriptionnvarchar (12)NOT NULLThe common, ordinal, name of the quarter
Primary key
NameColumnsDescription
PK_Quarterquarter_KEY
Unique constraints
NameColumnsDescription
UK_Quarter$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Valid_7200_Period__Quarter__quarter_KEYquarter_KEYValid_7200_Period

Schema diagram