HotStock

Tables (6)

keyword

  • keyword_id — int — Primary key — NOT NULL
  • content — varchar
  • create_date — TIMESTAMP
  • news_id — int — Foreign key → news.news_id — NOT NULL

keyword_summary (keyword_count)

  • keyword_summary_id (keyword_count_id) — int — Primary key — NOT NULL
  • count — int
  • create_date — TIMESTAMP
  • keyword_id — int — Foreign key → keyword.keyword_id — NOT NULL

keyword_theme

  • keyword_theme_id (keyword_teme_id) — int — Primary key — NOT NULL
  • keyword_id — int — Foreign key → keyword.keyword_id — NOT NULL
  • theme_id — int — Foreign key → theme.theme_id — NOT NULL

news

  • news_id — int — Primary key — NOT NULL
  • title — varchar
  • summary (content) — varchar
  • link (news_link) — varchar

stock

  • stock_id — int — Primary key — NOT NULL
  • name (Field) — varchar
  • content (Field2) — varchar
  • theme_id — int — Foreign key → theme.theme_id — NOT NULL

theme

  • theme_id — int — Primary key — NOT NULL
  • name (theme_name) — varchar