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