brand_Scope

Tables (5)

AnalysisReports

  • report_id — INTEGER
  • brand_id — INTEGER — NOT NULL
  • analysis_date — DATE — NOT NULL
  • summary_text — TEXT
  • positive_ratio — REAL
  • negative_ratio — REAL

Brands

  • brand_id — INTEGER
  • brand_name — TEXT — NOT NULL
  • created_at — DATETIME

CollectedDocuments

  • doc_id — INTEGER
  • report_id — INTEGER — NOT NULL
  • source — TEXT
  • title — TEXT
  • link — TEXT
  • description — TEXT
  • post_date — DATE

DailyTrends

  • trend_id — INTEGER
  • brand_id — INTEGER — NOT NULL
  • date — DATE — NOT NULL
  • search_ratio — REAL
  • mention_count — INTEGER
  • UNIQUE(brand_id, — date)

Keywords

  • keyword_id — INTEGER
  • report_id — INTEGER — NOT NULL
  • keyword_text — TEXT — NOT NULL
  • sentiment_type — TEXT — NOT NULL
  • frequency — INTEGER — NOT NULL