Table: Firm_Date
Columns
NameTypeConstraintsDescription
firm_date_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
firm_date_type_KEYintNOT NULLKey to a Firm Date Type row (1=Year, 2=Period).
ending_datesmalldatetimeNOT NULLDate that this period ends.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Firm_Date$firm_date_KEYfirm_date_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Firm_Date$firm_date_type_KEY$ending_datefirm_date_type_KEY, ending_date
UK_Firm_Date$firm_date_type_KEY$firm_date_KEYfirm_date_type_KEY, firm_date_KEYREDUNDANT: Exists so that foreign keys to Firm_Date can enforce linking to the right type of Firm_Date record.
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Date__Firm_Date_Type__firm_date_type_KEYfirm_date_type_KEYFirm_Date_Type

Schema diagram