wingle_dabin

Tables (11)

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 — BOOLEAN — 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 — BOOLEAN — 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 — BOOLEAN — NOT NULL
  • sort_order — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

group_codes

  • group_code — VARCHAR(20)
  • code_name — VARCHAR(30) — NOT NULL
  • is_active — BOOLEAN — 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 — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

question_set_question

  • id — BIGINT — NOT NULL
  • 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