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