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