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