Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
MedicationSeq | int | 4 | null |
|
|
|||
ID | int | 4 | null |
|
|
|||
Medication | varchar | 50 | null |
|
|
|||
MedicationFlag | bit | 1 | √ | null |
|
|
||
MedicationDescription | varchar | 30 | null |
|
|
|||
MedicationActiveFlag | bit | 1 | √ | null |
|
|
||
MedicationDefaultFlag | bit | 1 | null |
|
|
|||
MedicationSort | tinyint | 1 | null |
|
|
|||
MedicationAdminstrationCode | varchar | 20 | null |
|
|
|||
MedicationAdministrationDescription | varchar | 30 | null |
|
|
|||
MedicationTypeCode | varchar | 20 | null |
|
|
|||
MedicationTypeDescription | varchar | 30 | null |
|
|
|||
MedicationDetails | varchar | 2147483647 | null |
|
|
|||
MedicationDosageDetails | varchar | 2147483647 | null |
|
|
|||
MedicationExpiryDate | datetime | 16,3 | √ | null |
|
|
||
MedicationRecordNumber | bigint | 8 | √ | null |
|
|
Table contained 0 rows