Table: dbo.W2_1099_Type
Columns
NameTypeConstraintsDescription
w2_1099_type_KEYint (4)NOT NULLUnique key for the W-2/1099 type
descriptionnvarchar (18)NOT NULLEither W-2 or 1099
Primary key
NameColumnsDescription
PK_W2_1099_Typew2_1099_type_KEY
Unique constraints
NameColumnsDescription
UK_W2_1099_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_W2_1099_Box_Type__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYW2_1099_Box_Type
FK_Spreadsheet_Import_1099_Box_Combination__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYSpreadsheet_Import_1099_Box_Combination
FK_Print_1099__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYPrint_1099
FK_Client_1099_Tax_Form_Selection__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYClient_1099_Tax_Form_SelectionFOREIGN KEY constraint of w2_1099_type_KEY for the Client_1099_Tax_Form_Selection table.
FK_Form_1099__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYForm_1099

Schema diagram