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