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)