TrendScope

Tables (6)

Keyword (Untitled4)

  • keyword_id (Key) — Primary key — NOT NULL
  • keyword_name (Field)
  • created_at (Field2)

KeywordTrend (Untitled6)

  • trend_id (Key) — Primary key — NOT NULL
  • date (Field)
  • mention_count (Field2)
  • keyword_id (Key2) — Foreign key → Keyword.keyword_id — NOT NULL

News (Untitled)

  • news_id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • press (Field3)
  • published_date (Field4)
  • url (Field5)
  • created_at (Field6)

NewsKeyword (Untitled5)

  • news_id (Key) — Foreign key → News.news_id — NOT NULL
  • keyword_id (Key2) — Foreign key → Keyword.keyword_id — NOT NULL

Summary (Untitled2)

  • news_id (Key2) — Foreign key → News.news_id — NOT NULL
  • summary_text (Field1)
  • created_at (Field2)
  • model (Field3)

TrustScore (Untitled3)

  • news_id (Key2) — Foreign key → News.news_id — NOT NULL
  • score (Field2)
  • grade (Field3)
  • analyzed_at (Field4)