16team

Tables (7)

keyword

  • id (Key) — BIGINT — Primary key — NOT NULL
  • stock_name (Key2) — VARCHAR(255) — Foreign key → stock.stock_Id — NOT NULL
  • keyword (id) — VARCHAR(255)

news

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(500)
  • content — TEXT
  • url — VARCHAR(500)
  • collected_at (수집한시간) — DATETIME
  • summary (요약) — TEXT
  • news_keyword (뉴스 키워드)

stock

  • stock_Id (Key) — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • sector — VARCHAR(255)

term

  • id — BIGINT — Primary key — NOT NULL
  • word (용어) — VARCHAR(255) — NOT NULL
  • definition (설명) — TEXT
  • category (카테고리) — VARCHAR(100)
  • created_at (생성시간) — DATETIME

trend

  • id — BIGINT — Primary key — NOT NULL
  • keyword — VARCHAR(255) — NOT NULL
  • searchVolume — INT — NOT NULL
  • createdAt (Field) — VARCHAR(255)
  • categories (Field2) — VARCHAR(255)

user

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)

user_view_history

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • viewed_at — DATETIME — NOT NULL