Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentID | int | 4 | null |
|
|
|||
| TransportAMPM | varchar | 5 | null |
|
|
|||
| TransportSeq | smallint | 2 | null |
|
|
|||
| TransportCode | varchar | 15 | null |
|
|
|||
| TransportCodeDescription | varchar | 50 | √ | null |
|
|
||
| TransportDescription | varchar | 255 | null |
|
|
|||
| StudentTransportFeeCode | varchar | 15 | √ | null |
|
|
||
| TransportTravelFactor | decimal | 11,8 | null |
|
|
|||
| TransportTravelMondayFlag | bit | 1 | null |
|
|
|||
| TransportTravelTuesdayFlag | bit | 1 | null |
|
|
|||
| TransportTravelWednesdayFlag | bit | 1 | null |
|
|
|||
| TransportTravelThursdayFlag | bit | 1 | null |
|
|
|||
| TransportTravelFridayFlag | bit | 1 | null |
|
|
|||
| TransportTravelSaturdayFlag | bit | 1 | null |
|
|
|||
| TransportTravelSundayFlag | bit | 1 | null |
|
|
|||
| StudentTransportTravelDistance | decimal | 8,2 | null |
|
|
|||
| TransportOverrideTravelDistanceFlag | bit | 1 | null |
|
|
|||
| TransportStopCode | varchar | 30 | null |
|
|
|||
| TransportStopDescription | varchar | 100 | √ | null |
|
|
||
| TransportStopSortOrder | smallint | 2 | √ | null |
|
|
||
| TransportStopTravelDistance | decimal | 8,2 | √ | null |
|
|
||
| StudentTravelAllowanceFlag | bit | 1 | null |
|
|
|||
| StudentNameInternal | varchar | 100 | null |
|
|
|||
| StudentNameExternal | varchar | 100 | null |
|
|
|||
| StudentLegalFullName | varchar | 150 | null |
|
|
|||
| StudentGiven1 | varchar | 20 | null |
|
|
|||
| StudentGiven2 | varchar | 50 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentPreferredFormal | varchar | 20 | null |
|
|
|||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StudentBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentHomeAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentHomeAddressFull | varchar | 200 | √ | null |
|
|
||
| FileYear | smallint | 2 | null |
|
|
|||
| StudentStatus | varchar | 3 | null |
|
|
|||
| StudentStatusNextYear | varchar | 3 | null |
|
|
|||
| StudentCampus | varchar | 3 | null |
|
|
|||
| StudentCampusDescription | varchar | 30 | √ | null |
|
|
||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentYearLevelDescription | varchar | 30 | √ | null |
|
|
||
| StudentYearLevelSort | smallint | 2 | null |
|
|
|||
| StudentHouse | varchar | 5 | null |
|
|
|||
| StudentForm | varchar | 15 | null |
|
|
|||
| StudentTutor | varchar | 15 | null |
|
|
|||
| StudentBoarder | varchar | 3 | null |
|
|
|||
| StudentBoarderType | varchar | 30 | √ | null |
|
|
||
| StudentBoardingHouse | varchar | 15 | null |
|
|
|||
| StudentFamilyPosition | smallint | 2 | null |
|
|
|||
| StudentLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentReturningDate | datetime | 16,3 | √ | null |
|
|
||
| StudentLeavingReason | varchar | 3 | null |
|
|
|||
| StudentLeavingDestination | varchar | 15 | null |
|
|
|||
| StudentEntryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentEntryCampus | varchar | 3 | null |
|
|
|||
| StudentEntryYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentMedicalAlert | varchar | 2000 | √ | null |
|
|
||
| StudentFullFeeFlag | bit | 1 | null |
|
|
|||
| StudentIntendsTertiaryFlag | bit | 1 | null |
|
|
|||
| StudentDoctorName | varchar | 80 | null |
|
|
|||
| StudentDoctorPhone | varchar | 15 | null |
|
|
|||
| StudentDoctorPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentDoctorAddress | varchar | 200 | null |
|
|
|||
| StudentDoctorSpecialisation | varchar | 50 | null |
|
|
|||
| StudentDoctor2Name | varchar | 80 | null |
|
|
|||
| StudentDoctor2Phone | varchar | 15 | null |
|
|
|||
| StudentDoctor2PhoneAlt | varchar | 15 | null |
|
|
|||
| StudentDoctor2Address | varchar | 200 | null |
|
|
|||
| StudentDoctor2Specialisation | varchar | 50 | null |
|
|
|||
| StudentDentistName | varchar | 80 | null |
|
|
|||
| StudentDentistPhone | varchar | 15 | null |
|
|
|||
| StudentDentistPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentDentistAddress | varchar | 200 | null |
|
|
|||
| StudentEmergencyName | varchar | 80 | null |
|
|
|||
| StudentEmergencyAddress | varchar | 200 | null |
|
|
|||
| StudentEmergencyPhone | varchar | 15 | null |
|
|
|||
| StudentEmergencyPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentEmergencyRelat | varchar | 5 | √ | null |
|
|
||
| StudentEmergency2Name | varchar | 80 | null |
|
|
|||
| StudentEmergency2Address | varchar | 200 | null |
|
|
|||
| StudentEmergency2Phone | varchar | 15 | null |
|
|
|||
| StudentEmergency2PhoneAlt | varchar | 15 | null |
|
|
|||
| StudentEmergency2Relat | varchar | 5 | √ | null |
|
|
||
| StudentCrecheFlag | bit | 1 | null |
|
|
|||
| StudentBeforeSchoolCareFlag | bit | 1 | null |
|
|
|||
| StudentAfterSchoolCareFlag | bit | 1 | null |
|
|
|||
| StudentEmergency3Name | varchar | 80 | null |
|
|
|||
| StudentEmergency3Address | varchar | 200 | null |
|
|
|||
| StudentEmergency3Phone | varchar | 15 | null |
|
|
|||
| StudentEmergency3PhoneAlt | varchar | 15 | null |
|
|
|||
| StudentEmergency3Relat | varchar | 5 | null |
|
|
|||
| StudentMedicalAlertFlag | bit | 1 | null |
|
|
|||
| StudentSpecialNeedsFlag | bit | 1 | null |
|
|
|||
| StudentStudyAtHomeFlag | bit | 1 | null |
|
|
|||
| StudentIndigenousFlag | bit | 1 | null |
|
|
|||
| StudentTSIFlag | bit | 1 | null |
|
|
|||
| StudentDisabilityFlag | bit | 1 | null |
|
|
|||
| StudentEnglishSecondFlag | bit | 1 | null |
|
|
|||
| StudentESLProficiencyLevel | varchar | 15 | null |
|
|
|||
| StudentESLListeningLevelCode | varchar | 15 | √ | null |
|
|
||
| StudentESLSpeakingLevelCode | varchar | 15 | √ | null |
|
|
||
| StudentESLReadingLevelCode | varchar | 15 | √ | null |
|
|
||
| StudentESLWritingLevelCode | varchar | 15 | √ | null |
|
|
||
| CurrentYearOnlyFlag | int | 4 | null |
|
|
|||
| StudentStudiesCode | varchar | 15 | null |
|
|
|||
| StudentGovernmentStudentNumber | varchar | 15 | √ | null |
|
|
||
| TransportCapacity | int | 4 | √ | null |
|
|
||
| TransportActiveFlag | bit | 1 | √ | null |
|
|
||
| StudentSubSchool | varchar | 15 | √ | null |
|
|
||
| StudentEntrySubSchool | varchar | 15 | √ | null |
|
|
Table contained 0 rows