Chart Treatment tables

Tables (11)

TB_EXAMINATION_ITEM

  • pnt_uid — varchar(20) — Primary key — NOT NULL
  • issue_date — date — Primary key — NOT NULL
  • seq — int — Primary key — NOT NULL
  • sub_seq — int — Primary key — NOT NULL
  • writer — varchar(20) — NOT NULL
  • tooth_number — numeric(19,0) — NOT NULL
  • pi_mask_link — nvarchar(1000)
  • exam_package_cd — varchar(100)
  • emr_certificate_uid — varchar(36)
  • examination_uid_old — varchar(36)
  • implant_tooth — numeric(19,0)
  • pontic_tooth — numeric(19,0)

TB_EXAMINATION_PACKAGE

  • exam_package_cd — varchar(100) — Primary key — NOT NULL
  • doctor_uid — varchar(20) — NOT NULL
  • symptom_name — nvarchar(100) — NOT NULL
  • symptom_eng_name — nvarchar(100)
  • delete_date — datetime
  • note — nvarchar(400)
  • chartkey_id — int
  • chartkey_type — int
  • dir — char(1) — NOT NULL
  • attributes — int
  • description — nvarchar(2000)
  • delete_yn — char(1)
  • pi_more_mask — numeric(18,0)
  • select_teeth_yn — char(1)

TB_EXAMINATION_PACKAGE_TREE

  • exam_tree_cd — varchar(100) — Primary key — NOT NULL
  • doctor_uid — varchar(20) — NOT NULL
  • seq — int — NOT NULL
  • parent_tree_cd — varchar(100)
  • exam_name — nvarchar(100) — NOT NULL
  • exam_package_cd — varchar(100)
  • description — nvarchar(2000)
  • delete_yn — char(1)
  • xpos — int
  • ypos — int
  • background_color — varchar(10)
  • font_color — varchar(10)

TB_REMEDY_ITEM

  • 환자_uid (pnt_uid) — varchar(20) — Primary key — NOT NULL
  • 진료일자 (treatment_date) — date — Primary key — NOT NULL
  • 진료번호 (remedy_no) — int — Primary key — NOT NULL
  • 순서 (seq) — int — Primary key — NOT NULL
  • 진료비용코드 (treatcharge_cd) — varchar(9) — NOT NULL
  • 횟수 (count) — float — NOT NULL
  • 일수 (day) — int — NOT NULL
  • 금액 (fee) — int — NOT NULL
  • markup_fee — int
  • use_calc — char(1) — NOT NULL
  • vf_cd — varchar(100)
  • exception_id — int
  • particulars — nvarchar(700)
  • group_cd — int
  • class — int
  • trust_div — int
  • trust_cd — varchar(8)
  • trust_date — date
  • prescription_div — int
  • package_code — varchar(100)
  • corp_charge — int
  • charge_div — char(1)
  • charge_name — nvarchar(300)
  • pnt_insured_charge — int
  • pnt_noninsured_charge — int
  • fixed_rate — int
  • dose — numeric(7,4)
  • item_percent — int
  • prn — char(1)
  • hospday — int
  • doct_id — varchar(20)
  • low_content_code — char(1)
  • low_content_remark — nvarchar(1000)
  • dur_code — varchar(10)
  • dur_remark — nvarchar(400)
  • liquid_type — char(1)
  • liquid_reason — nvarchar(1000)
  • liquid_gasan — char(1)
  • remedy_uid_old — varchar(36)

