자율
테이블 (16)
answer_choices
- answer_choice_id — BIGINT — 기본 키 — NOT NULL
- number — INT
- answer_id — BIGINT — NOT NULL
- answer_choice — INT
answers
- answers_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(255)
- question_number — INT
- type — ENUM('MULTIPLE_CHOICE','SINGLE_CHOICE','SUBJECTIVE')
- participant_id — BIGINT — NOT NULL
- survey_id — BIGINT — NOT NULL
choices
- choice_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(255)
- number — INT
- question_id — BIGINT — NOT NULL
daily_statistics
- id — BIGINT — 기본 키 — NOT NULL
- active_surveys — BIGINT
- active_users — BIGINT
- current_circulating_points — BIGINT
- daily_payment_count — BIGINT
- daily_points_issued — BIGINT
- daily_points_used — BIGINT
- daily_responses — BIGINT
- daily_revenue — BIGINT
- daily_withdrawal_amount — BIGINT
- daily_withdrawal_count — BIGINT
- failed_withdrawal_count — BIGINT
- new_users — BIGINT
- pending_withdrawal_count — BIGINT
- stat_date — DATE — NOT NULL
- total_payment_count — BIGINT
- total_points_issued — BIGINT
- total_points_used — BIGINT
- total_responses — BIGINT
- total_revenue — BIGINT
- total_surveys — BIGINT
- total_users — BIGINT
- total_withdrawal_amount — BIGINT
interests
- interest_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(255)
participant_statistics
- participant_statistic_id — BIGINT — 기본 키 — NOT NULL
- creative_cnt — INT — NOT NULL
- education_cnt — INT — NOT NULL
- etc_cnt — INT — NOT NULL
- female_cnt — INT — NOT NULL
- fifties_cnt — INT — NOT NULL
- forties_cnt — INT — NOT NULL
- it_cnt — INT — NOT NULL
- male_cnt — INT — NOT NULL
- manufacturing_cnt — INT — NOT NULL
- max_response — INT — NOT NULL
- medical_cnt — INT — NOT NULL
- office_cnt — INT — NOT NULL
- self_employed_cnt — INT — NOT NULL
- service_cnt — INT — NOT NULL
- sixty_plus_cnt — INT — NOT NULL
- student_cnt — INT — NOT NULL
- teens_cnt — INT — NOT NULL
- thirties_cnt — INT — NOT NULL
- total_cnt — INT — NOT NULL
- twenties_cnt — INT — NOT NULL
- version — BIGINT
- survey_id — BIGINT — NOT NULL
payment_events
- event_id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- description — VARCHAR(255)
- error_message — VARCHAR(500)
- event_data — JSON
- event_type — ENUM('CANCELLED','COMPLETED','CONFIRMED','FAILED','PENDING','PROCESSING') — NOT NULL
- payment_id — BIGINT — NOT NULL
payments
- payment_id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- amount — BIGINT — NOT NULL
- approval_at — DATETIME(6)
- method — VARCHAR(50)
- order_id — VARCHAR(255) — NOT NULL
- payment_key — VARCHAR(255)
- receipt_url — VARCHAR(500)
- status — VARCHAR(50) — NOT NULL
- toss_approval_at — DATETIME(6)
- toss_order_name — VARCHAR(255)
- user_id — BIGINT — NOT NULL
point_record
- point_record_id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- amount — BIGINT — NOT NULL
- content — VARCHAR(255)
- platform_fee — BIGINT
- reference_id — BIGINT
- reference_type — ENUM('ADMIN','PAYMENT','REFUND','REWARD','SURVEY','WITHDRAWAL')
- remain_point — BIGINT
- type — VARCHAR(20) — NOT NULL
- user_id — BIGINT — NOT NULL
question_statistics
- question_statistic_id — BIGINT — 기본 키 — NOT NULL
- choice_number — INT
- count — INT
- question_number — INT
- survey_id — BIGINT — NOT NULL
questions
- question_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(255)
- number — INT
- type — ENUM('MULTIPLE_CHOICE','SINGLE_CHOICE','SUBJECTIVE') — NOT NULL
- survey_id — BIGINT — NOT NULL
surveys
- survey_id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- deadline — DATETIME(6)
- description — VARCHAR(255)
- max_response — INT
- question_cnt — INT
- response_cnt — INT — NOT NULL
- reward — BIGINT
- state — ENUM('CANCELED','DONE','IN_PROCESS')
- title — VARCHAR(255)
- client_id — BIGINT — NOT NULL
- interest_id — BIGINT — NOT NULL
user_surveys
- user_survey_id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- age — BIGINT
- age_group — ENUM('FIFTIES','FORTIES','SIXTY_PLUS','TEEN','THIRTIES','TWENTIES')
- gender — ENUM('FEMALE','MALE')
- work_type — ENUM('CREATIVE','EDUCATION','ETC','IT','MANUFACTURING', 'MEDICAL','OFFICE','SELF_EMPLOYED','SERVICE','STUDENT')
- interest_id — BIGINT — NOT NULL
- survey_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- age — BIGINT
- email — VARCHAR(255) — NOT NULL
- gender — ENUM('FEMALE','MALE')
- is_deleted — BIT(1)
- password — VARCHAR(255)
- point — BIGINT
- user_role — ENUM('ADMIN','USER')
- username — VARCHAR(255) — NOT NULL
- work_type — ENUM('CREATIVE','EDUCATION','ETC','IT','MANUFACTURING', 'MEDICAL','OFFICE','SELF_EMPLOYED','SERVICE','STUDENT')
withdrawal_requests
- withdrawal_id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- account — VARCHAR(100) — NOT NULL
- amount — BIGINT — NOT NULL
- bank_code — VARCHAR(10) — NOT NULL
- completed_at — DATETIME(6)
- failure_reason — VARCHAR(500)
- processed_at — DATETIME(6)
- status — VARCHAR(50) — NOT NULL
- toss_payout_id — VARCHAR(255)
- user_id — BIGINT — NOT NULL
withdrawal_transactions
- withdrawal_transaction_id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- error_message — VARCHAR(500)
- result_data — JSON
- status — ENUM('CANCELLED','COMPLETED','CONFIRMED','FAILED','PENDING','PROCESSING') — NOT NULL
- withdrawal_id — BIGINT — NOT NULL