Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| MedicalAllergySeq | int | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| MedicalAllergyActive | bit | 1 | null |
|
|
|||
| AllergyTypeCode | varchar | 20 | 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