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