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
NameTypeConstraintsDescription
onvio_client_list_KEYint (4)NOT NULLThe 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.
idnvarchar (64)NOT NULLPer $/BlueMoonCore/Development/CoreServices/BlueMoon.CoreServices/BlueMoon.CoreServices.Web.Models/Common/SingleItemDto.cs the id of CORE objects is limited to 32 characters.
user_session_guiduniqueidentifier (16)NOT NULLThe User Session Guid is used for cleanup
codenvarchar (40)NOT NULLPer $/BlueMoonCore/Development/CoreServices/BlueMoon.CoreServices/BlueMoon.CoreServices.Web.Models/ClientV3Dto.cs the code of CORE V3 Clients is limited to 20 characters.
namenvarchar (500)NOT NULLPer $/BlueMoonCore/Development/CoreServices/BlueMoon.CoreServices/BlueMoon.CoreServices.Web.Models/ClientV3Dto.cs the name of CORE V3 Clients is limited to 250 characters.
Primary key
NameColumnsDescription
PK_Onvio_Client_Listonvio_client_list_KEY
Unique constraints
NameColumnsDescription
UK_Onvio_Client_List$user_session_guid$iduser_session_guid, id
Foreign keys
NameColumnsReferenced tableDescription
FK_Onvio_Client_List__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram