news_tag

Tables (5)

informax_news_raw

  • link — text — Primary key — NOT NULL
  • id — integer — Primary key — NOT NULL
  • ticker — jsonb
  • ric — jsonb
  • title — text — NOT NULL
  • summary — text
  • pub_date — timestamp
  • created_dt — timestamp
  • updated_dt — timestamp

informax_news_tag

  • news_key (link) — text — Primary key — NOT NULL
  • title — text — NOT NULL
  • summary — text
  • pub_date — timestamp
  • created_dt — timestamp
  • updated_dt — timestamp
  • id — integer — NOT NULL
  • ric — jsonb

integrate_news_event

  • id — serial — Primary key
  • news_integrate_id — serial — Foreign key → integrate_news_meta.news_integrate_id
  • low_level_topic — varchar
  • sub_level_topic — varchar
  • leaf_level_topic — varchar
  • code — varchar
  • created_dt — timestamp
  • updated_dt — timestamp
  • top_level_topic — varchar
  • normalized_name — varchar
  • ric — varchar

integrate_news_meta

  • news_integrate_id — serial — Primary key
  • news_key (news_id) — bigint — Foreign key → refinitiv_parsing_news.news_key — NOT NULL
  • news_key — text
  • news_src — varchar
  • created_dt — timestamp
  • updated_dt — timestamp

refinitiv_parsing_news

  • news_key (news_id) — bigint — Primary key — NOT NULL
  • origin_news_id — bigint
  • title — varchar
  • lang — varchar
  • parsing_body — varchar
  • origin_body — varchar
  • origin_str_body — varchar
  • created_dt — timestamp
  • updated_dt — timestamp
  • ticker_tag — jsonb
  • story_type — jsonb
  • keyword — jsonb
  • prefix — jsonb
  • published_dt — timestamp — NOT NULL