shinhan

Tables (10)

mydata_spending_report

  • id — BIGINT
  • user_id — BIGINT
  • report_month — CHAR(7)
  • main_category — VARCHAR(50)
  • sub_category — VARCHAR(50)
  • spent_amount — DECIMAL(12,2)
  • transaction_count — INT
  • is_regular — BOOLEAN
  • total_spent — DECIMAL(12,2)
  • created_at — DATETIME

point

  • id — BIGINT
  • user_id — BIGINT
  • survey_id — BIGINT
  • amount — INT
  • transferred_at — DATETIME

point_pool

  • id — BIGINT
  • survey_id — BIGINT
  • total_amount — INT
  • remaining_amount — INT
  • used_amount — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — ENUM('PENDING', 'READY', 'DEPLETED', 'REFUNDED')

question

  • id — BIGINT
  • survey_id — BIGINT
  • question_text — TEXT
  • question_type — ENUM('SUBJECTIVE', 'SINGLE_CHOICE', 'RANDOM_CHECK')
  • is_required — BOOLEAN
  • order_index — INT
  • options — JSON
  • correct_answer — INT

question_answers

  • id — BIGINT
  • user_id — BIGINT
  • question_id — BIGINT
  • contents — TEXT

report

  • id — BIGINT
  • user_id — BIGINT
  • survey_id — BIGINT
  • contents — TEXT
  • created_at — DATETIME

survey

  • id — BIGINT
  • user_id — BIGINT
  • title — VARCHAR(255)
  • description — TEXT
  • gender — VARCHAR(50)
  • grade — VARCHAR(50)
  • school — VARCHAR(100)
  • major — VARCHAR(100)
  • my_data_category — ENUM('쇼핑','식비','여가','교육','교통','의료','통신','공과금','경조사','모임','용돈','기부금','보험/연금','결제','정기지출','이체')
  • degree — VARCHAR(100)
  • consume_amount — INT
  • reward — INT
  • total_reward — INT
  • lottery_quota — INT
  • first_come_quota — INT
  • start_date — DATETIME
  • end_date — DATETIME
  • active — ENUM('DRAFT', 'ACTIVE', 'CLOSED', 'EXPIRED', 'CANCELLED')

survey_participants

  • id — BIGINT
  • survey_id — BIGINT
  • user_id — BIGINT
  • is_first — BOOLEAN
  • is_winner — BOOLEAN
  • submitted_at — DATETIME
  • is_random_check_passed — BOOLEAN

user

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • student_number — VARCHAR(50)
  • school — VARCHAR(100) — NOT NULL
  • account — VARCHAR(50)
  • mypoint — INT
  • my_data_agree — BOOLEAN

virtual_account

  • id — BIGINT
  • survey_id — BIGINT
  • account_number — VARCHAR(50)
  • expected_amount — INT
  • status — ENUM('PENDING', 'DEPOSITED', 'REFUNDED')
  • deposited_at — DATETIME
  • created_at — DATETIME