ERD
Tables (6)
Exam (문제)
- PrimaryKey (exam_id) — BIGINT — Primary key — NOT NULL
- ForeignKey (teacher_id) — BIGINT — Foreign key → Teacher.Primary Key — NOT NULL
- 과목 (exam_subject) — VARCHAR
- 문제 제목 (exam_title) — VARCHAR
- 문제내용 (exam_content) — VARCHAR
- 문제이미지 (exam_img) — VARCHAR
- 문항 (exam_select) — VARCHAR
- 정답 (exam_answer) — VARCHAR
- 태그 (exam_tag) — VARCHAR
- 조회수 (exam_view) — BIGINT
- 정답자 수 (exam_winner) — BIGINT
- 생성 일자 (exam_date) — DATETIME
- Field
Partial_class (분반)
- PrimaryKey (class_id) — BIGINT — Primary key — NOT NULL
- ForeignKey (teacher_id) — BIGINT — Foreign key → Teacher.Primary Key — NOT NULL
- ForeignKey (user_id) — BIGINT — Foreign key → User.Primary Key — NOT NULL
- 생성 일자 (class_date) — DATETIME
Pick_Question (담기문제)
- PrimaryKey (pick_id) — BIGINT — Primary key — NOT NULL
- ForeignKey (exam_id) — BIGINT — Foreign key → Exam.PrimaryKey — NOT NULL
- ForeignKey (user_id) — BIGINT — Foreign key → User.Primary Key — NOT NULL
- 생성일자 (pick_date) — DATETIME
SuNeung (대학수학능력시험)
- PrimaryKey (su_id) — BIGINT — Primary key — NOT NULL
- 과목 (su_subject) — VARCHAR
- 어느기출? (su_date) — VARCHAR
- 문제번호 (su_num) — NUMBER
- 문제제목 (su_title) — VARCHAR
- 문제내용 (su_content) — VARCHAR
- 문제이미지 (su_img) — VARCHAR
- 문항 (su_select) — VARCHAR
- 정답 (su_answer) — VARCHAR
- 조회수 (su_view) — BIGINT
- 정답자 수 (su_winner) — BIGINT
- 태그 (su_tag) — VARCHAR
Teacher (강사)
- Primary Key (teacher_id) — BIGINT — Primary key — NOT NULL
- Birth (teacher_birth) — VARCHAR
- Phone (teacher_phone) — VARCHAR
- Name (teacher_name) — VARCHAR
- 계정생성일자 (teacher_date) — DATETIME
- Permission (teacher_permission) — INT
User (계정)
- Primary Key (user_id) — BIGINT — Primary key — NOT NULL
- Name (user_name) — VARCHAR
- Phone (user_phone) — VARCHAR
- Birth (user_birth) — VARCHAR
- 계정생성일자 (user_date) — DATETIME
- Permission (user_permission) — INT