time

Tables (6)

grade (학년)

  • id — number — Primary key — NOT NULL
  • grade — ENUM('1학년','2학년','3학년','4학년','5학년','6학년','7학년')
  • class — ENUM('1반'.'2반','3반','4반','5반','6반','7반','8반','9반','10반')

place (장소)

  • id (id3) — number — Foreign key → subjects.id — NOT NULL
  • name (이름) — varchar2(20)
  • building (건물) — varchar2(20)
  • floor (층) — number
  • grade_id (id) — number — Foreign key → grade.id — NOT NULL

student (학생)

  • id (id2) — number — Foreign key → grade.id — NOT NULL
  • name — varchar2(20)
  • grade_id — number

subjects (과목)

  • id — number — Primary key — NOT NULL
  • place_id (Field2) — number — Primary key
  • teacher_id (Field) — number — Primary key
  • name (이름) — varchar2(20)
  • Sisu (sisu) — number

teacher (선생님)

  • id — number — Primary key — NOT NULL
  • name — varchar2(20)
  • lesson — varchar2(20)
  • lesson_id (id2) — number — Foreign key → grade.id — NOT NULL

timetable (시간표)

  • id — number — Primary key — NOT NULL
  • day (dayoftheweek) — ENUM('월','화','수','목','금','토')
  • period — ENUM('1교시'.'2교시','3교시','4교시','5교시','6교시','7교시','8교시','9교시','10교시')
  • grade_id (id2) — number — Foreign key → grade.id — NOT NULL
  • subjects_id (id3) — number — Foreign key → subjects.id — NOT NULL