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