test
Tables (11)
investment_journal
- id — BIGINT
- user_id — BIGINT — NOT NULL
- journal_date — DATE — NOT NULL
- emotion — VARCHAR(50) — NOT NULL
- reason — TEXT — NOT NULL
- mistake — TEXT — NOT NULL
- created_at — DATETIME
journal_feedback
- id — BIGINT
- user_id — BIGINT — NOT NULL
- week_start — DATE — NOT NULL
- week_end — DATE — NOT NULL
- summary_text — TEXT
- strength — TEXT
- improvements — TEXT
- next_week_tip — TEXT
- generated_by — VARCHAR(50)
- generated_at — DATETIME
learning_contents
- content_id — BIGINT
- type — ENUM('VIDEO', 'TEXT', 'CARD') — NOT NULL
- title — VARCHAR(25) — NOT NULL
- body — TEXT
- credit_reward — INT — NOT NULL
- created_at — DATE — NOT NULL
learning_contents_tags
- content_id — BIGINT — Primary key — NOT NULL
- profile_tag — VARCHAR(50) — Primary key — NOT NULL
learning_quiz
- quiz_id — BIGINT
- content_id — BIGINT — NOT NULL
- question — TEXT — NOT NULL
- options — TEXT — NOT NULL
- answer — INT — NOT NULL
user
- id — BIGINT
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- risk_type — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(100)
- email — VARCHAR(100)
- provider — VARCHAR(100)
user_credit
- user_id — BIGINT
- total_credit — INT — NOT NULL
- updated_at — DATE — NOT NULL
user_investment_profile_history
- id — BIGINT
- user_id — BIGINT — NOT NULL
- risk_type — VARCHAR(50) — NOT NULL
- diagnosed_at — DATE — NOT NULL
user_investment_profiles
- user_id — BIGINT
- risk_type — ENUM('CONSERVATIVE', 'MODERATE', 'AGGRESSIVE') — NOT NULL
- interest_sector — VARCHAR(50) — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE — NOT NULL
user_quiz_results
- user_id — BIGINT — Primary key — NOT NULL
- quiz_id — BIGINT — Primary key — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- credit_earned — INT — NOT NULL
- attempted_at — DATE — NOT NULL
user_setting
- user_id — BIGINT
- push_notify — BOOLEAN
- is_active — BOOLEAN
- updated_at — DATETIME