DB 스키마

테이블 (7)

CLASSES

  • class_id — INT(11) — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • capacity — INT(11) — NOT NULL
  • master_id — INT(11) — NOT NULL

LECTURES

  • lecture_id — INT(11) — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • class_id — INT(11) — 외래 키 → CLASSES.class_id — NOT NULL

LECTURE_KEYWORDS

  • id — INT(11) — 기본 키 — NOT NULL
  • keyword — VARCHAR(255) — NOT NULL
  • weight — FLOAT — NOT NULL
  • lecture_id — INT(11) — 외래 키 → LECTURES.lecture_id — NOT NULL

QUESTIONS

  • question_id — INT(11) — 기본 키 — NOT NULL
  • type — INT(11) — NOT NULL
  • question — VARCHAR(1023) — NOT NULL
  • bogi — TEXT — NOT NULL
  • answer — TEXT — NOT NULL
  • difficulty — FLOAT — NOT NULL
  • real_difficulty — FLOAT — NOT NULL
  • lecture_id — INT(11) — 외래 키 → LECTURES.lecture_id — NOT NULL

QUESTION_KEYWORDS

  • keyword — VARCHAR(255) — 기본 키 — NOT NULL
  • question_id — INT(11) — 외래 키 → QUESTIONS.question_id — NOT NULL
  • score_portion — INT(11) — NOT NULL
  • lecture_id — INT(11) — 외래 키 → LECTURES.lecture_id — NOT NULL

USERS

  • user_id — INT(11) — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • type — INT(11) — NOT NULL

USER_CLASSES

  • user_id — INT(11) — 외래 키 → USERS.user_id — NOT NULL
  • class_id — INT(11) — 외래 키 → CLASSES.class_id — NOT NULL
  • role — VARCHAR(255) — NOT NULL