Tables [dbo].[search]
Medcin Terminology Terms
KeyNameData TypeMax Length (Bytes)NullabilityDescription
langnvarchar(1)2NOT NULLE - English
Indexes IX_search_nodekeynodekeynvarchar(20)40NOT NULLHierarchical key to the terms
Cluster Primary Key PK_Search_medcinid: medcinidmedcinidint4NOT NULLInternal Identifier for the term
subsnvarchar(1)2NULL allowed+ - has children
termtypetinyint1NOT NULLType of Term
rxcodenvarchar(1)2NULL allowedMedication Code
gendernvarchar(1)2NULL allowedGender. M - Male, F - Female
Indexes IX_search_descriptiondescriptionnvarchar(120)240NOT NULLTerm Description