Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedBy | int | 4 | √ | null |
|
|
||
| BloodGroup | varchar | 3 | √ | 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 |
|
|
||
| MedicareLineNo | tinyint | 1 | √ | null |
|
|
||
| MedicareExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| PrivateInsuranceExtraCoverFlag | bit | 1 | √ | null |
|
|
||
| PrivateInsuranceTable | varchar | 30 | √ | null |
|
|
||
| PrivateInsuranceDescription | varchar | 30 | √ | null |
|
|
||
| EnrolDate | datetime | 16,3 | √ | null |
|
|
||
| FutureEnrolYear | int | 4 | √ | null |
|
|
||
| FutureStatus | varchar | 3 | null |
|
|
|||
| Boarder | varchar | 3 | null |
|
|
|||
| BoardingHouse | varchar | 15 | null |
|
|
|||
| Campus | varchar | 3 | null |
|
|
|||
| House | varchar | 5 | null |
|
|
|||
| Tutor | varchar | 15 | null |
|
|
|||
| Form | varchar | 15 | null |
|
|
|||
| FullFeeFlag | bit | 1 | null |
|
|
|||
| FutureYearLevel | smallint | 2 | √ | null |
|
|
||
| FutureDoctorName | varchar | 80 | null |
|
|
|||
| FutureDoctorPhone | varchar | 15 | null |
|
|
|||
| FutureDoctorAddress | varchar | 200 | null |
|
|
|||
| FutureEmergencyName | varchar | 80 | null |
|
|
|||
| FutureEmergencyAddress | varchar | 200 | null |
|
|
|||
| FutureEmergencyPhone | varchar | 15 | null |
|
|
|||
| FutureEmergencyPhoneAlt | varchar | 15 | null |
|
|
|||
| FutureEmergencyRelat | varchar | 5 | null |
|
|
|||
| FutureEmergency2Name | varchar | 80 | null |
|
|
|||
| FutureEmergency2Address | varchar | 200 | null |
|
|
|||
| FutureEmergency2Phone | varchar | 15 | null |
|
|
|||
| FutureEmergency2PhoneAlt | varchar | 15 | null |
|
|
|||
| FutureEmergency2Relat | varchar | 5 | null |
|
|
|||
| FutureMedicalAlert | varchar | 2000 | √ | null |
|
|
||
| FutureMedicalAlertFlag | bit | 1 | null |
|
|
|||
| LegalPhotoWebFlag | bit | 1 | √ | null |
|
|
||
| LegalPhotoPromFlag | bit | 1 | √ | null |
|
|
||
| LegalPhotoPublicationFlag | bit | 1 | √ | null |
|
|
||
| CourtOrderType | varchar | 15 | √ | null |
|
|
||
| FutureStudentAddressComma | varchar | 200 | √ | null |
|
|
||
| FutureStudentHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| AddressFull | varchar | 200 | √ | null |
|
|
||
| FutureSurname | varchar | 30 | √ | null |
|
|
||
| FutureTitle | varchar | 30 | √ | null |
|
|
||
| FuturePreferred | varchar | 20 | √ | null |
|
|
||
| FutureGiven1 | varchar | 20 | √ | null |
|
|
||
| FutureGiven2 | varchar | 50 | √ | null |
|
|
||
| FutureBirthDate | datetime | 16,3 | √ | null |
|
|
||
| FutureGender | varchar | 15 | √ | null |
|
|
||
| FutureMobilePhone | varchar | 15 | √ | null |
|
|
||
| FuturePhoneActual | varchar | 15 | √ | null |
|
|
||
| FutureEmail | varchar | 100 | √ | null |
|
|
||
| StudentEmergencyMobilePhone | varchar | 15 | √ | null |
|
|
||
| MailNamePrimary | varchar | 100 | √ | null |
|
|
||
| FutureContactType | varchar | 3 | √ | null |
|
|
||
| LivesWithFlag | bit | 1 | √ | null |
|
|
||
| ReportsFlag | bit | 1 | √ | null |
|
|
||
| NormalMailFlag | bit | 1 | √ | null |
|
|
||
| NewArrivalsProgramFlag | bit | 1 | √ | null |
|
|
||
| SubSchool | varchar | 15 | √ | null |
|
|
||
| PrivateHealthFundExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| ImmunisationFormStatus | varchar | 15 | √ | null |
|
|
||
| ImmunisationOtherDetails | varchar | 2147483647 | √ | null |
|
|
||
| DisabilityLevel | varchar | 15 | √ | null |
|
|
||
| DisabilityLevelDescription | varchar | 50 | √ | null |
|
|
||
| HealthCareCardFlag | bit | 1 | √ | null |
|
|
||
| HealthCareCardNo | varchar | 30 | √ | null |
|
|
||
| HealthCareCardExpiryDate | datetime | 16,3 | √ | null |
|
|
Table contained 0 rows