Table: Firm_Date_Type
Tags: read-only

Content:
110000Year
210000Period
310000Benefit Year
Columns
NameTypeConstraintsDescription
firm_date_type_KEYintNOT NULLDatabase assigned primary key for this table.
sortintNOT NULLUser defined sort for this table.
descriptionnvarchar (250)NOT NULLUser defined description (unique).
Primary key
NameColumnsDescription
PK_Firm_Date_Type$firm_date_type_KEYfirm_date_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Firm_Date_Type$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Firm_Date__Firm_Date_Type__firm_date_type_KEYfirm_date_type_KEYFirm_Date

Schema diagram