test

Tables (6)

chat_history

  • message_seq — INTEGER — Primary key — NOT NULL
  • session_id — INTEGER — Foreign key → chat_session.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_session

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

company

  • id — VARCHAR(50) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • market — VARCHAR(50) — NOT NULL

news

  • id — INTEGER — Primary key — NOT NULL
  • company_id — VARCHAR(50) — Foreign key → company.id
  • title — VARCHAR(255) — NOT NULL
  • content_url — TEXT
  • sentiment — VARCHAR(20)
  • ai_summary — TEXT
  • published_at — DATETIME

portfolio

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • company_id — VARCHAR(50) — Foreign key → company.id — NOT NULL
  • created_at — DATETIME

users

  • id — INTEGER — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • created_at — DATETIME — NOT NULL