MedicalAdditionalAsthmaDetailsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MedicalAdditionalAsthmaDetailsHistorySeq int identity 4 √ null
MedicalAdditionalAsthmaDetailsSeq int 4 null
MedicalConditionSeq int 4 √ null
ID int 4 √ null
AsthmaCategory varchar 5 √ null
LastHospitalisationDate datetime 16,3 √ null
AsthmaTriggers varchar 2147483647 √ null
AsthmaNormalPeakFlow smallint 2 √ null
AsthmaLowPeakFlow smallint 2 √ null
AsthmaDoctorPeakFlow smallint 2 √ null
UsePolicyForEmergencyTreatmentFlag bit 1 √ null
UseFollowingTreatmentInstructionsFlag bit 1 √ null
AsthmaAction varchar 2147483647 √ null
AsthmaActionPlanDocumentID int 4 √ null
ModifiedBy int 4 √ null
ModifiedDate datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_MedicalAdditionalAsthmaDetailsHistory_MedicalAdditionalAsthmaDetailsHistorySeq Primary key Asc MedicalAdditionalAsthmaDetailsHistorySeq