Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
MedicalAllergySeq | int | 4 | √ | null |
|
|
||
ID | int | 4 | null |
|
|
|||
MedicalAllergyActive | bit | 1 | √ | null |
|
|
||
AllergyTypeCode | varchar | 50 | null |
|
|
|||
AllergyTypeDescription | varchar | 30 | null |
|
|
|||
AllergyTypeActiveFlag | bit | 1 | null |
|
|
|||
AllergyTypeSort | tinyint | 1 | null |
|
|
|||
AllergyTypeDefaultFlag | bit | 1 | null |
|
|
|||
AllergySeverityCode | varchar | 15 | null |
|
|
|||
AllergySeverityDescription | varchar | 30 | null |
|
|
|||
AllergySeverityActiveFlag | bit | 1 | null |
|
|
|||
AllergySeveritySort | tinyint | 1 | null |
|
|
|||
AllergySeverityDisplayColor | varchar | 10 | null |
|
|
|||
AllergyDescription | varchar | 2147483647 | null |
|
|
|||
AllergyTreatment | varchar | 2147483647 | null |
|
|
|||
SeverityVisibleToStaffFlag | bit | 1 | √ | null |
|
|
||
AllergyRecordNumber | bigint | 8 | √ | null |
|
|
Table contained 0 rows