news
Tables (9)
refinitiv_news (뉴스기본)
- news_id (Key22) — bigint — Foreign key → refinitiv_parsing_news.news_id — NOT NULL
- origin_news_id (Field) — bigint
- story_id (Field2) — varchar
- version (Field7) — varchar
- news_role (Field3) — varchar
- lang (Field4) — varchar
- service_lang (Field11) — jsonb
- rights_info (Field10) — jsonb
- urgency (Field12) — int
- origin_press (Field13) — varchar
- published_dt (Field5) — timestamp
- revised_dt (Field8) — timestamp
- created_dt (Field6) — timestamp
- updated_dt (Field9) — timestamp
- keyword (Field14) — jsonb
- story_type (Field15) — jsonb
- publish_status (Field16) — varchar
refinitiv_news_i18n (뉴스상세)
- news_id (Key22) — bigint — Foreign key → refinitiv_news.news_id — NOT NULL
- lang (Field10) — varchar
- title (Field) — varchar
- summary (Field6) — varchar
- body (Field4) — jsonb
- published_dt (Field2) — timestamp
- revised_dt (Field3) — timestamp
- created_dt (Field7) — timestamp
refinitiv_news_rel_symbol (관련티커)
- news_id (Key222) — bigint — Foreign key → refinitiv_news.news_id — NOT NULL
- wcode (Field) — varchar
- ticker (Field2) — varchar
- ric (Field9) — varchar
- score (Field3) — float
- country (Field8) — 지역
- time_code (Field7) — varchar
- exchange (Field6) — varchar
- tag_from (Field4) — varchar
- created_dt (Field5) — timestamp
refinitiv_news_tag (관련태그)
- waiker_code (Key) — Primary key — NOT NULL
- news_id (Key22) — bigint — Foreign key → refinitiv_news.news_id — NOT NULL
- name (Field2) — varchar
- created_dt (Field)
- updated_dt (Field3)
refinitiv_parsing_news (파싱된 뉴스)
- news_id (Key2) — bigint — Foreign key → refinitiv_raw_news_headline.news_id — NOT NULL
- origin_news_id (Field11) — bigint
- title (Field) — varchar
- lang (Field8) — varchar
- parsing_body (Field2) — varchar
- origin_body (Field3) — varchar
- origin_str_body (Field5) — varchar
- ticker_tag (Field4) — jsonb
- published_dt (Field9) — timestamp
- created_dt (Field6) — timestamp
- updated_dt (Field7) — timestamp
refinitiv_raw_news_headline (헤드라인 원문)
- news_id (Key) — bigint — Primary key — NOT NULL
- story_id (Field) — varchar
- version (Field14) — integer
- contentmeta_audience (Field2) — jsonb
- contentmeta_creater (Field3) — jsonb
- contentmeta_infosource (Field4) — jsonb
- contentmeta_language (Field5) — jsonb
- contentmeta_subject (Field6) — jsonb
- contentmeta_urgency (Field7) — integer
- itemmeta_firstcreated (Field8) — timestamp
- itemmeta_versioncreated (Field9) — timestmap
- itemmeta_title (Field10) — varchar
- itemmeta_instanceof (Field11) — varchar[]
- assert_data (Field12) — varchar[]
- created_dt (Field13) — timestmap
- updated_dt (Field15) — timestamp
- origin_news_id (Field16) — integer
refinitiv_raw_news_story (본문 원문)
- news_id (Key2) — bigint — Foreign key → refinitiv_raw_news_headline.news_id — NOT NULL
- conformance (Field35) — varchar
- guid (Field39) — varchar
- standard (Field37) — varchar
- standardversion (Field36) — varchar
- version (Field38) — integer
- lang (Field) — varchar
- catalogref (Field2) — jsonb
- rightsinfo_copyrightholder (Field40) — varchar
- rightsinfo_copyrightnotice (Field3) — varchar
- itemmeta_itemclass (Field5) — jsonb
- itemmeta_provider (Field6) — jsonb
- itemmeta_versioncreated (Field7) — timestamp
- itemmeta_firstcreated (Field8) — timestamp
- itemmeta_pubstatus (Field41) — jsonb
- itemmeta_role (Field9) — jsonb
- itemmeta_filename (Field10) — jsonb
- itemmeta_profile (Field11) — jsonb
- itemmeta_title (Field12) — jsonb
- itemmeta_instanceof (Field13) — jsonb
- itemmeta_signal (Field14) — jsonb
- itemmeta_link (Field44) — jsonb
- itemmeta_itemmetaextproperty (Field15) — jsonb
- itemmeta_versionid (Field16) — jsonb
- contentmeta_urgency (Field17) — integer
- contentmeta_infosource (Field18) — jsonb
- contentmeta_creator (Field19) — jsonb
- contentmeta_contributor (Field20) — jsonb
- contentmeta_audience (Field21) — varchar[]
- contentmeta_altid (Field22) — jsonb
- contentmeta_lang (Field23) — jsonb
- contentmeta_keyword (Field24) — jsonb
- contentmeta_subject (Field25) — jsonb
- contentmeta_slugline (Field26) — jsonb
- contentmeta_headline (Field27) — jsonb
- contentmeta_dateline (Field28) — jsonb
- contentmeta_by (Field29) — jsonb
- contentmeta_creditline (Field30) — jsonb
- contentmeta_contentmetaextproperty (Field31) — jsonb
- assert_data (Field32) — jsonb
- inlineref (Field33) — jsonb
- derivedfrom (Field34) — jsonb
- contentset (Field42) — jsonb
- topnewsmetadata (Field43) — jsonb
- created_dt (Field4) — timestamp
- updated_dt (Field45) — timestamp
refinitiv_tag_code (refinitiv제공하는코드를 매핑시킨 테이블)
- waiker_code (Key) — Primary key — NOT NULL
- refinitiv_code (Field) — varchar
- depth1_code (Field2)
- depth2_code (Field5)
- deepth1 (Field3)
- depth2 (Field4)
- definition (Field7)
- is_usable (Field9) — boolean
- created_dt (Field8)
- updated_dt (Field6)
refinitiv_tag_code_rules (waiker_code로 변환중 필요/제외조건을 포함한 테이블)
- waiker_code (Key) — Primary key — NOT NULL
- refinitiv_code (Field) — varchar
- condition_type (Field2) — varchar
- description (Field5) — varchar
- is_usable (Field3) — boolean
- created_dt (Field8)
- updated_dt (Field6)