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교시')