School


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name varchar 2147483647 null
address varchar 2147483647 √ null
isDeactivated bool 1 √ false
code varchar 2147483647 null
ConnectivityIncident.schoolCode FK_ConnectivityIncident_schoolCode R
ConnectivityIncidentPerson.schoolCode FK_ConnectivityIncidentPerson_schoolCode R
Effectiveness.schoolCode FK_Effectiveness_schoolCode R
events.schoolCode FK_76485912ad5e9af8f0a70a46e76 R
Modeling.schoolCode FK_Modeling_schoolCode R
ModelingMomentHistory.schoolCode FK_ModelingMomentHistory_schoolCode R
RemediationRecord.schoolCode FK_RemediationRecord_schoolCode R
Response.code FK_539193c947fe9372ff936f1d324 R
Response.schoolCode Implied Constraint R
school-teachers.schoolCode FK_f8d475ff3e396f8767dd6dd3509 R
Section.schoolCode FK_4c2deec750f9c9a46fd481b15b7 R
sessions.schoolCode Implied Constraint R
UserSchool.schoolCode FK_52219a0a9c667f5b21b10d2169a R
districtsId int4 10 √ null
Districts.id FK_daeb36ac964ae20d5a58b1b2353 R
block varchar 2147483647 √ null
districtId int4 10 √ null
schoolEnrollment bool 1 √ false
schoolSchedule bool 1 √ false
teachingAssignment bool 1 √ false
directorDui varchar 2147483647 √ null
directorEmail varchar 2147483647 √ null
subdirectorName varchar 2147483647 √ null
phase varchar 2147483647 √ null
directorName varchar 2147483647 √ null
directorPhone varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_6cf8f22b5638a54a216e1c6ab5f Primary key Asc code

Relationships