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