economic

Tables (6)

economic_event_type_mapping

  • event_type_code — bigint — Primary key — NOT NULL
  • ui_label — varchar(100) — NOT NULL
  • category — varchar(50) — NOT NULL
  • event_type_en — varchar(100) — NOT NULL
  • event_type_ko — varchar(100) — NOT NULL

economic_events

  • lang — text — Primary key — NOT NULL
  • event_id (event_id2) — varchar — Foreign key → economic_events_raw.event_id — NOT NULL
  • unit (unit2) — varchar(100) — Foreign key → economic_events_raw.unit — NOT NULL
  • event_type_code (event_type_code2) — bigint — Foreign key → economic_events_raw.event_type_code — NOT NULL
  • lang (lang2) — varchar — Foreign key → economic_events_i18n.lang — NOT NULL
  • ric (Key) — varchar — Foreign key → economic_events_i18n.ric — NOT NULL
  • id — bigint — NOT NULL
  • instrument — varchar
  • event_type_name — varchar
  • impact — varchar
  • indicator_name — varchar
  • periodicity — varchar
  • country — varchar
  • start_date_time — timestamp
  • end_date_time — timestamp
  • last_updated — timestamp
  • date_specifier — varchar
  • primary_source — varchar
  • period — date
  • expected_value — numeric
  • prelim_value — numeric
  • prior_value — numeric
  • actual_value — numeric
  • residual_value — numeric
  • unit_mapping_symbol — varchar(100)
  • scale — numeric
  • created_dt — timestamp
  • updated_dt — timestamp

economic_events_i18n

  • id — bigserial — Primary key — NOT NULL
  • lang — varchar — Primary key — NOT NULL
  • ric (Key) — varchar — Foreign key → economic_events_raw.ric — NOT NULL
  • event_category_code — varchar
  • event_category — varchar
  • event_type_code — bigint
  • event_type — varchar
  • indicator_name — varchar
  • description — varchar
  • primary_source — varchar
  • created_dt — timestamp — NOT NULL
  • updated_dt — timestamp — NOT NULL

economic_events_meta_raw

  • ric (Key) — varchar — Primary key — NOT NULL
  • fcast_prd — varchar — Primary key — NOT NULL
  • id — INTEGER
  • type — VARCHAR(255)
  • service — VARCHAR(255)
  • name — VARCHAR(255)
  • stream — VARCHAR(255)
  • data — VARCHAR(255)
  • text — VARCHAR(255)
  • timeliness — VARCHAR(255)
  • rate — VARCHAR(255)
  • rate_info — INTEGER
  • perm_data — VARCHAR(255)
  • seq_number — INTEGER
  • fields — CLOB — jsonb 타입임
  • snapshot_dt — TIMESTAMP — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP — NOT NULL

economic_events_raw

  • event_id — varchar — Primary key — NOT NULL
  • unit (unit2) — varchar(100) — Foreign key → economic_unit_mapping.unit — NOT NULL
  • event_type_code (event_type_code2) — bigint — Foreign key → economic_event_type_mapping.event_type_code — NOT NULL
  • ric (Key) — varchar — Foreign key — NOT NULL
  • id — bigint — NOT NULL
  • instrument — varchar
  • ric — varchar
  • start_date_time — timestamp
  • end_date_time — timestamp
  • date_specifier — varchar
  • event_name — varchar
  • last_updated — timestamp
  • country — varchar
  • indicator_name — varchar
  • scale — numeric
  • period — date
  • actual_value — numeric
  • expected_value — numeric
  • prior_value — numeric
  • event_type — varchar
  • economic_industry — varchar
  • created_dt — timestamp — NOT NULL
  • updated_dt — timestamp — NOT NULL
  • relevance — integer
  • revised_value — numeric

economic_unit_mapping

  • id — bigint — Primary key — NOT NULL
  • unit — varchar(100) — Primary key — NOT NULL
  • unit_mapping_symbol — varchar(100) — NOT NULL