knightErd
Tables (11)
Admin
- admin_id — BIGINT — Primary key — NOT NULL
- admin_name — VARCHAR
- password — VARCHAR
- role — VARCHAR
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
Chapter
- chapter_id — BIGINT — Primary key — NOT NULL
- subject_id — BIGINT — Foreign key → Subject.subject_id — NOT NULL
- chapter_level — BIGINT
- chapter_name — VARCHAR(256)
- high_chapter_id (high_chpater_id) — BIGINT
- display_order — BIGINT
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR(256)
- update_by — VARCHAR(256)
Past_question
- past_question_id — BIGINT — Primary key — NOT NULL
- subject_id — BIGINT — Foreign key → Subject.subject_id — NOT NULL
- test_year — YEAR
- test_degree — INT
- join_cnt — INT
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
Question
- question_id — BIGINT — Primary key — NOT NULL
- subject_id — BIGINT — Foreign key → Subject.subject_id — NOT NULL
- past_question_id — BIGINT — Foreign key → Past_question.past_question_id
- chapter_id — BIGINT — Foreign key → Chapter.chapter_id — NOT NULL
- inspection_yn (Inspection_yn) — VARCHAR(2)
- choice_yn — VARCHAR(2)
- content — TEXT
- explain — TEXT
- image_path — VARCHAR
- image_name — VARCHAR
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
Question_User (User_Qusetion)
- question_user_id (user_question_id) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- question_id — BIGINT — Foreign key → Question.question_id — NOT NULL
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
Question_data
- qusetion_data_id (question_data_id) — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → Question.question_id — NOT NULL
- right_cnt — INT
- wrong_cnt — INT
- save_cnt — INT
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
Question_detail
- question_detail_id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → Question.question_id — NOT NULL
- example (content) — TEXT
- comment — TEXT
- answer_yn — VARCHAR(2)
- select_cnt — BIGINT
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
Subject
- subject_id — BIGINT — Primary key — NOT NULL
- subject_name — VARCHAR
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
User
- user_id — BIGINT — Primary key — NOT NULL
- user_name — VARCHAR
- password — VARCHAR
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
User_Test
- user_test_id (question_detail_id) — BIGINT — Primary key — NOT NULL
- subject_id — BIGINT — Foreign key → Subject.subject_id — NOT NULL
- past_question_id — BIGINT — Foreign key → Past_question.past_question_id
- chapter_id — BIGINT — Foreign key → Chapter.chapter_id
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- test_date — DATE
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR
User_Test_History (Untitled)
- test_history_id (Key) — BIGINT — Primary key — NOT NULL
- user_test_id (question_detail_id) — BIGINT — Foreign key → User_Test.user_test_id — NOT NULL
- question_id — BIGINT — Foreign key → Question.question_id — NOT NULL
- answer_yn — VARCHAR(2)
- create_time — DATETIME
- update_time — DATETIME
- create_by — VARCHAR
- update_by — VARCHAR