Table: Firm_Date
Columns
Name | Type | Constraints | Description
firm_date_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
row_version | timestamp | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
firm_date_type_KEY | int | NOT NULL | Key to a Firm Date Type row (1=Year, 2=Period).
ending_date | smalldatetime | NOT NULL | Date that this period ends.
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Firm_Date$firm_date_KEY | firm_date_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Firm_Date__firm_date_type_KEY__ending_date | firm_date_type_KEY, ending_date |
UK_Firm_Date__firm_date_type_KEY__firm_date_KEY | firm_date_type_KEY, firm_date_KEY | REDUNDANT: Exists so that foreign keys to Firm_Date can enforce linking to the right type of Firm_Date record.

Foreign keys
Name | Columns | Referenced table | Description
FK_Firm_Date__Firm_Date_Type__firm_date_type_KEY | firm_date_type_KEY | Firm_Date_Type |