db_0402
Tables (7)
Grade
- id — TINYINT — 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반')
History
- id — INT — Primary key — NOT NULL
- FK_테이블_id (FK_table_id) — TINYINT
- FK_테이블_이름 (FK_table_name) — varchar(100)
- sql_유형 (sql_type) — enum('sql_insert','sql_update','sql_delete','sql_select')
- sql_쿼리문 (sql_text) — text
- user_아이피 (user_ip) — varchar(50)
- user_아이디 (user_id) — varchar(50)
- 작업시간 (edit_time) — date
Place
- id — INT — Primary key — NOT NULL
- fk_학년_id (fk_grade_id) — TINYINT — Foreign key → Grade.id — NOT NULL
- 실이름 (name) — varchar(255)
- 건물이름 (building) — ENUM('본관','신관','정보관','체육관')
- 층 (floor) — ENUM('지하1층','1층','2층','3층','4층','5층','6층','7층')
Student
- id — INT — Primary key — NOT NULL
- fk_학년_id (fk_grade_id) — TINYINT — Foreign key → Grade.id — NOT NULL
- 이름 (name) — varchar(50) — NOT NULL
Subject
- id — INT — Primary key — NOT NULL
- fk_선생님_id (fk_teacher_id) — INT — Foreign key → Teacher.id — NOT NULL
- 과목명 (name) — varchar(255)
- 주단위 시수 (times) — int
Teacher
- id — INT — Primary key — NOT NULL
- fk_학년_id (fk_grade_id) — TINYINT — Foreign key → Grade.id — NOT NULL
- 이름 (name) — varchar(50)
- 학과 (department) — ENUM('보통교과','스마트보안솔루션과','모빌리티메이커과','인공지능소프트웨어과','게임소프트웨어과')
Timetable
- id — INT — Primary key — NOT NULL
- fk_학년_id (fk_grade_id) — TINYINT — Foreign key → Grade.id — NOT NULL
- fk_과목_id (fk_subject_id) — INT — Foreign key → Subject.id — NOT NULL
- fk_장소_id (fk_place_id) — INT — Foreign key → Place.id — NOT NULL
- 요일 (week) — ENUM('월','화','수','목','금','토','일')
- 교시 (lesson) — ENUM('1교시','2교시','3교시','4교시','5교시','6교시','7교시','8교시','9교시','10교시')