LAB
Tables (10)
lab_category (Untitled11)
- id — Primary key — NOT NULL
- lab_question_season_id — Foreign key → lab_question_season.id — NOT NULL
- title — varchar
- thumbnail — varchar
- order — int
- status
lab_question (Untitled)
- Key (id) — Primary key — NOT NULL
- id (Key) — Foreign key → lab_category.id — NOT NULL
- Key (Key2) — Foreign key → lab_category.lab_question_season_id — NOT NULL
- description
- title
- order
- point — int
- exp — int
- status
lab_question_item (CopyOfUntitled)
- id — Primary key — NOT NULL
- lab_question_id — Foreign key → lab_question.Key — NOT NULL
- lab_survey_id — Foreign key → lab_survey.id — NOT NULL
- Key (Key2) — Foreign key → lab_question.Key — NOT NULL
- order
lab_question_item_submit (CopyOfUntitled6)
- Key — Primary key — NOT NULL
- user_id — Foreign key → lab_qustion_submit.user_id — NOT NULL
- lab_question_submit_id — Foreign key → lab_qustion_submit.Key — NOT NULL
- lab_question_item_id — Foreign key → lab_question_item.id — NOT NULL
- lab_survey_id — Foreign key → lab_survey.id — NOT NULL
- Key (id2) — Foreign key → lab_qustion_submit.Key — NOT NULL
- Key (Key2) — Foreign key → lab_question_item.Key — NOT NULL
lab_question_season (Untitled4)
- id — Primary key — NOT NULL
- startDate (Field)
- endDate
- name
- status
lab_qustion_submit (Untitled6)
- Key — Primary key — NOT NULL
- user_id — Foreign key → user.Key — NOT NULL
- Key (id2) — Foreign key → lab_question.Key — NOT NULL
- Key (Key2) — Foreign key → lab_question.Key — NOT NULL
- duration — int
lab_survey (Untitled2)
- id (Key) — Primary key — NOT NULL
- title
- type — ENUM
lab_survey_answer (Untitled3)
- id — Primary key — NOT NULL
- lab_survey_id — Foreign key → lab_survey.id — NOT NULL
- description
- order
- image
- reject — boolean
lab_survey_answer_submit (Untitled7)
- Key — Primary key — NOT NULL
- lab_survey_answer_id — Foreign key → lab_survey_answer.lab_survey_id — NOT NULL
- lab_question_item_submit_id — Foreign key → lab_question_item_submit.Key — NOT NULL
- id (Key2) — Foreign key → lab_question_item_submit.lab_survey_id — NOT NULL
- Key (id2) — Foreign key → lab_question_item_submit.Key — NOT NULL
- Key (Key22) — Foreign key → lab_question_item_submit.Key — NOT NULL
user (Untitled9)
- Key — Primary key — NOT NULL