Table: dbo.Onvio_Client_List
This ephemeral table exists to satisfy a quirk of the SearchTextBox, which is that it insists on having the ability to query the database to handle how it does things like type-ahead, etc.
Columns
Name | Type | Constraints | Description
onvio_client_list_KEY | int (4) | NOT NULL | The sad state of affairs is that SearchTextBox has a Lackey, namely SearchResultsModel who insists that tables have a single-column primary key. In hindsight, it might have been worth investigating if that component tolerates a string key and concatenating the two components of the natural key with a private use character as the separator.
id | nvarchar (64) | NOT NULL | Per $/BlueMoonCore/Development/CoreServices/BlueMoon.CoreServices/BlueMoon.CoreServices.Web.Models/Common/SingleItemDto.cs the id of CORE objects is limited to 32 characters.
user_session_guid | uniqueidentifier (16) | NOT NULL | The User Session Guid is used for cleanup
code | nvarchar (40) | NOT NULL | Per $/BlueMoonCore/Development/CoreServices/BlueMoon.CoreServices/BlueMoon.CoreServices.Web.Models/ClientV3Dto.cs the code of CORE V3 Clients is limited to 20 characters.
name | nvarchar (500) | NOT NULL | Per $/BlueMoonCore/Development/CoreServices/BlueMoon.CoreServices/BlueMoon.CoreServices.Web.Models/ClientV3Dto.cs the name of CORE V3 Clients is limited to 250 characters.

Primary key
Name | Columns | Description
PK_Onvio_Client_List | onvio_client_list_KEY |
Unique constraints
Name | Columns | Description
UK_Onvio_Client_List$user_session_guid$id | user_session_guid, id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Onvio_Client_List__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |