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)