| Table: dbo.Subsidiary_Client_Collection_Type | |||
| The table enumerates the two different types of subsidiary client collections a master consolidated client can have associated with it. The first collection of subsidiary clients is called the User Selected to Consolidate collection and has a key value of 1. This type indicates those subsidiary clients that the user has selected to be consolidated. The second collection is called the Currently Consolidated collection and has a key value of 2. This type indicates those subsidiary clients that have been consolidated and are currently part of the master client's consolidated data. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| subsidiary_client_collection_type_KEY | int (4) | NOT NULL | Primary key. |
| description | nvarchar (60) | NOT NULL | Description of the subsidiary client collection type. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Subsidiary_Client_Collection_Type | subsidiary_client_collection_type_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Subsidiary_Client_Collection_Type$description | description | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Client_N_Subsidiary_Client__Subsidiary_Client_Collection_Type__subsidiary_client_collection_type_KEY | subsidiary_client_collection_type_KEY | Client_N_Subsidiary_Client | |