개인

테이블 (4)

article_keywords

  • article_id — TEXT — 기본 키 — NOT NULL
  • keyword_id — INTEGER — 기본 키 — NOT NULL

articles

  • news_id — TEXT
  • topic_id — INTEGER — topics.id
  • title — TEXT
  • sub_title — TEXT
  • content — TEXT
  • provider — TEXT
  • provider_code — TEXT
  • provider_link_page — TEXT
  • date — TEXT
  • category — TEXT
  • category_main — TEXT
  • category_code — TEXT
  • category_incident — TEXT
  • category_incident_main — TEXT
  • byline — TEXT
  • images — TEXT
  • images_caption — TEXT
  • tms_ne_person — TEXT
  • tms_ne_organization — TEXT
  • tms_ne_location — TEXT
  • tms_ne_stream — TEXT
  • tms_raw_stream — TEXT
  • tms_similarity — TEXT
  • tms_sentiment_class — TEXT
  • created_at — TIMESTAMP
  • raw_data — JSONB

keywords

  • id — SERIAL
  • name — TEXT — NOT NULL
  • created_at — TIMESTAMP

topics

  • id — SERIAL
  • keyword_id — INTEGER
  • title — TEXT — NOT NULL
  • link — TEXT
  • amount — INTEGER
  • created_at — TIMESTAMP