KSEB_E_Sample_2
Tables (5)
Conclusion (Untitled5)
- conclusion_id (Key) — nteger — Primary key — NOT NULL
- conclusion_text (Field) — TEXT
- related_keyword (Field2) — VARCHAR
NewsArticle (Untitled3)
- article_id (Key) — integer — Primary key — NOT NULL
- title (Field) — VARCHAR
- link (Field2) — VARCHAR
- content (Field3) — TEXT
- press_id (Key3) — integer — Foreign key → Press.press_id — NOT NULL
Press (Untitled7)
- press_id (Key) — integer — Primary key — NOT NULL
- name (Field) — VARCHAR
- bias (Field2) — VARCHAR
RecommendedIssue (Untitled6)
- recommend_id (Key) — integer — Primary key — NOT NULL
- related_keyword (Field) — VARCHAR
- relevance_score (Field2) — FLOAT
- base_keyword (Field3) — VARCHAR
Summary (Untitled4)
- summary_id (Key) — integer — Primary key — NOT NULL
- summary_text (Field) — TEXT
- article_id (Key2) — integer — Foreign key → NewsArticle.article_id — NOT NULL