개인
테이블 (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