team7

Tables (12)

classes

  • class_id — int(11) — Primary key — NOT NULL
  • master_id — int(11) — Foreign key → users.user_id — NOT NULL
  • name — varchar(255)
  • capacity — int(11)

lecture_keywords

  • id — int(11) — Primary key — NOT NULL
  • lecture_id — int(11) — Foreign key → lectures.lecture_id — NOT NULL
  • keyword — varchar(255)
  • weight — double

lectures

  • lecture_id — int(11) — Primary key — NOT NULL
  • class_id — int(11) — Foreign key → classes.class_id — NOT NULL
  • name — varchar(255)
  • start_time — datetime(6)
  • end_time — datetime(6)

question_bank

  • questionbank_id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → users.user_id — NOT NULL
  • types — int(11)
  • question (Field) — varchar(1023)
  • bogi — longtext
  • answer (anwer) — longtext
  • difficulty — int(11)
  • real_difficulty — int(11)

question_keywords

  • id — int(11) — Primary key — NOT NULL
  • lecture_id (lecture_id2) — int(11) — Foreign key → questions.lecture_id — NOT NULL
  • keyword — varchar(255)
  • lecture_id — int(11)
  • score_portion — int(11)

question_keywords_bank

  • id — int(11) — Primary key — NOT NULL
  • questionbank_id — int(11) — Foreign key → question_bank.questionbank_id — NOT NULL
  • keyword — varchar(255)
  • score_portion — int(11)

question_parameter

  • id — int(11) — Primary key — NOT NULL
  • question_id — int(11) — Foreign key → questions.question_id — NOT NULL
  • key_value — int(11)
  • pr1 — double
  • pr2 — double
  • pr3 — double
  • pr4 — double
  • pr5 — double
  • answer — double

question_parameter_bank

  • id — int(11) — Primary key — NOT NULL
  • questionbank_id — int(11) — Foreign key → question_bank.questionbank_id — NOT NULL
  • pr1 — double
  • pr2 — double
  • pr3 — double
  • pr4 — double
  • pr5 — double
  • answer — double
  • key_value — int(11)

questions

  • question_id — int(11) — Primary key — NOT NULL
  • lecture_id — int(11) — Foreign key → lectures.lecture_id — NOT NULL
  • type — int(11)
  • question — varchar(1023)
  • bogi — longtext
  • answer — longtext
  • difficulty — int(11)

student_question_log

  • id — int(11) — Primary key — NOT NULL
  • question_id — int(11) — Foreign key → questions.question_id — NOT NULL
  • user_id — int(11) — Foreign key → users.user_id — NOT NULL
  • score — int(11)

user_classes

  • user_class_id — int(11) — Primary key — NOT NULL
  • class_id (class_id2) — int(11) — Foreign key → classes.class_id — NOT NULL
  • user_id — int(11) — Foreign key → users.user_id — NOT NULL
  • role (rolev) — varchar(255)

users

  • user_id — int(11) — Primary key — NOT NULL
  • email — varchar(255)
  • password — varchar(255)
  • type — varchar(255)