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