과제
테이블 (5)
article_stocks
- id — BIGINT — 기본 키 — NOT NULL
- article_id — BIGINT — 외래 키 → articles.id — NOT NULL
- stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
articles
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- url — VARCHAR(1000) — NOT NULL
- source — VARCHAR(100) — NOT NULL
- summary — TEXT
- published_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
favorite_stocks
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- stock_id — BIGINT — 외래 키 → stocks.id — NOT NULL
- created_at — DATETIME — NOT NULL
stocks
- id — BIGINT — 기본 키 — NOT NULL
- stock_code — VARCHAR(20) — NOT NULL
- stock_name — VARCHAR(100) — NOT NULL
- market — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL