Students


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 ((0))
StudentYears.ID FK_StudentYears_ID R
Community.ID FK_Students_Community R
CreatedDate datetime 16,3 √ null
CreatedBy varchar 50 √ ('')
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 50 √ ('')
Operator varchar 30 ('')
StudiesCode varchar 15 ('')
TertiaryRegistrationCode varchar 15 ('')
TimeTableCode varchar 15 ('')
AltCode varchar 15 ('')
DebtorID int 4 ((0))
DebtorIDSeq smallint 2 ((0))
N16StuCode varchar 50 ('')
N16ParCode varchar 50 ('')
N16DebCode varchar 50 ('')
AgeYearsJan smallint 2 ((0))
AgeMonthsJan smallint 2 ((0))
FamilyPosition smallint 2 ((0))
EldestFlag bit 1 ((0))
YoungestFlag bit 1 ((0))
EntryDate datetime 16,3 √ null
EntryCampus varchar 3 ('')
EntryYearLevel smallint 2 √ null
EnquirySource varchar 10 ('')
EnquirySourceComment varchar 50 ('')
PreviousSchool varchar 15 ('')
MedicalAlert varchar 2000 √ ('')
ExternalStudentFlag bit 1 ((0))
EnglishSecondFlag bit 1 ((0))
DisabilityFlag bit 1 ((0))
FullFeeFlag bit 1 ((0))
TuitionVariationType varchar 3 ('')
TuitionNoSibFlag bit 1 ((0))
DoctorName varchar 80 ('')
DoctorPhone varchar 15 ('')
DoctorPhoneAlt varchar 15 ('')
DoctorAddress varchar 200 ('')
DoctorSpecialisation varchar 50 ('')
Doctor2Name varchar 80 ('')
Doctor2Phone varchar 15 ('')
Doctor2PhoneAlt varchar 15 ('')
Doctor2Address varchar 200 ('')
Doctor2Specialisation varchar 50 ('')
DentistName varchar 80 ('')
DentistPhone varchar 15 ('')
DentistPhoneAlt varchar 15 ('')
DentistAddress varchar 200 ('')
EmergencyName varchar 80 ('')
EmergencyAddress varchar 200 ('')
EmergencyPhone varchar 15 ('')
EmergencyPhoneAlt varchar 15 ('')
EmergencyRelat varchar 5 √ ('')
Emergency2Name varchar 80 ('')
Emergency2Address varchar 200 ('')
Emergency2Phone varchar 15 ('')
Emergency2PhoneAlt varchar 15 ('')
Emergency2Relat varchar 5 √ ('')
LastLessonRcvdDate datetime 16,3 √ null
BirthCertificateFlag bit 1 ((0))
NonResidentFlag bit 1 ((0))
CrecheFlag bit 1 ((0))
BeforeSchoolCareFlag bit 1 ((0))
AfterSchoolCareFlag bit 1 ((0))
VisaType varchar 5 ('')
VisaExpiryDate datetime 16,3 √ null
PassportNo varchar 15 ('')
Comment varchar 2147483647 √ null
CommentWarningFlag bit 1 ((0))
BaptismFlag bit 1 ((0))
BaptismDate datetime 16,3 √ null
ReconciliationFlag bit 1 ((0))
ReconciliationDate datetime 16,3 √ null
CommunionFlag bit 1 ((0))
CommunionDate datetime 16,3 √ null
ConfirmationFlag bit 1 ((0))
ConfirmationDate datetime 16,3 √ null
AustudyFlag bit 1 ((0))
IndigenousFlag bit 1 ((0))
NaturalisationDate datetime 16,3 √ null
DebtorPrimaryOnlyFlag bit 1 ((0))
StudentBillingFlag bit 1 ((0))
AllowAutoTuitionFlag bit 1 ((1))
AllowAutoChargesFlag bit 1 ((1))
VisaNumber varchar 20 ('')
PassportCountryCode varchar 5 ('')
PassportExpiryDate datetime 16,3 √ null
ApplicationDate datetime 16,3 √ null
Emergency3Name varchar 80 ('')
Emergency3Address varchar 200 ('')
Emergency3Phone varchar 15 ('')
Emergency3PhoneAlt varchar 15 ('')
Emergency3Relat varchar 5 ('')
MedicalAlertFlag bit 1 ((0))
SpecialNeedsFlag bit 1 ((0))
SpecialBillingType varchar 5 ('')
StudyAtHomeFlag bit 1 ((0))
TSIFlag bit 1 ((0))
ESLProficiencyLevel varchar 15 ('')
PreEntryComment varchar 2147483647 √ null
EnquiryDate datetime 16,3 √ null
IntendsTertiaryFlag bit 1 ((0))
PassportIssuedDate datetime 16,3 √ null
VisaIssuedDate datetime 16,3 √ null
EmergencyID int 4 ((0))
Emergency2ID int 4 ((0))
Emergency3ID int 4 ((0))
LastRequestedDetailsDate datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK__Students__0AD36B5C Primary key Asc ID
AK_Students_DebtorID Performance Asc DebtorID
AK_Students_Emergency2ID Performance Asc Emergency2ID
AK_Students_Emergency3ID Performance Asc Emergency3ID
AK_Students_EmergencyID Performance Asc EmergencyID
AK_StudentsTimeTableCode Performance Asc TimeTableCode
AltCode Performance Asc AltCode

Relationships

Close relationships within degrees of separation