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)