Table: Firm_Date_Type
Tags: read-only Content:
1 | 10000 | Year
2 | 10000 | Period
3 | 10000 | Benefit Year
Columns
Name | Type | Constraints | Description
firm_date_type_KEY | int | NOT NULL | Database assigned primary key for this table.
sort | int | NOT NULL | User defined sort for this table.
description | nvarchar (250) | NOT NULL | User defined description (unique).

Primary key
Name | Columns | Description
PK_Firm_Date_Type$firm_date_type_KEY | firm_date_type_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Firm_Date_Type$description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Firm_Date__Firm_Date_Type__firm_date_type_KEY | firm_date_type_KEY | Firm_Date |