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