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