캡스톤
테이블 (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