database
Tables (6)
CityEduOffice
- city_office_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
DistrictEduOffice
- district_office_id — INT — Primary key
- city_office_id — INT — Foreign key → CityEduOffice.city_office_id
- name — VARCHAR(100) — NOT NULL
Region
- region_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
School
- school_code — VARCHAR(20) — Primary key — NOT NULL
- district_office_id — INT — Foreign key → DistrictEduOffice.district_office_id
- region_id (region_id2) — INT — Foreign key → Region.region_id
- school_name — VARCHAR(200) — NOT NULL
- school_grade_code — VARCHAR(10) — NOT NULL
- founding_type — VARCHAR(50)
- school_feature — VARCHAR(50)
- is_branch_school — CHAR(1)
- establishing_type — VARCHAR(50)
- day_night_type — VARCHAR(50)
- anniversary_date — DATE
- founding_date — DATE
- gender_type — VARCHAR(50)
- is_closed — CHAR(1)
- closed_date — DATE
- is_suspended — CHAR(1)
SchoolAddress
- school_code — VARCHAR(20) — Foreign key → School.school_code — NOT NULL
- legal_dong_code — VARCHAR(20)
- old_address — VARCHAR(255)
- old_address_det — VARCHAR(255)
- old_zipcode — VARCHAR(20)
- road_zipcode — VARCHAR(20)
- road_address — VARCHAR(255)
- road_address_det — VARCHAR(255)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
SchoolContact
- school_code — VARCHAR(20) — Foreign key → School.school_code — NOT NULL
- phone — VARCHAR(50)
- fax — VARCHAR(50)
- homepage — VARCHAR(255)