MODU
Tables (11)
email_verification
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- code — VARCHAR(10) — NOT NULL
- is_verified — BOOLEAN — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
finance_term
- id — BIGINT — Primary key — NOT NULL
- term — VARCHAR(200) — NOT NULL
- definition — TEXT — NOT NULL
- category — VARCHAR(100)
- created_at — DATETIME — NOT NULL
investment_history
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- ipo_stock_id — BIGINT — Foreign key → ipo_stock.id
- stock_type — VARCHAR(20) — NOT NULL — KOSPI | KOSDAQ | ETF
- company_name — VARCHAR(200) — NOT NULL
- company_status — VARCHAR(100)
- investment_amount — BIGINT — NOT NULL — 투자 금액 (원)
- investment_will — VARCHAR(10) — HIGH | MEDIUM | LOW
- allotted_quantity — INT — 배정 수량
- profit_rate — DECIMAL(7, 2) — 수익률 (%)
- memo — TEXT
- invested_at — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
investment_profile
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- investment_amount — BIGINT — NOT NULL — 투자 가능 금액 (원)
- investment_period — VARCHAR(10) — NOT NULL — SHORT | LONG
- risk_type — VARCHAR(20) — NOT NULL — AGGRESSIVE | SAFE
- investment_style — TEXT
- next_strategy — TEXT
- analyzed_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
ipo_indicator
- id — BIGINT — Primary key — NOT NULL
- ipo_stock_id — BIGINT — Foreign key → ipo_stock.id — NOT NULL
- institutional_competition_rate — DECIMAL(10, 2) — 기관 경쟁률
- mandatory_lock_up_ratio — DECIMAL(5, 2) — 의무 확약 비율 (%)
- distributable_shares_ratio — DECIMAL(5, 2) — 유통 가능 물량 비율 (%)
- demand_vs_offering_price — DECIMAL(10, 2) — 공모가 대비 수요
- signal — VARCHAR(10) — NOT NULL — GREEN | YELLOW | RED
- updated_at — DATETIME — NOT NULL
ipo_report
- id — BIGINT — Primary key — NOT NULL
- ipo_stock_id — BIGINT — Foreign key → ipo_stock.id — NOT NULL
- report_type — VARCHAR(20) — NOT NULL — DISCLOSURE | SUMMARY
- original_content — LONGTEXT
- summary_content — TEXT
- published_at — DATETIME
- created_at — DATETIME — NOT NULL
ipo_stock
- id — BIGINT — Primary key — NOT NULL
- company_name — VARCHAR(200) — NOT NULL
- stock_code — VARCHAR(20) — NOT NULL
- market_type — VARCHAR(10) — NOT NULL — KOSPI | KOSDAQ
- offering_price — BIGINT — NOT NULL — 공모가 (원)
- offering_shares — BIGINT — NOT NULL — 공모 주식 수
- subscription_start_date — DATE
- subscription_end_date — DATE
- listing_date — DATE
- status — VARCHAR(20) — NOT NULL — SCHEDULED | ONGOING | CLOSED
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
quiz
- id — BIGINT — Primary key — NOT NULL
- finance_term_id — BIGINT — Foreign key → finance_term.id — NOT NULL
- question — TEXT — NOT NULL
- option1 — VARCHAR(300) — NOT NULL
- option2 — VARCHAR(300) — NOT NULL
- option3 — VARCHAR(300) — NOT NULL
- option4 — VARCHAR(300) — NOT NULL
- correct_option — INT — NOT NULL — 1~4
- explanation — TEXT
- created_at — DATETIME — NOT NULL
quiz_result
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- quiz_id — BIGINT — Foreign key → quiz.id — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- answered_at — DATETIME — NOT NULL
user_term_history
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- finance_term_id — BIGINT — Foreign key → finance_term.id — NOT NULL
- lookup_count — INT — NOT NULL
- last_looked_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- provider — VARCHAR(20) — NOT NULL — LOCAL | GOOGLE | KAKAO
- provider_id — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- profile_image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL