1
Tables (7)
DigHerbal (의보약 단미제 표준코드정보 저장)
HerbMast (의보한약 수가)
- Code (Field) — int — Primary key
- Name (Field4) — varchar(100)
- CompName (Field2) — varchar(50)
- Unit (Field3) — real
- Amt (Field5) — real
- Price (Field6) — money
- CompCode (Field7) — smallint
- PrsCode (Field8) — int
- IsCode (Field9) — varchar(9)
- DueDate (Field11) — varchar(8)
- ExpDate (Field12) — varchar(8)
- LimDate (Field13) — varchar(8)
- HerbalDate (Field14) — varchar(8)
- Shape (Field10) — tinyint
- HerbAmt (Field15) — real
- UnitName (Field16) — varchar(10)
HerbPrs (처방약제수가(기준처방,가감처방,임의처방))
- Code (1) — int
- DueDate (Field2) — varchar(8)
- ExpDate (Field3) — varchar(8)
- Name (Field4) — varchar(100)
- Weight (Field5) — real
- Price (Field6) — money
- Add (Field11) — tinyint
- Def (Field12) — tinyint
- Type (Field7) — tinyint
- AddItem1 (Field13) — char(4)
- AddItem2 (Field14) — char(4)
- LinkCode (Field8) — int
- KPCode (Field15) — int
- KPName (Field16) — varchar(100)
- Company (Field9) — smallint
- Freq (Field10) — tinyint
- BasicDate (Field17) — varchar(8)
- Shape (Field18) — tinyint
HerbPrsEx (CopyOfCopyOfUntitled2)
- BasicDate (Field4) — varchar(8)
- Code (Field) — int
- IsCode (Field2) — varchar(8)
- Name (Field3) — varchar(20)
- Weight (Field5) — real
- Price (Field6) — money
- WP (Field7) — real
HerbPrsMix (처방약제 혼합엑스산제 기준약제)
- Code — int — Foreign key → Herbal.Code — jkjk
- DueDate (Field2) — varchar(8)
- ExpDate (Field3) — varchar(8)
- Name (Field4) — varchar(100)
- Weight (Field5) — real
- Price (Field6) — money
- Type (Field7) — tinyint
- LinkCode (Field8) — int
- Mode (Field9) — tinyint
- Shape (Field10) — tinyint
Herbal (처방에 사용한 기본약제)
- Code — int — Primary key — jkjk
- DueDate (Field2) — char(8)
- IsCode (Field3) — char(8)
- Name (Field4) — varchar(20)
- Weight (Field5) — real
- Price (Field6) — money
- KPCode (Field7) — int
- KPName (Field8) — varchar(100)
- WP (Field9) — real
- PrsWeight (Field10) — real
- PrsPrice (Field11) — money