wingle_dabin2

Tables (15)

choice_option

  • id — BIGINT
  • choice_question_id — BIGINT — Foreign key → choice_question.id — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL

choice_question

  • id — BIGINT
  • content — VARCHAR(500) — NOT NULL
  • category_code — VARCHAR(20) — Foreign key → common_codes.code — NOT NULL
  • is_active — TINYINT — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

choice_question_answer

  • id — BIGINT
  • user_id — BIGINT — Foreign key → uuser.id — NOT NULL
  • choice_question_id — BIGINT — Foreign key → choice_question.id — NOT NULL
  • choice_option_id — BIGINT — Foreign key → choice_option.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

codebook

  • id — BIGINT
  • group_code — VARCHAR(20) — Foreign key → group_codes.group_code — NOT NULL
  • snapshot_version — INT — NOT NULL
  • description — VARCHAR(255)
  • is_active — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

codebook_common_code

  • id — BIGINT
  • codebook_id — BIGINT — Foreign key → codebook.id — NOT NULL
  • common_code — VARCHAR(20) — Foreign key → common_codes.code — NOT NULL

common_codes

  • code — VARCHAR(20)
  • group_code — VARCHAR(20) — Foreign key → group_codes.group_code — NOT NULL
  • code_name — VARCHAR(50) — NOT NULL
  • parent_common_code — VARCHAR(20) — Foreign key → common_codes.code
  • is_active — TINYINT — NOT NULL
  • sort_order — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

essay_answer

  • id — BIGINT
  • user_id — BIGINT — Foreign key → uuser.id — NOT NULL
  • essay_question_id — BIGINT — Foreign key → essay_question.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

essay_question

  • id — BIGINT
  • content — VARCHAR(500) — NOT NULL
  • is_require — TINYINT — NOT NULL
  • is_active — TINYINT — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

essay_question_set

  • id — BIGINT
  • version — INT — NOT NULL
  • is_active — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

essay_question_set_question

  • id — BIGINT
  • essay_question_set_id — BIGINT — Foreign key → essay_question_set.id — NOT NULL
  • essay_question_id — BIGINT — Foreign key → essay_question.id — NOT NULL

group_codes

  • group_code — VARCHAR(20)
  • code_name — VARCHAR(30) — NOT NULL
  • is_active — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

profile

  • id — BIGINT
  • uuser_id — BIGINT — Foreign key → uuser.id — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • residence_code — VARCHAR(20) — Foreign key → common_codes.code — NOT NULL
  • height — BIGINT — NOT NULL
  • body_type_code — VARCHAR(20) — Foreign key → common_codes.code — NOT NULL

question_set

  • id — BIGINT
  • category_code — VARCHAR(20) — Foreign key → common_codes.code — NOT NULL
  • version — INT — NOT NULL
  • is_active — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

question_set_question

  • id — BIGINT
  • question_set_id — BIGINT — Foreign key → question_set.id — NOT NULL
  • question_id — BIGINT — Foreign key → choice_question.id — NOT NULL

uuser

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(13) — NOT NULL
  • CI — VARCHAR(255) — NOT NULL
  • age — BIGINT
  • gender — VARCHAR(10) — NOT NULL
  • birth — DATE — NOT NULL
  • lastest_term_version — DOUBLE — NOT NULL
  • role — VARCHAR(20) — NOT NULL