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