| Table: dbo.W2_1099_Type | |||
| Columns | |||
| Name | Type | Constraints | Description |
| w2_1099_type_KEY | int (4) | NOT NULL | Unique key for the W-2/1099 type |
| description | nvarchar (18) | NOT NULL | Either W-2 or 1099 |
| Primary key | |||
| Name | Columns | Description | |
| PK_W2_1099_Type | w2_1099_type_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_W2_1099_Type$description | description | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_W2_1099_Box_Type__W2_1099_Type__w2_1099_type_KEY | w2_1099_type_KEY | W2_1099_Box_Type | |
| FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Type__w2_1099_type_KEY | w2_1099_type_KEY | Spreadsheet_Import_1099_Box_Combination | |
| FK_Print_1099__W2_1099_Type__w2_1099_type_KEY | w2_1099_type_KEY | Print_1099 | |
| FK_Client_1099_Tax_Form_Selection__W2_1099_Type__w2_1099_type_KEY | w2_1099_type_KEY | Client_1099_Tax_Form_Selection | FOREIGN KEY constraint of w2_1099_type_KEY for the Client_1099_Tax_Form_Selection table. |
| FK_Form_1099__W2_1099_Type__w2_1099_type_KEY | w2_1099_type_KEY | Form_1099 | |