Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ContactID | int | 4 | √ | null |
|
|
||
| AddressID | int | 4 | null |
|
|
|||
| ContactType | varchar | 3 | √ | null |
|
|
||
| ContactMailName | varchar | 100 | √ | null |
|
|
||
| ContactAddressFull | varchar | 200 | √ | null |
|
|
||
| ContactMailSalutation | varchar | 100 | √ | null |
|
|
||
| ContactSurname | varchar | 30 | null |
|
|
|||
| ContactGiven1 | varchar | 20 | null |
|
|
|||
| ContactSpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| ContactSpouseSurname | varchar | 30 | √ | null |
|
|
||
| StudentContactNormalMailFlag | bit | 1 | √ | null |
|
|
||
| ParentFlag | bit | 1 | √ | null |
|
|
||
| Sibling1NameInternal | varchar | 100 | √ | null |
|
|
||
| Sibling2NameInternal | varchar | 100 | √ | null |
|
|
||
| Sibling3NameInternal | varchar | 100 | √ | null |
|
|
||
| Sibling4NameInternal | varchar | 100 | √ | null |
|
|
||
| Sibling5NameInternal | varchar | 100 | √ | null |
|
|
||
| Sibling1NameExternal | varchar | 100 | √ | null |
|
|
||
| Sibling2NameExternal | varchar | 100 | √ | null |
|
|
||
| Sibling3NameExternal | varchar | 100 | √ | null |
|
|
||
| Sibling4NameExternal | varchar | 100 | √ | null |
|
|
||
| Sibling5NameExternal | varchar | 100 | √ | null |
|
|
||
| Sibling1LegalFullName | varchar | 150 | √ | null |
|
|
||
| Sibling2LegalFullName | varchar | 150 | √ | null |
|
|
||
| Sibling3LegalFullName | varchar | 150 | √ | null |
|
|
||
| Sibling4LegalFullName | varchar | 150 | √ | null |
|
|
||
| Sibling5LegalFullName | varchar | 150 | √ | null |
|
|
||
| Sibling1Preferred | varchar | 20 | √ | null |
|
|
||
| Sibling2Preferred | varchar | 20 | √ | null |
|
|
||
| Sibling3Preferred | varchar | 20 | √ | null |
|
|
||
| Sibling4Preferred | varchar | 20 | √ | null |
|
|
||
| Sibling5Preferred | varchar | 20 | √ | null |
|
|
||
| Sibling1PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Sibling2PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Sibling3PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Sibling4PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Sibling5PreferredFormal | varchar | 20 | √ | null |
|
|
||
| Sibling1Given1 | varchar | 20 | √ | null |
|
|
||
| Sibling2Given1 | varchar | 20 | √ | null |
|
|
||
| Sibling3Given1 | varchar | 20 | √ | null |
|
|
||
| Sibling4Given1 | varchar | 20 | √ | null |
|
|
||
| Sibling5Given1 | varchar | 20 | √ | null |
|
|
||
| Sibling1ID | int | 4 | √ | null |
|
|
||
| Sibling2ID | int | 4 | √ | null |
|
|
||
| Sibling3ID | int | 4 | √ | null |
|
|
||
| Sibling4ID | int | 4 | √ | null |
|
|
||
| Sibling5ID | int | 4 | √ | null |
|
|
||
| Sibling1Surname | varchar | 30 | √ | null |
|
|
||
| Sibling2Surname | varchar | 30 | √ | null |
|
|
||
| Sibling3Surname | varchar | 30 | √ | null |
|
|
||
| Sibling4Surname | varchar | 30 | √ | null |
|
|
||
| Sibling5Surname | varchar | 30 | √ | null |
|
|
||
| Sibling1StudentCampus | varchar | 3 | √ | null |
|
|
||
| Sibling2StudentCampus | varchar | 3 | √ | null |
|
|
||
| Sibling3StudentCampus | varchar | 3 | √ | null |
|
|
||
| Sibling4StudentCampus | varchar | 3 | √ | null |
|
|
||
| Sibling5StudentCampus | varchar | 3 | √ | null |
|
|
||
| Sibling1YearLevel | smallint | 2 | √ | null |
|
|
||
| Sibling2YearLevel | smallint | 2 | √ | null |
|
|
||
| Sibling3YearLevel | smallint | 2 | √ | null |
|
|
||
| Sibling4YearLevel | smallint | 2 | √ | null |
|
|
||
| Sibling5YearLevel | smallint | 2 | √ | null |
|
|
||
| Sibling1House | varchar | 5 | √ | null |
|
|
||
| Sibling2House | varchar | 5 | √ | null |
|
|
||
| Sibling3House | varchar | 5 | √ | null |
|
|
||
| Sibling4House | varchar | 5 | √ | null |
|
|
||
| Sibling5House | varchar | 5 | √ | null |
|
|
||
| Sibling1Form | varchar | 15 | √ | null |
|
|
||
| Sibling2Form | varchar | 15 | √ | null |
|
|
||
| Sibling3Form | varchar | 15 | √ | null |
|
|
||
| Sibling4Form | varchar | 15 | √ | null |
|
|
||
| Sibling5Form | varchar | 15 | √ | null |
|
|
||
| Sibling1BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Sibling2BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Sibling3BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Sibling4BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Sibling5BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Sibling1StudentType | varchar | 15 | √ | null |
|
|
||
| Sibling2StudentType | varchar | 15 | √ | null |
|
|
||
| Sibling3StudentType | varchar | 15 | √ | null |
|
|
||
| Sibling4StudentType | varchar | 15 | √ | null |
|
|
||
| Sibling5StudentType | varchar | 15 | √ | null |
|
|
||
| Sibling1EnrolYear | int | 4 | √ | null |
|
|
||
| Sibling2EnrolYear | int | 4 | √ | null |
|
|
||
| Sibling3EnrolYear | int | 4 | √ | null |
|
|
||
| Sibling4EnrolYear | int | 4 | √ | null |
|
|
||
| Sibling5EnrolYear | int | 4 | √ | null |
|
|
||
| Sibling1SubSchool | varchar | 15 | √ | null |
|
|
||
| Sibling2SubSchool | varchar | 15 | √ | null |
|
|
||
| Sibling3SubSchool | varchar | 15 | √ | null |
|
|
||
| Sibling4SubSchool | varchar | 15 | √ | null |
|
|
||
| Sibling5ubSchool | varchar | 15 | √ | null |
|
|
Table contained 0 rows