| Table: dbo.State_Tax_Exemption | |||
| Columns | |||
| Name | Type | Constraints | Description |
| state_tax_exemption_KEY | int (4) | NOT NULL | Primary key for the State_Tax_Exemption table. |
| state_tax_exemption_type_KEY | int (4) | Associated state tax exemption list item. | |
| client_payroll_item_KEY | int (4) | NOT NULL | Associated client payroll item. |
| Primary key | |||
| Name | Columns | Description | |
| PK_State_Tax_Exemption | state_tax_exemption_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_State_Tax_Exemption$client_payroll_item_KEY$state_tax_exemption_type_KEY | client_payroll_item_KEY, state_tax_exemption_type_KEY | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_State_Tax_Exemption_Detail__State_Tax_Exemption__state_tax_exemption_KEY | state_tax_exemption_KEY | State_Tax_Exemption_Detail | |