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)