Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
BoardMembersMale | smallint | 2 | ((0)) |
|
|
|||
BoardMembersFemale | smallint | 2 | ((0)) |
|
|
|||
BoardName | varchar | 80 | ('') |
|
|
|||
BoardType | varchar | 15 | ('') |
|
|
|||
PresidentCanonicalAdminParishCode | varchar | 5 | ('') |
|
|
|||
ClassGroupComments | varchar | 80 | ('') |
|
|
|||
SchoolSystemCode | varchar | 20 | ('') |
|
|
|||
LanguagesPolicy | varchar | 255 | ('') |
|
|
|||
SchoolTypeCode | varchar | 15 | ('') |
|
|
|||
EnrolmentSchemeStartDate | datetime | 16,3 | √ | null |
|
|
||
TwoTieredFeeStructureFamilyFlag | bit | 1 | ((0)) |
|
|
|||
TwoTieredFeeStructureStudentFlag | bit | 1 | ((0)) |
|
|
|||
TwoTieredFeeStructureLowestFeeAmount | money | 21,4 | ((0)) |
|
|
|||
TwoTieredFeeStructureLowestFeeType | varchar | 15 | √ | ('') |
|
|
||
FeeStructureOneChildFlag | bit | 1 | ((0)) |
|
|
|||
FeeStructureTwoChildFlag | bit | 1 | ((0)) |
|
|
|||
FeeStructureThreeChildFlag | bit | 1 | ((0)) |
|
|
|||
FeeStructureFourOrMoreChildFlag | bit | 1 | ((0)) |
|
|
|||
SchoolHasBoardFlag | varchar | 1 | ('') |
|
|
|||
SchoolParishPrimaryFlag | varchar | 1 | ('') |
|
|
|||
SchoolBoardAdvisesParishFlag | varchar | 1 | ('') |
|
|
|||
OtherSchoolsServedFlag | varchar | 1 | ('') |
|
|
|||
OtherSchoolsServed | varchar | 255 | ('') |
|
|
|||
SchoolBoardIncorporatedFlag | varchar | 1 | ('') |
|
|
|||
SchoolBoardNonIncorporatedBoardType | varchar | 15 | ('') |
|
|
|||
SchoolCanonicalJurisdictionBody | varchar | 15 | ('') |
|
|
|||
SchoolCanonicalJurisdictionBodyOther | varchar | 255 | ('') |
|
|
|||
InformationValidAsAtDate | datetime | 16,3 | √ | null |
|
|
||
SchoolSeq | int identity | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_School_SchoolSeq | Primary key | Asc | SchoolSeq |