진료 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