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