과제

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