Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
| lang | nvarchar(1) | 2 | NOT NULL | E - English |
 | nodekey | nvarchar(20) | 40 | NOT NULL | Hierarchical key to the terms |
 | medcinid | int | 4 | NOT NULL | Internal Identifier for the term |
| subs | nvarchar(1) | 2 | NULL allowed | + - has children |
| termtype | tinyint | 1 | NOT NULL | Type of Term |
| rxcode | nvarchar(1) | 2 | NULL allowed | Medication Code |
| gender | nvarchar(1) | 2 | NULL allowed | Gender. M - Male, F - Female |
 | description | nvarchar(120) | 240 | NOT NULL | Term Description |