자율

테이블 (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