Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| MedicalDetailsSeq | int | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| StudentMedicalAlert | varchar | 2000 | null |
|
|
|||
| StudentMedicalAlertFlag | bit | 1 | null |
|
|
|||
| AmbulanceFlag | bit | 1 | √ | null |
|
|
||
| AmbulanceNo | varchar | 12 | null |
|
|
|||
| BloodGroup | varchar | 3 | null |
|
|
|||
| DisabilityLevel | varchar | 15 | null |
|
|
|||
| DisabilityLevelDescription | varchar | 50 | null |
|
|
|||
| HealthCareCardFlag | bit | 1 | √ | null |
|
|
||
| HealthCareCardNo | varchar | 30 | null |
|
|
|||
| HealthCareCardExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| MedicareNo | varchar | 12 | null |
|
|
|||
| MedicareLineNo | tinyint | 1 | null |
|
|
|||
| MedicareExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| PrivateInsuranceFlag | bit | 1 | √ | null |
|
|
||
| PrivateInsuranceFund | varchar | 5 | null |
|
|
|||
| PrivateInsuranceFundDescription | varchar | 30 | null |
|
|
|||
| PrivateInsuranceNo | varchar | 30 | null |
|
|
|||
| PrivateInsuranceTable | varchar | 30 | null |
|
|
|||
| PrivateInsuranceExtraCoverFlag | bit | 1 | null |
|
|
|||
| PrivateHealthFundExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| Doctor1Name | varchar | 80 | null |
|
|
|||
| Doctor1Address | varchar | 200 | null |
|
|
|||
| Doctor1Phone | varchar | 15 | null |
|
|
|||
| Doctor1PhoneAlt | varchar | 15 | null |
|
|
|||
| Doctor1Specialisation | varchar | 50 | null |
|
|
|||
| Doctor2Name | varchar | 80 | null |
|
|
|||
| Doctor2Address | varchar | 200 | null |
|
|
|||
| Doctor2Phone | varchar | 15 | null |
|
|
|||
| Doctor2PhoneAlt | varchar | 15 | null |
|
|
|||
| Doctor2Specialisation | varchar | 50 | null |
|
|
|||
| DentistName | varchar | 80 | null |
|
|
|||
| DentistAddress | varchar | 200 | null |
|
|
|||
| DentistPhone | varchar | 15 | null |
|
|
|||
| DentistPhoneAlt | varchar | 15 | null |
|
|
|||
| Emergency1Name | varchar | 80 | null |
|
|
|||
| Emergency1Address | varchar | 200 | null |
|
|
|||
| Emergency1Phone | varchar | 15 | null |
|
|
|||
| Emergency1PhoneAlt | varchar | 15 | null |
|
|
|||
| Emergency1Relationship | varchar | 30 | null |
|
|
|||
| Emergency2Name | varchar | 80 | null |
|
|
|||
| Emergency2Address | varchar | 200 | null |
|
|
|||
| Emergency2Phone | varchar | 15 | null |
|
|
|||
| Emergency2PhoneAlt | varchar | 15 | null |
|
|
|||
| Emergency2Relationship | varchar | 30 | null |
|
|
|||
| Emergency3Name | varchar | 80 | null |
|
|
|||
| Emergency3Address | varchar | 200 | null |
|
|
|||
| Emergency3Phone | varchar | 15 | null |
|
|
|||
| Emergency3PhoneAlt | varchar | 15 | null |
|
|
|||
| Emergency3Relationship | varchar | 30 | null |
|
|
|||
| HealthcareRecordNumber | bigint | 8 | √ | null |
|
|
Table contained 0 rows