Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EmployeeID | int | 4 | null |
|
|
|||
| EmployeeNameInternal | varchar | 100 | null |
|
|
|||
| EmployeeNameExternal | varchar | 100 | null |
|
|
|||
| EmployeeLegalFullName | varchar | 150 | null |
|
|
|||
| EmployeeSurname | varchar | 30 | null |
|
|
|||
| EmployeeGiven1 | varchar | 20 | null |
|
|
|||
| EmployeeGiven2 | varchar | 50 | null |
|
|
|||
| EmployeePreferred | varchar | 20 | null |
|
|
|||
| EmployeePreferredFormal | varchar | 20 | null |
|
|
|||
| EmployeeName | varchar | 53 | √ | null |
|
|
||
| EmployeeBirthDate | datetime | 16,3 | √ | null |
|
|
||
| EmployeeGender | varchar | 15 | null |
|
|
|||
| EmployeeMobilePhone | varchar | 15 | null |
|
|
|||
| EmployeeDefaultMobilePhone | varchar | 15 | null |
|
|
|||
| EmployeePhone | varchar | 15 | √ | null |
|
|
||
| EmployeeEmail | varchar | 100 | null |
|
|
|||
| EmployeeEducation | varchar | 255 | null |
|
|
|||
| EmployeeQualifications | varchar | 255 | null |
|
|
|||
| EmployeeMailNamePrimary | varchar | 100 | null |
|
|
|||
| StudentFullFeeFlag | bit | 1 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | √ | null |
|
|
||
| StudentYearLevel | 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 |
|
|
||
| EmployeeIsCurrentStudent | varchar | 1 | null |
|
|
|||
| EmployeeIsPastStudent | varchar | 1 | null |
|
|
|||
| WorkExperienceSeq | int | 4 | null |
|
|
|||
| EmployerContact | varchar | 60 | null |
|
|
|||
| EmployerSupervisor | varchar | 60 | null |
|
|
|||
| DateStart | datetime | 16,3 | √ | null |
|
|
||
| DateFinish | datetime | 16,3 | √ | null |
|
|
||
| TimeFrom | varchar | 10 | null |
|
|
|||
| TimeTo | varchar | 10 | null |
|
|
|||
| PayRate | varchar | 10 | null |
|
|
|||
| OccupType | varchar | 15 | null |
|
|
|||
| OccupDescription | varchar | 120 | √ | null |
|
|
||
| ResponsibleStaffID | int | 4 | null |
|
|
|||
| StaffMailName | varchar | 100 | √ | null |
|
|
||
| WorkExperienceComments | varchar | 255 | √ | null |
|
|
||
| EmployerID | int | 4 | √ | null |
|
|
||
| EmployerIDType | varchar | 1 | √ | null |
|
|
||
| EmployerOccupCode | varchar | 15 | √ | null |
|
|
||
| EmployerOccupCompany | varchar | 50 | √ | null |
|
|
||
| EmployerOccupIndustryCode | varchar | 8 | √ | null |
|
|
||
| EmployerMobilePhone | varchar | 15 | √ | null |
|
|
||
| EmployerDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| EmployerPhone | varchar | 15 | √ | null |
|
|
||
| EmployerFax | varchar | 15 | √ | null |
|
|
||
| EmployerEmail | varchar | 100 | √ | null |
|
|
||
| EmployerMailName | varchar | 100 | √ | null |
|
|
||
| EmployerMailSalutation | varchar | 100 | √ | null |
|
|
||
| EmployerAddressFull | varchar | 200 | √ | null |
|
|
||
| EmployerAddressComma | varchar | 200 | √ | null |
|
|
||
| EmployerOccupCompanyAttn | varchar | 40 | √ | null |
|
|
||
| EmployerComment | varchar | 2147483647 | √ | null |
|
|
||
| StudentContactMailName | varchar | 100 | √ | null |
|
|
||
| StudentContactMailSalutation | varchar | 100 | √ | null |
|
|
||
| StudentContactAddressComma | varchar | 200 | √ | null |
|
|
||
| StudentContactAddressFull | varchar | 200 | √ | null |
|
|
||
| StudentContactOccupPhone | varchar | 15 | √ | null |
|
|
||
| StudentContactOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| StudentContactMobilePhone | varchar | 15 | √ | null |
|
|
||
| StudentContactDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| StudentContactHomePhone | varchar | 15 | √ | null |
|
|
||
| StudentSubSchool | varchar | 15 | √ | null |
|
|
||
| EmployeeGenderSynergyMeaning | varchar | 30 | √ | null |
|
|
Table contained 0 rows