진료 SOAP 코드 중심 ERD
테이블 (28)
ANIMAL
- animal_uuid — VARCHAR(64)
- animal_name — VARCHAR(200)
- species_cd — VARCHAR(50)
- breed_cd — VARCHAR(50)
- sex_cd — VARCHAR(50)
COM_CODE_D
- com_cd — VARCHAR(50)
- com_group_id — VARCHAR(50) — 외래 키 → COM_CODE_M.com_group_id — NOT NULL
- com_name_ko — VARCHAR(200)
- com_name_en — VARCHAR(200)
- sort_no — INT
- use_yn — CHAR(1)
COM_CODE_M
- com_group_id — VARCHAR(50)
- com_group_name — VARCHAR(200) — NOT NULL
DX_CODE_D
- dx_cd — VARCHAR(50)
- dx_group_id — VARCHAR(50) — 외래 키 → DX_CODE_M.dx_group_id — NOT NULL
- dx_name_ko — VARCHAR(200)
- dx_name_en — VARCHAR(200)
- sort_no — INT
- use_yn — CHAR(1)
DX_CODE_M
- dx_group_id — VARCHAR(50)
- dx_group_name — VARCHAR(200) — NOT NULL
ENCOUNTER
- encounter_uuid — VARCHAR(64)
- animal_uuid — VARCHAR(64) — 외래 키 → ANIMAL.animal_uuid — NOT NULL
- visit_dt — DATETIME
- visit_type_cd — VARCHAR(50) — 외래 키 → COM_CODE_D.com_cd
EXAM_CODE_D
- exam_cd — VARCHAR(50)
- exam_group_id — VARCHAR(50) — 외래 키 → EXAM_CODE_M.exam_group_id — NOT NULL
- exam_name_ko — VARCHAR(200)
- exam_name_en — VARCHAR(200)
- sort_no — INT
- use_yn — CHAR(1)
EXAM_CODE_M
- exam_group_id — VARCHAR(50)
- exam_group_name — VARCHAR(200) — NOT NULL
O_BODY_CONDITION
- bc_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- body_weight — VARCHAR(50)
- bcs — VARCHAR(50)
- mcs — VARCHAR(50)
O_DERMA_EXAM
- derma_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- lesion_type_cd — VARCHAR(50)
- distribution_cd — VARCHAR(50)
- pruritus_score — VARCHAR(50)
O_DIAG_TEST_RESULT
- test_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- modality_cd — VARCHAR(50)
- result_text — TEXT
O_NEURO_EXAM
- neuro_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- posture_cd — VARCHAR(50) — 외래 키 → EXAM_CODE_D.exam_cd
- reaction_cd — VARCHAR(50) — 외래 키 → EXAM_CODE_D.exam_cd
- remark — TEXT
O_OPHTH_EXAM
- ophth_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- plr_cd — VARCHAR(50)
- menace_cd — VARCHAR(50)
- remark — TEXT
O_ORTHO_EXAM
- ortho_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- lameness_grade — VARCHAR(50)
- remark — TEXT
O_PHYSICAL_EXAM
- phys_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- summary_text — TEXT
O_VITAL_SIGNS
- vital_uuid — VARCHAR(64)
- o_record_uuid — VARCHAR(64) — 외래 키 → SOAP_O_RECORD.o_record_uuid — NOT NULL
- temperature — VARCHAR(50)
- heart_rate — VARCHAR(50)
- respiratory_rate — VARCHAR(50)
- spo2 — VARCHAR(50)
PLAN_CODE_D
- plan_cd — VARCHAR(50)
- plan_group_id — VARCHAR(50) — 외래 키 → PLAN_CODE_M.plan_group_id — NOT NULL
- plan_name_ko — VARCHAR(200)
- plan_name_en — VARCHAR(200)
- sort_no — INT
- use_yn — CHAR(1)
PLAN_CODE_M
- plan_group_id — VARCHAR(50)
- plan_group_name — VARCHAR(200) — NOT NULL
SOAP_A
- soap_a_uuid — VARCHAR(64)
- soap_uuid — VARCHAR(64) — 외래 키 → SOAP_NOTE.soap_uuid — NOT NULL
- assessment_text — TEXT
SOAP_A_DIAGNOSIS
- map_uuid — VARCHAR(64)
- soap_a_uuid — VARCHAR(64) — 외래 키 → SOAP_A.soap_a_uuid — NOT NULL
- diagnosis_cd — VARCHAR(50) — 외래 키 → DX_CODE_D.dx_cd — NOT NULL
SOAP_NOTE
- soap_uuid — VARCHAR(64)
- encounter_uuid — VARCHAR(64) — 외래 키 → ENCOUNTER.encounter_uuid — NOT NULL
- created_dt — DATETIME
SOAP_O_RECORD
- o_record_uuid — VARCHAR(64)
- soap_uuid — VARCHAR(64) — 외래 키 → SOAP_NOTE.soap_uuid — NOT NULL
- exam_type_cd — VARCHAR(50) — 외래 키 → EXAM_CODE_D.exam_cd — NOT NULL
- recorded_dt — DATETIME
SOAP_P
- soap_p_uuid — VARCHAR(64)
- soap_uuid — VARCHAR(64) — 외래 키 → SOAP_NOTE.soap_uuid — NOT NULL
- plan_text — TEXT
SOAP_P_ITEM
- item_uuid — VARCHAR(64)
- soap_p_uuid — VARCHAR(64) — 외래 키 → SOAP_P.soap_p_uuid — NOT NULL
- plan_item_type_cd — VARCHAR(50) — 외래 키 → PLAN_CODE_D.plan_cd
- plan_item_cd — VARCHAR(50) — 외래 키 → PLAN_CODE_D.plan_cd
- remark — TEXT
SOAP_S
- soap_s_uuid — VARCHAR(64)
- soap_uuid — VARCHAR(64) — 외래 키 → SOAP_NOTE.soap_uuid — NOT NULL
- subjective_text — TEXT
SOAP_S_SYMPTOM
- map_uuid — VARCHAR(64)
- soap_s_uuid — VARCHAR(64) — 외래 키 → SOAP_S.soap_s_uuid — NOT NULL
- symptom_cd — VARCHAR(50) — 외래 키 → SYM_CODE_D.sym_cd — NOT NULL
SYM_CODE_D
- sym_cd — VARCHAR(50)
- sym_group_id — VARCHAR(50) — 외래 키 → SYM_CODE_M.sym_group_id — NOT NULL
- sym_name_ko — VARCHAR(200)
- sym_name_en — VARCHAR(200)
- sort_no — INT
- use_yn — CHAR(1)
SYM_CODE_M
- sym_group_id — VARCHAR(50)
- sym_group_name — VARCHAR(200) — NOT NULL