tMedicalDetailsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Seq int identity 4 √ null
Comment varchar 50 √ null
ID int 4 null
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 50 √ null
OperationConsentFlag bit 1 null
AnaestheticConsentFlag bit 1 null
BloodConsentFlag bit 1 null
BloodGroup varchar 3 null
ConsentRefusalComment varchar 2147483647 √ null
ParacetamolConsentFlag bit 1 null
PrivateInsuranceFlag bit 1 null
PrivateInsuranceFund varchar 5 null
PrivateInsuranceNo varchar 30 null
MedicareNo varchar 12 null
AmbulanceFlag bit 1 null
AmbulanceNo varchar 12 null
ImmunisationFormFlag bit 1 null
ImmunisationFormDate datetime 16,3 √ null
SwimOKFlag bit 1 null
TetanusImmunisationFlag bit 1 null
TetanusImmunisationDate datetime 16,3 √ null
HepACourseImmunisationFlag bit 1 null
HepACourseImmunisationDate datetime 16,3 √ null
HepBCourseImmunisationFlag bit 1 null
HepBCourseImmunisationDate datetime 16,3 √ null
MMRImmunisationFlag bit 1 null
MMRImmunisationDate datetime 16,3 √ null
MeaslesImmunisationFlag bit 1 null
MeaslesImmunisationDate datetime 16,3 √ null
MumpsImmunisationFlag bit 1 null
MumpsImmunisationDate datetime 16,3 √ null
RubellaImmunisationFlag bit 1 null
RubellaImmunisationDate datetime 16,3 √ null
DiptheriaImmunisationFlag bit 1 null
DiptheriaImmunisationDate datetime 16,3 √ null
WhoopingImmunisationFlag bit 1 null
WhoopingImmunisationDate datetime 16,3 √ null
PoliomyelitisImmunisationFlag bit 1 null
PoliomyelitisImmunisationDate datetime 16,3 √ null
TuberculosisImmunisationFlag bit 1 null
TuberculosisImmunisationDate datetime 16,3 √ null
CholeraImmunisationFlag bit 1 null
CholeraImmunisationDate datetime 16,3 √ null
TyphoidImmunisationFlag bit 1 null
TyphoidImmunisationDate datetime 16,3 √ null
ADTImmunisationFlag bit 1 null
ADTImmunisationDate datetime 16,3 √ null
InfluenzaImmunisationFlag bit 1 null
InfluenzaImmunisationDate datetime 16,3 √ null
HearingTestDate datetime 16,3 √ null
HearingTestResult varchar 2147483647 √ null
HearingAidFlag bit 1 null
EyeTestDate datetime 16,3 √ null
EyeTestResult varchar 2147483647 √ null
EyeGlassesFlag bit 1 null
EyeContactLensesFlag bit 1 null
SpeechTestDate datetime 16,3 √ null
SpeechTestResult varchar 2147483647 √ null
AsthmaCategory varchar 5 null
AsthmaTriggers varchar 2147483647 √ null
AsthmaPreventionMedication varchar 2147483647 √ null
AsthmaReliefMedication varchar 2147483647 √ null
AsthmaNormalPeakFlow smallint 2 null
AsthmaLowPeakFlow smallint 2 null
AsthmaDoctorPeakFlow smallint 2 null
AsthmaAction varchar 2147483647 √ null
AsthmaUsualSymptoms varchar 2147483647 √ null
AsthmaWorseningSymptoms varchar 2147483647 √ null
AsthmaHospitalDate datetime 16,3 √ null
Allergies varchar 2147483647 √ null
SurgicalHistory varchar 2147483647 √ null
MedicalHistory varchar 2147483647 √ null
Medications varchar 2147483647 √ null
ReligiousRequirements varchar 2147483647 √ null
Diet varchar 2147483647 √ null
FamilyBackground varchar 2147483647 √ null
Disabilities varchar 2147483647 √ null
EmotionalProblems varchar 2147483647 √ null
GlandularChronicFlag bit 1 null
GlandularChronicDetails varchar 2147483647 √ null
EpistaxisFlag bit 1 null
EpistaxisDetails varchar 2147483647 √ null
EczemaFlag bit 1 null
EczemaDetails varchar 2147483647 √ null
DiabetesFlag bit 1 null
DiabetesDetails varchar 2147483647 √ null
PeriodPainFlag bit 1 null
PeriodPainDetails varchar 2147483647 √ null
TravelSicknessFlag bit 1 null
TravelSicknessDetails varchar 2147483647 √ null
ChickenPoxImmunisationFlag bit 1 null
ChickenPoxImmunisationDate datetime 16,3 √ null
HeadInjuriesFlag bit 1 null
HeadInjuriesDetails varchar 2147483647 √ null
EpilepsyFlag bit 1 null
EpilepsyDetails varchar 2147483647 √ null
MigraineFlag bit 1 null
MigraineDetails varchar 2147483647 √ null
Fractures varchar 2147483647 √ null
Joints varchar 2147483647 √ null
Arthritis varchar 2147483647 √ null
Miscellaneous varchar 2147483647 √ null
DTPImmunisationFlag bit 1 null
DTPImmunisationDate datetime 16,3 √ null
Swim50Metres varchar 3 null
MedicareLineNo tinyint 1 null
MedicareExpiryDate datetime 16,3 √ null
HearingTestFlag bit 1 null
EyeTestFlag bit 1 null
MedicalBraceletFlag bit 1 null
HeartConditionFlag bit 1 null
HIBImmunisationFlag bit 1 null
HIBImmunisationDate datetime 16,3 √ null
PrivateInsuranceExtraCoverFlag bit 1 null
PrivateInsuranceTable varchar 30 null
SpeechTestFlag bit 1 null
MedicalConsentFlag bit 1 null
AmbulanceConsentFlag bit 1 null
SportConsentFlag bit 1 null
MeningococcalCImmunisationFlag bit 1 null
MeningococcalCImmunisationDate datetime 16,3 √ null
JapaneseEncephalitisImmunisationFlag bit 1 null
JapaneseEncephalitisImmunisationDate datetime 16,3 √ null
YellowFeverImmunisationFlag bit 1 null
YellowFeverImmunisationDate datetime 16,3 √ null
Anaphylaxis varchar 2147483647 √ null
ImmunisationFormStatus varchar 15 √ null
PneumococcalImmunisationFlag bit 1 null
PneumococcalImmunisationDate datetime 16,3 √ null
MedicationFlag bit 1 null
BloodDisorders varchar 2147483647 √ null
HeartCondition varchar 2147483647 √ null
Blackouts varchar 2147483647 √ null
Pyschological varchar 2147483647 √ null
Sleepwalking varchar 2147483647 √ null
NotifiedMedicalAlertFlag bit 1 null
NotifiedMedicalAlertDetails varchar 2147483647 √ null
SwimMetres smallint 2 √ null
ImmunisationOtherDetails varchar 2147483647 √ null
AsthmaFlag bit 1 null
JointsFlag bit 1 null
HayfeverFlag bit 1 null
AllergyMedicationFlag bit 1 null
AllergyFoodFlag bit 1 null
AllergyStingsFlag bit 1 null
AllergyBitesFlag bit 1 null
AllergyOtherFlag bit 1 null
BloodDisordersFlag bit 1 null
SleepwalkingFlag bit 1 null
BlackoutsFlag bit 1 null
PsychologicalFlag bit 1 null
MiscellaneousFlag bit 1 null
Hayfever varchar 2147483647 √ null
AnaphylaxisFlag bit 1 null
FamilyBackgroundFlag bit 1 null
ReligiousRequirementsFlag bit 1 null
DietFlag bit 1 null
DisabilitiesFlag bit 1 null
EmotionalProblemsFlag bit 1 null
SurgicalHistoryFlag bit 1 null
MedicalHistoryFlag bit 1 null
FracturesFlag bit 1 null
ArthritisFlag bit 1 null
AllergicRhinitisFlag bit 1 null
AllergicRhinitisDetails varchar 2147483647 √ null
ChickenPoxFlag bit 1 null
ChickenPoxDetails varchar 2147483647 √ null
EnuresisFlag bit 1 null
EnuresisDetails varchar 2147483647 √ null
HaemophiliaFlag bit 1 null
HaemophiliaDetails varchar 2147483647 √ null
HepatitisFlag bit 1 null
HepatitisDetails varchar 2147483647 √ null
MeaslesFlag bit 1 null
MeaslesDetails varchar 2147483647 √ null
MumpsFlag bit 1 null
MumpsDetails varchar 2147483647 √ null
RecurrentEarInfectionsFlag bit 1 null
RecurrentEarInfectionsDetails varchar 2147483647 √ null
RespiratoryFlag bit 1 null
RespiratoryDetails varchar 2147483647 √ null
RheumaticFeverFlag bit 1 null
RheumaticFeverDetails varchar 2147483647 √ null
RubellaFlag bit 1 null
RubellaDetails varchar 2147483647 √ null
SkinComplaintsFlag bit 1 null
SkinComplaintsDetails varchar 2147483647 √ null
WhoopingCoughFlag bit 1 null
WhoopingCoughDetails varchar 2147483647 √ null
NephritisFlag bit 1 null
NephritisDetails varchar 2147483647 √ null
AsthmaDetails varchar 2147483647 √ null
SchoolDentistConsentFlag bit 1 null
SchoolNurseConsentFlag bit 1 null
AsthmaMedicationRequiredFlag bit 1 null
AsthmaMedicationRequiredDetails varchar 2147483647 √ null
AsthmaRequiredMedicationDosageDetails varchar 2147483647 √ null
AsthmaMedicationAdministrationCode varchar 20 null
AsthmaPreExerciseMedicationRequiredFlag bit 1 null
AsthmaPreExerciseMedicationRequiredDetails varchar 2147483647 √ null
AsthmaPreExerciseMedicationDosageDetails varchar 2147483647 √ null
AsthmaPreExerciseMedicationAdministrationCode varchar 20 null
AsthmaWheezingFlag bit 1 null
AsthmaWheezingDetails varchar 2147483647 √ null
AsthmaChestTightnessFlag bit 1 null
AsthmaChestTightnessDetails varchar 2147483647 √ null
AsthmaCoughingFlag bit 1 null
AsthmaCoughingDetails varchar 2147483647 √ null
AsthmaBreathingDifficultyFlag bit 1 null
AsthmaBreathingDifficultyDetails varchar 2147483647 √ null
AsthmaOtherFlag bit 1 null
AsthmaOtherDetails varchar 2147483647 √ null
AsthmaUsePolicyForEmergencyTreatmentFlag bit 1 null
AsthmaUseFollowingTreatmentInstructionsFlag bit 1 null
AsthmaUseFollowingTreatmentInstructionsDetails varchar 2147483647 √ null
AsthmaPreventionFlag bit 1 null
AsthmaReliefFlag bit 1 null
AsthmaWorseningSymptomsFlag bit 1 null
AsthmaUsualSymptomsFlag bit 1 null
PrivateHealthFundExpiryDate datetime 16,3 √ null
MeningitisImmunisationFlag bit 1 null
MeningitisImmunisationDate datetime 16,3 √ null
AllergiesFlag bit 1 null
ChronicFatigueFlag bit 1 null
ChronicFatigueDetails varchar 2147483647 √ null
MedicationsDosageDetails varchar 2147483647 √ null
MedicationsAdministrationCode varchar 20 null
AllergiesTreatmentDetails varchar 2147483647 √ null
HPVImmunisationFlag bit 1 null
HPVImmunisationDate datetime 16,3 √ null
ADHDFlag bit 1 √ null
ADHDDetails varchar 2147483647 √ null
SwineFluImmunisationFlag bit 1 ((0))
SwineFluImmunisationDate datetime 16,3 √ null
SpeechImpairmentFlag bit 1 ((0))
MeningococcalBImmunisationFlag bit 1 ((0))
MeningococcalBImmunisationDate datetime 16,3 √ null
EpinephrineAutoInjectorFlag bit 1 ((0))
EpinephrineAutoInjectorExpiryDate datetime 16,3 √ null
EpinephrineAutoInjectorDetails varchar 2147483647 √ null
AsthmaTalkingDifficultyFlag bit 1 ((0))
AsthmaTalkingDifficultyDetails text 2147483647 √ null
dTpaImmunisationFlag bit 1 ((0))
dTpaImmunisationDate datetime 16,3 √ null
TWINRIXImmunisationFlag bit 1 ((0))
TWINRIXImmunisationDate datetime 16,3 √ null
TWINRIXAdultImmunisationFlag bit 1 ((0))
TWINRIXAdultImmunisationDate datetime 16,3 √ null
HepACourseAdultImmunisationFlag bit 1 ((0))
HepACourseAdultImmunisationDate datetime 16,3 √ null
HepBCourseAdultImmunisationFlag bit 1 ((0))
HepBCourseAdultImmunisationDate datetime 16,3 √ null
4vMenPVImmunisationFlag bit 1 ((0))
4vMenPVImmunisationDate datetime 16,3 √ null
ViVaximImmunisationFlag bit 1 ((0))
ViVaximImmunisationDate datetime 16,3 √ null
RabiesImmunisationFlag bit 1 ((0))
RabiesImmunisationDate datetime 16,3 √ null
CustomImmunisation1Flag bit 1 ((0))
CustomImmunisation1Date datetime 16,3 √ null
CustomImmunisation2Flag bit 1 ((0))
CustomImmunisation2Date datetime 16,3 √ null
CustomImmunisation3Flag bit 1 ((0))
CustomImmunisation3Date datetime 16,3 √ null
CustomImmunisation4Flag bit 1 ((0))
CustomImmunisation4Date datetime 16,3 √ null
CustomImmunisation5Flag bit 1 ((0))
CustomImmunisation5Date datetime 16,3 √ null
DisabilityLevel varchar 15 ('')
HealthCareCardFlag bit 1 ((0))
HealthCareCardNo varchar 30 ('')
HealthCareCardExpiryDate datetime 16,3 √ null
GastricFlag bit 1 ((0))
GastricDetails varchar 2147483647 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_tMedicalDetailsHistory Primary key Asc Seq
AK_tMedicalDetailsHistory_ID Performance Asc/Asc ID + ModifiedDate