Tables [dbo].[Picklist]
A subset of a dictionary. Picklists are used as a valid set of choices for a field.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Picklist_ID: IDIDnumeric(8,0)5NOT NULL1 - 1Key to the Picklist table
Foreign Keys FK_Picklist_DictionaryID_Dictionary_ID: [dbo].[Dictionary].DictionaryIDDictionaryID[dbo].[dict_id]5NOT NULLDictionary the picklist items are from. Key to the Dictionary table
Cluster Key XAK1PickList: EntryName\PicklistTypeEntryName[dbo].[name]255NOT NULLEntryname from the dictionary.
Check Constraints CK_Picklist_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the picklist non-editable?
Cluster Key XAK1PickList: EntryName\PicklistTypeCheck Constraints CK_Picklist_PicklistType_PickListTypes : ([PicklistType]='G' OR [PicklistType]='E' OR [PicklistType]='U')PicklistTypechar(1)1NOT NULLCan be "E" or "U".  "E" stands for Enterprise and these are the normal picklists we deliver or a user creates. "U"  is for our special delivered "Most Recenty USED" picklist
MaxMRUsmallint2NOT NULLHow many most recently used items to show in the Most Recently Used picklist.
Check Constraints CK_Picklist_PreventAddFlag_Yes_Or_No : ([PreventAddFlag]='N' OR [PreventAddFlag]='Y')PreventAddFlag[dbo].[BOOL]1NOT NULL('N')If Y this prevents users from adding items to a picklist
Check Constraints CK_Picklist_IsEntryInactiveFLAG_Yes_Or_No : ([IsEntryInactiveFLAG]='N' OR [IsEntryInactiveFLAG]='Y')IsEntryInactiveFLAG[dbo].[BOOL]1NOT NULLIs the item in the picklist Inactive or not
LOINCCodevarchar(10)10NOT NULL('')LOINC Code
SNOMEDCodevarchar(18)18NOT NULL('')SNOMED Code