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. |
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. |