Quant_Service ERD

Tables (7)

portfolio_items

  • id — BIGINT — NOT NULL
  • portfolio_id — BIGINT — Foreign key → portfolios.id — NOT NULL
  • stock_id — BIGINT — Foreign key → stocks.id — NOT NULL
  • avg_price — DECIMAL(15, 2) — NOT NULL
  • quantity — INT — NOT NULL

portfolios

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL

price_histories

  • id — BIGINT — NOT NULL
  • stock_id — BIGINT — Foreign key → stocks.id — NOT NULL
  • date — DATE — NOT NULL
  • open_price — DECIMAL(15, 2) — NOT NULL
  • close_price — DECIMAL(15, 2) — NOT NULL
  • high_price — DECIMAL(15, 2) — NOT NULL
  • low_price — DECIMAL(15, 2) — NOT NULL
  • volume — BIGINT — NOT NULL

stocks

  • id — BIGINT — NOT NULL
  • ticker — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • market — VARCHAR(50) — NOT NULL

trades

  • id — BIGINT — NOT NULL
  • portfolio_id — BIGINT — Foreign key → portfolios.id — NOT NULL
  • stock_id — BIGINT — Foreign key → stocks.id — NOT NULL
  • trade_type — VARCHAR(20) — NOT NULL
  • price — DECIMAL(15, 2) — NOT NULL
  • quantity — INT — NOT NULL
  • trade_date — DATETIME — NOT NULL

users

  • id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

watch_lists

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • stock_id — BIGINT — Foreign key → stocks.id — NOT NULL