Drug

Tables (3)

BarCodeData (Untitled2)

  • atc_cd (Key6) — Primary key
  • 한글상품명 (Key) — Primary key — NOT NULL
  • 업체명 (Field)
  • 약품규격 (Field2)
  • 제품총수량 (Field3)
  • 제형구분 (Field4)
  • 포장형태 (Field5)
  • 품목기준코드 (Field6)
  • 품목허가일자 (Field7)
  • 전문/일반 (Field8)
  • 대표코드 (Field9)
  • 표준코드 (Field10)
  • 제품코드(개정후) (Field11)
  • 일반명코드(성분명코드) (Field12)
  • 비고 (Field13)
  • 취소일자 (Field14)
  • 양도양수적용(공고)일자 (Field15)
  • 양도양수종료일자 (Field16)
  • 일련번호생략여부 (Field17)
  • 일련번호생략사유 (Field18)
  • 특수관리약품구분 (Field20)
  • 의약품판독장비구분 (Field21)

KPIC_Drug_Info (Untitled)

  • idx (Key) — Primary key — NOT NULL
  • drug_code (Key2) — Primary key — NOT NULL
  • Key3 — Primary key — NOT NULL
  • cls_code (Field8) — Primary key
  • kpic_atc_cd (Key4) — Primary key — NOT NULL
  • boh_hiracode (Key5) — Primary key — NOT NULL
  • atc_cd (Key6) — Primary key — NOT NULL
  • kfda_code (Key7) — Primary key — NOT NULL
  • ig_code (Key8) — Primary key — NOT NULL
  • search_sunb_name (Field)
  • drug_name (Field2)
  • sunb_count (Field3)
  • list_sunb_name (Field4)
  • ingr_mg (Field5)
  • dosage (Field6)
  • upso_name_kfda (Field7)
  • drug_form (Field9)
  • boh (Field10)

NHIS_Drug_Dataset (Untitled3)