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_utc | 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_utc | 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 |