datalandingzone
Tables (11)
atc_increment
- atc_cd — varchar(7) — Primary key — NOT NULL
- row_id — serial4 — NOT NULL
- from_row_id — int4 — NOT NULL
- atc_level — int4
- atc_nm_eng — varchar(250) — NOT NULL
- atc_nm_kor — varchar(250) — NOT NULL
- record_dt — timestamp
kcd_rare_disease_increment
- row_id — serial4 — NOT NULL
- from_row_id — int4 — NOT NULL
- kcd_rare_cd — varchar(7) — NOT NULL
- record_dt — timestamp
kcdhira_20260305
- kcd_hira_cd — varchar(7)
- kcd_hira_nm_kor — varchar(250)
- kcd_hira_nm_eng — varchar(300)
- kcd_hira_wcd — varchar(10)
- kcd_hira_msick — varchar(5)
- kcd_hira_cdd — varchar(5)
- kcd_hira_sex — varchar(1)
- kcd_hira_max_age — int2
- kcd_hira_min_age — int2
- kcd_hira_yh — varchar(10)
- row_id — int8
- record_dt — text
price_increment
- data_period — varchar(7) — Primary key — NOT NULL
- prd_edi_cd — varchar(15) — Primary key — NOT NULL
- row_id — serial4 — NOT NULL
- from_row_id — int4 — NOT NULL
- row_no — int4
- admin_route — varchar(20)
- class_id — int4
- mol_cd — varchar(9)
- prd_nm_kor — varchar(300) — NOT NULL
- mfr_nm_kor — varchar(50) — NOT NULL
- dosage_value — varchar(10) — NOT NULL
- dosage_unit — varchar(20) — NOT NULL
- nhi_price — int4 — NOT NULL
- etc_otc — varchar(10)
- prd_comment — text — ext NUL
- pre_prd_edi_cd — varchar(10)
- record_dt — timestamp — NOT NULL
product_increment
- prd_base_cd — varchar(15) — Primary key — NOT NULL
- row_id — int4 — NOT NULL
- from_row_id — int4 — NOT NULL
- prd_nm_kor — varchar(400) — NOT NULL
- prd_nm_eng — varchar(300)
- approve_no — varchar(10)
- prd_status — varchar(20)
- prd_cancel_dt — date
- change_dt — date
- mfr_kor — varchar(50) — NOT NULL
- mfr_eng — varchar(250)
- launch_dt — date
- etc_otc — varchar(10)
- prd_character — varchar(1500)
- prd_std_cd — varchar(15)
- raw_ingredient — text
- main_mol_nm_eng — text
- doc_effect — text
- doc_dosage — text
- doc_comment — text — ext NUL
- doc_add_file — text
- storage_method — text
- validity_desc — text
- re_examined — text
- re_examination_period — text
- pack_form_full — text
- prd_edi_cd — varchar(200)
- drug_classification — varchar(20)
- raw_material_gb — varchar(20)
- new_yn — varchar(10)
- change_reason — text
- tot_volume — text
- main_mol_nm_kor — text
- additive_nm_kor — text
- atc_cd — varchar(7)
- enrollee_id — varchar(20)
- business_id — varchar(20)
- record_dt — timestamp
- mfr_approve_no — text
- orphan_yn — text
- consignment_mfr_nm_kor — text
qc_aggregation
- date_created — timestamp
- row_id — int8
- data_period — varchar(7)
- evix_spec_cd — varchar(4)
- kcd_main_cd — varchar(7)
- evix_prd_cd — int8
- prd_main_cd — varchar(15)
- new_repeat_gb — varchar(10)
- visit_gb — varchar(10)
- gender — varchar(10)
- age_group — varchar(10)
- cnt_patient — float8
- cnt_rx — float8
- single_dosage — float8
- daily_frequency — float8
- daily_dosage — float8
- treatment_days — float8
- total_prescribed_amount — float8
- qc_seq — int4
- cnt_rx_projected — float8
- cnt_patient_projected — float8
- total_prescribed_amount_projected — float8
- pf — float8
- total_prescribed_value — float8
- prd_unit_price — int4
- total_prescribed_value_projected — float8
remote_aggregated_status
- row_id — serial4 — NOT NULL
- care_site_id — int4 — NOT NULL
- aggregated_type — text — NOT NULL
- table_name — text — NOT NULL
- data_period — varchar(7) — NOT NULL
- row_count — int4
- first_date — timestamp
- last_date — timestamp
- first_date_rx_cnt — int4
- last_date_rx_cnt — int4
- ideal_last_date — timestamp
- ideal_last_date_rx_cnt — int4
- complete — varchar(7)
- insert_dt — timestamp
- update_dt — timestamp
- insert_user — varchar(100)
- update_user — varchar(100)
- complete_dt — timestamp
- complete_dt_version — varchar(20)
rx_count_summery
- care_site_id — int4 — NOT NULL
- data_period — varchar(7) — NOT NULL
- row_count — int8
- upsert_dt — timestamp
- upsert_user — text
- table_name — text
tmp_link_exception_cd
- evix_prd_cd — int8
todos
- id — serial4 — Primary key — NOT NULL
- done — bool — NOT NULL
- task — text — NOT NULL
- due — timestamptz
- source_id — int8
- care_site_id — varchar(20)
- record_dt — timestamp
todos_download
- id — serial4 — Primary key — NOT NULL
- done — bool — NOT NULL
- task — text — NOT NULL
- due — timestamptz
- source_id — int8
- care_site_id — int4
- record_dt — timestamp
- hosp_id — int4