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