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