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