Table: dbo.Tax_Form | |||
This poorly named table actually describes all tax form COLLATIONS currently in the system | |||
Columns | |||
Name | Type | Constraints | Description |
tax_form_KEY | int (4) | NOT NULL | Primary Key |
collation_item | nvarchar (100) | NOT NULL | Collation item name. |
tax_form_type_KEY | int (4) | NOT NULL | Tax form type key. |
ste_state_code_KEY | nvarchar (4) | NOT NULL | Ste State Code key from symmetry. |
is_pending_approval | bit (1) | NOT NULL | Whether or not the form is pending approval. False is the normal case and indicates that the form has already been approved. |
Primary key | |||
Name | Columns | Description | |
PK_Tax_Form | tax_form_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Tax_Form$collation_item$tax_form_type_KEY$ste_state_code_KEY | collation_item, tax_form_type_KEY, ste_state_code_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Tax_Form__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) | |
FK_Tax_Form__Tax_Form_Type__tax_form_type_KEY | tax_form_type_KEY | Tax_Form_Type (tax_form_type_KEY) |