MedicalDetailsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MedicalDetailsHistorySeq int identity 4 √ null
MedicalDetailsSeq int 4 √ null
ID int 4 null
AmbulanceFlag bit 1 √ null
AmbulanceNo varchar 12 √ null
BloodGroup varchar 3 √ null
ConsentRefusalComment varchar 2147483647 √ null
DisabilityLevel varchar 15 √ null
HealthCareCardExpiryDate datetime 16,3 √ null
HealthCareCardFlag bit 1 √ null
HealthCareCardNo varchar 30 √ null
ImmunisationFormDate datetime 16,3 √ null
ImmunisationFormFlag bit 1 √ null
ImmunisationFormStatus varchar 15 √ null
ImmunisationOtherDetails varchar 2147483647 √ null
MedicareExpiryDate datetime 16,3 √ null
MedicareLineNo tinyint 1 √ null
MedicareNo varchar 12 √ null
PrivateHealthFundExpiryDate datetime 16,3 √ null
PrivateInsuranceExtraCoverFlag bit 1 √ null
PrivateInsuranceFlag bit 1 √ null
PrivateInsuranceFund varchar 5 √ null
PrivateInsuranceNo varchar 30 √ null
PrivateInsuranceTable varchar 30 √ null
ModifiedBy int 4 √ null
ModifiedDate datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_MedicalDetailsHistory_MedicalDetailsHistorySeq Primary key Asc MedicalDetailsHistorySeq