Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | numeric(8,0) | 5 | NOT NULL | 1 - 1 | | Key to the Picklist table |
![Foreign Keys FK_Picklist_DictionaryID_Dictionary_ID: [dbo].[Dictionary].DictionaryID Foreign Keys FK_Picklist_DictionaryID_Dictionary_ID: [dbo].[Dictionary].DictionaryID](../../../../Images/fk.png) | DictionaryID | [dbo].[dict_id] | 5 | NOT NULL | | | Dictionary the picklist items are from. Key to the Dictionary table |
 | EntryName | [dbo].[name] | 255 | NOT NULL | | | Entryname from the dictionary. |
![Check Constraints CK_Picklist_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Picklist_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the picklist non-editable? |
 ![Check Constraints CK_Picklist_PicklistType_PickListTypes : ([PicklistType]='G' OR [PicklistType]='E' OR [PicklistType]='U') Check Constraints CK_Picklist_PicklistType_PickListTypes : ([PicklistType]='G' OR [PicklistType]='E' OR [PicklistType]='U')](../../../../Images/c-constraint.png) | PicklistType | char(1) | 1 | NOT NULL | | | Can 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 |
| MaxMRU | smallint | 2 | NOT NULL | | | How 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') Check Constraints CK_Picklist_PreventAddFlag_Yes_Or_No : ([PreventAddFlag]='N' OR [PreventAddFlag]='Y')](../../../../Images/c-constraint.png) | PreventAddFlag | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Picklist_IsEntryInactiveFLAG_Yes_Or_No : ([IsEntryInactiveFLAG]='N' OR [IsEntryInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsEntryInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the item in the picklist Inactive or not |
| LOINCCode | varchar(10) | 10 | NOT NULL | | ('') | LOINC Code |
| SNOMEDCode | varchar(18) | 18 | NOT NULL | | ('') | SNOMED Code |