| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1EDRUG | IS-H*MED: Drug Event - Drug Assignment | 7 | DRUGTYP | Type of Ingredient | nvarchar | 1 | 0 | | |
| 2 | N1FOFOA | IS-H*MED: (O B S O L E T E) Ingredient - Drug Assignment | 4 | DRUGTYP | Medication: Type of Ingredient | nvarchar | 1 | 0 | | |
| 3 | N1INGFOA | i.s.h.med: Medication, Ingredient - Drug Assignment | 5 | DRUGTYP | Medication: Type of Ingredient | nvarchar | 1 | 0 | | |
| 4 | N1ODRUG | IS-H*MED: Medication, Drugs of Order | 6 | DRUGTYP | Type of Ingredient | nvarchar | 1 | 0 | | |
| 5 | N1TPODRUG | IS-H*MED: Medication, Drugs of Templates | 6 | DRUGTYP | Type of Ingredient | nvarchar | 1 | 0 | | |
