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)