캡스톤

테이블 (9)

news

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • source — VARCHAR(255) — NOT NULL
  • published_at — TIMESTAMP — NOT NULL

news_ai_analysis

  • id — BIGINT
  • news_id — BIGINT — NOT NULL
  • sentiment — VARCHAR(50) — NOT NULL
  • summary — TEXT — NOT NULL
  • created_at — TIMESTAMP

portfolio

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • stock_code — VARCHAR(10) — NOT NULL
  • quantity — INT — NOT NULL
  • average_price — DECIMAL(18, 2) — NOT NULL
  • created_at — TIMESTAMP

reports

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

reports_ai_analysis

  • id — BIGINT
  • report_id — BIGINT — NOT NULL
  • summary — TEXT — NOT NULL
  • insight — TEXT — NOT NULL
  • created_at — TIMESTAMP

securities

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • url — VARCHAR(255)

temporary_users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • verification_token — VARCHAR(255) — NOT NULL
  • token_expiration — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

user_accounts

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • securities_id — BIGINT — NOT NULL
  • account_number — VARCHAR(100) — NOT NULL
  • linked_at — TIMESTAMP

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email_verified — BOOLEAN
  • created_at — TIMESTAMP