1

Tables (7)

DigHerbal (의보약 단미제 표준코드정보 저장)

    HerbChange (Untitled)

      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