Table: dbo.Client_N_Subsidiary_Client
This table will hold all the master client and their subsidiary client linked to them
Columns
NameTypeConstraintsDescription
client_n_subsidiary_client_KEYint (4)NOT NULLPrimary key for this table.
consolidating__client_KEYint (4)NOT NULLkey to the Consolidating(master) client and foreign key to parent Client table
subsidiary__client_KEYint (4)NOT NULLKey to the subsidiary client and foreign key to parent Client table
sequence_numberint (4)NOT NULLsubsidiary order
subsidiary_client_collection_type_KEYint (4)NOT NULLThe Client_N_Subsidiary_Client table can maintain two collections of subsidiary clients for each master client. This column distinguishs these two collections. See the description for table Subsidiary_Client_Collection_Type for an explanation of these two collection types.
subsidiary_is_dirtybit (1)NOT NULLThis flag will be set when the subsidiary client is dirty. This flag will only be set for the subsidiary client which is currently included in the master client.
Primary key
NameColumnsDescription
PK_Client_N_Subsidiary_Clientclient_n_subsidiary_client_KEY
Unique constraints
NameColumnsDescription
UK_Client_N_Subsidiary_Client$consolidating__client_KEY$subsidiary__client_KEY$subsidiary_client_collection_type_KEYconsolidating__client_KEY, subsidiary__client_KEY, subsidiary_client_collection_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_N_Subsidiary_Client__Client__consolidating__client_KEYconsolidating__client_KEYClient (client_KEY)
FK_Client_N_Subsidiary_Client__Client__subsidiary__client_KEYsubsidiary__client_KEYClient (client_KEY)
FK_Client_N_Subsidiary_Client__Subsidiary_Client_Collection_Type__subsidiary_client_collection_type_KEYsubsidiary_client_collection_type_KEYSubsidiary_Client_Collection_Type (subsidiary_client_collection_type_KEY)

Schema diagram