TB_REMEDY_PACKAGE

  • 의사_uid (doctor_uid) — varchar(20) — Primary key — NOT NULL
  • 진료패키지코드 (remedy_package_cd) — varchar(100) — Primary key — NOT NULL
  • 진료이름 (remedy_name) — nvarchar(100)
  • 영문이름 (eng_name) — nvarchar(100)
  • 한글이름 (kor_name) — nvarchar(100)
  • 속성 (attributes) — int
  • 순서 (seq) — int
  • particulars — nvarchar(200)
  • 내역설명 (description) — nvarchar(500)
  • 상병1 (disease_cd1) — varchar(20)
  • 상병2 (disease_cd2) — varchar(20)
  • 상병3 (disease_cd3) — varchar(20)
  • 상병4 (disease_cd4) — varchar(20)
  • 부서아이디 (department_id) — int
  • insure_div — char(1)
  • delete_yn — char(1)
  • trust_cd — varchar(8)
  • disease_sel_yn — char(1)
  • text_color — varchar(10)
  • text_bold_yn — char(1)
  • background_color — varchar(10)
  • particular1 — nvarchar(400)
  • particular2 — nvarchar(400)
  • particular3 — nvarchar(400)
  • particular4 — nvarchar(400)
  • particular5 — nvarchar(400)
  • particular6 — nvarchar(400)
  • particular7 — nvarchar(400)
  • particular8 — nvarchar(400)
  • charge_sel_yn — char(1)
  • particular_sel_yn — char(1)
  • auto_particular — int

TB_REMEDY_PACKAGE_ITEM

  • 진료패키지코드 (remedy_package_cd) — varchar(100) — Primary key — NOT NULL
  • 순서 (seq) — int — Primary key — NOT NULL
  • 투약량 (amount) — numeric(18,2) — NOT NULL
  • 횟수 (count) — numeric(5,2) — NOT NULL
  • 일수 (day) — numeric(5,0) — NOT NULL
  • chief_chartkey_yn — char(1)
  • group_cd — int
  • delete_yn — char(1)
  • treat_selectable — char(1)
  • txplan_selectable — char(1)
  • treatcharge_cd — varchar(9) — NOT NULL

TB_REMEDY_PACKAGE_TREE

  • 진료트리코드 (remedy_tree_cd) — varchar(100) — Primary key — NOT NULL
  • 의사_uid (doctor_uid) — varchar(20) — NOT NULL
  • 순서 (seq) — int
  • 진료이름 (remedy_name) — nvarchar(100) — NOT NULL
  • 부모트리코드 (parent_tree_cd) — varchar(100) — NOT NULL
  • 진료패키지코드 (remedy_package_cd) — varchar(100)
  • 내역설명 (description) — nvarchar(2000)
  • delete_yn — char(1)
  • show_yn — char(1)
  • background_color — varchar(10)

TB_TREATMENT_PLAN_PACKAGE

  • plan_package_cd — varchar(100) — Primary key — NOT NULL
  • doctor_uid — varchar(20) — NOT NULL
  • plan_package_name — nvarchar(100) — NOT NULL
  • eng_name — varchar(100)
  • attributes — int
  • description — nvarchar(2000)
  • seq — int
  • select_teeth_yn — char(1)

TB_TREATMENT_PLAN_PACKAGE_TREE

  • plan_tree_cd — varchar(100) — Primary key — NOT NULL
  • doctor_uid — varchar(20) — NOT NULL
  • seq — int — NOT NULL
  • plan_package_cd — varchar(100)
  • parent_tree_cd — varchar(100) — NOT NULL
  • plan_name — nvarchar(100)
  • description — nvarchar(2000)
  • background_color — varchar(10)
  • font_color — varchar(10)

TB_TX_NEXT_PACKAGE

  • tx_next_package_cd — varchar(100) — Primary key — NOT NULL
  • doctor_uid — varchar(20) — NOT NULL
  • tx_next_name — nvarchar(100) — NOT NULL
  • tx_next_eng_name — nvarchar(100)
  • next_tx_term — int
  • next_tx_term_type — char(1)
  • treat_time — int
  • is_select_teeth_yn — char(1)
  • description — nvarchar(2000)
  • delete_yn — char(1)
  • text_color — varchar(10)
  • background_color — varchar(10)
  • bleeding_yn — char(1)

TB_TX_NEXT_PACKAGE_TREE

  • tx_next_tree_cd — varchar(100) — Primary key — NOT NULL
  • doctor_uid — varchar(20) — NOT NULL
  • seq — int — NOT NULL
  • parent_tree_cd — varchar(100)
  • tx_next_name — nvarchar(100)
  • tx_next_package_cd — varchar(100)
  • description — nvarchar(2000)
  • delete_yn — char(1)
  • text_color — varchar(10)
  • background_color — varchar(10)
  • font_color — varchar(10)