Table: dbo.Client_W2_Filing
Client W2 Filing table
Columns
NameTypeConstraintsDescription
client_w2_filing_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLKey of client to which this client w2 filing belongs
w2_override_type_KEYint (4)NOT NULLw2 override type KEY
period_end_yearsmallint (2)NOT NULLperiod end year for the client w2 filing
Primary key
NameColumnsDescription
PK_Client_W2_Filingclient_w2_filing_KEY
Unique constraints
NameColumnsDescription
UK_Client_W2_Filing$client_KEY$w2_override_type_KEY$period_end_yearclient_KEY, w2_override_type_KEY, period_end_year
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_W2_Filing__Client__client_KEYclient_KEYClient (client_KEY)FOREIGN KEY constraint of client_KEY for the Client_W2_Filing table
FK_Client_W2_Filing__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYW2_Override_Type (w2_override_type_KEY)FOREIGN KEY constraint of w2_override_type_KEY for the Client_W2_Filing table
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_W2_State_Override__Client_W2_Filing__client_w2_filing_KEYclient_w2_filing_KEYClient_W2_State_OverrideFOREIGN KEY constraint of client_w2_filing_KEY for the Client_W2_State_Override table
FK_Client_W2_Override__Client_W2_Filing__client_w2_filing_KEYclient_w2_filing_KEYClient_W2_OverrideFOREIGN KEY constraint of client_w2_filing_KEY for the Client_W2_Override table

Schema diagram