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)