School


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