DataBase Assignment

Tables (11)

Course (Untitled2)

  • course_id (Key) — INT(11) — Primary key — NOT NULL
  • subject_id (Key2) — INT(11) — Foreign key → Subject.subject_id — NOT NULL
  • first_creator_id (유저id) — INT(11) — Foreign key → User.user_id — NOT NULL

Keyword (Untitled4)

  • keyword_name (Key) — VARCHAR(255) — Primary key — NOT NULL

MCQ_answer (Untitled9)

  • User_id (Key) — INT(11) — Primary key — NOT NULL
  • question_id (Key2) — INT(11) — Primary key — NOT NULL
  • answer (Key3) — INT(11) — Primary key — NOT NULL

MCQ_solution (Untitled6)

  • answer (Key3) — INT(11) — Primary key — NOT NULL
  • question_id (Key) — INT(11) — Foreign key → Question.question_id — NOT NULL

Question (Untitled3)

  • question_id (Key) — INT(11) — Primary key — NOT NULL
  • difficulty (Field) — INT(11)
  • course_id (Key2) — INT(11) — Foreign key → Course.course_id — NOT NULL
  • type (Field2) — INT(11)
  • creator_id (유저id) — INT(11) — Foreign key → User.user_id — NOT NULL
  • question_text (Field3) — VARCHAR(1000)

SAQ_answer (CopyOfUntitled9)

  • User_id (Key) — INT(11) — Primary key — NOT NULL
  • question_id (Key2) — INT(11) — Primary key — NOT NULL
  • answer (Key3) — VARCHAR(255) — Primary key — NOT NULL

SAQ_solution (Untitled7)

  • answer (Key2) — CHAR(255) — Primary key — NOT NULL
  • question_id (Key) — INT(11) — Foreign key → Question.question_id — NOT NULL

Subject (Untitled)

  • subject_id (Key) — INT(11) — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • start_date (Field2) — DATE
  • end_date (Field3) — DATE
  • capacity (Field4) — INT(11)
  • main_lecturer_id (유저id2) — INT(11) — Foreign key → User.user_id — NOT NULL

User (user)

  • user_id (유저id) — INT(11) — Primary key — NOT NULL
  • email_id (이메일) — VARCHAR(255)
  • name (Field) — VARCHAR(1000)
  • type (Field2) — INT(11)
  • password (Field3) — VARCHAR(255)

has_keyword (Untitled5)

  • keyword_name (Key) — INT(11) — Foreign key → Keyword.keyword_name — NOT NULL
  • question_id (Key2) — INT(11) — Foreign key → Question.question_id — NOT NULL
  • importance (Field) — INT(11)

solve (Untitled8)

  • User_id (유저id) — INT(11) — Foreign key → User.user_id — NOT NULL
  • question_id (Key) — INT(11) — Foreign key → Question.question_id — NOT NULL
  • score (Field) — INT(11)