KSEB_E_Sample
Tables (8)
Conclusion (Untitled5)
- conclusion_id (Key) — nteger — Primary key — NOT NULL
- conclusion_text (Field) — TEXT
- query_id (Key2) — integer — Foreign key → SearchQuery.query_id — NOT NULL
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
- query_id (Key4) — integer — Foreign key → SearchQuery.query_id — NOT NULL
Press (Untitled7)
- press_id (Key) — integer — Primary key — NOT NULL
- name (Field) — VARCHAR
- bias (Field2) — VARCHAR
- logo_url (Field3)
RecommendedIssue (Untitled6)
- recommend_id (Key) — integer — Primary key — NOT NULL
- related_keyword (Field) — VARCHAR
- relevance_score (Field2)
- query_id (Key2) — integer — Foreign key → SearchQuery.query_id — NOT NULL
SearchQuery (Untitled2)
- query_id (Key) — integer — Primary key — NOT NULL
- keyword (Field) — VARCHAR
- user_id (Key2) — integer — Foreign key → User.user_id — NOT NULL
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
User (Untitled)
- user_id (Key) — integer — Primary key — NOT NULL
- password (Field2) — string
- nickname (Field3) — string
- phone_number (Field4)
- Field
UserHistory (Untitled8)
- history_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → User.user_id — NOT NULL
- query_id (Key3) — integer — Foreign key → SearchQuery.query_id — NOT NULL
- article_id (Key4) — integer — Foreign key → NewsArticle.article_id — NOT NULL