동물병원 구글 시트 erd

테이블 (9)

assessment (Untitled5)

  • assessment_note (Field) — TEXT
  • encounter_id (Key) — string — 외래 키 → subjective.encounter_id — NOT NULL

chart (Untitled9)

  • pet_id (Key) — string — 외래 키 → pet.pet_id — NOT NULL
  • image_id (Key2) — string — 외래 키 → image.image_id — NOT NULL
  • encounter_id (Key3) — string — 외래 키 → subjective.encounter_id — NOT NULL

hospital (Untitled8)

  • hospital_id (Key) — string — 기본 키 — NOT NULL
  • practitioner_id (Field) — string

image (Untitled2)

  • image_id (Key) — string — 기본 키 — NOT NULL
  • image_data (Field)
  • modality (Field2) — string
  • file_type (Field3) — string
  • image_desc (Field4) — string
  • image_date (Field5) — date
  • pet_id (Key3) — string — 외래 키 → pet.pet_id — NOT NULL

invoice (Untitled7)

  • invoice_id (Key) — string — 기본 키 — NOT NULL
  • billing_date (Field) — date
  • unit_price (Field2) — float/int
  • quantity_unit (Field3) — string
  • total_amount (Field4) — float/int
  • pet_id (Key2) — string — 외래 키 → pet.pet_id — NOT NULL

objective (Untitled4)

  • body_weight (Field) — float
  • body_temperature (Field2) — float
  • respiratory_rate (Field3) — int
  • heart_rate (Field4) — int
  • systolic_bp (Field5) — int
  • lab_test_name (Field6) — string
  • lab_device_name (Field7) — string
  • lab_value (Field8) — float
  • lab_reference_range (Field9) — string
  • lab_result (Field10) — string
  • lab_nit (Field11) — string
  • objective_note (Field12) — TEXT
  • encounter_id (Key) — string — 외래 키 → subjective.encounter_id — NOT NULL

pet (Untitled)

  • pet_id (Key) — string — 기본 키 — NOT NULL
  • species (Field) — string
  • breed (Field2) — string
  • sex (Field3) — string
  • birth_date (Field4) — date
  • allergy (Field5) — string
  • immunization_history (Field6) — string
  • hospital_id (Key3) — string — 외래 키 → hospital.hospital_id — NOT NULL
  • updated_at (Field7) — datetime

plan (Untitled6)

  • dose_name (Field) — string
  • dose_value (Field2) — float
  • dose_unit (Field3) — string
  • dose_frequency (Field4) — int
  • dose_days (Field5) — int
  • dose_route (Field6) — string
  • porcedure_name (Field7) — string
  • procedure_date (Field8) — datetime
  • admission_date (Field9) — date
  • discharge_date (Field10) — date
  • stay_duration (Field11) — int
  • plan_note (Field12) — TEXT
  • chart_diagnosis_name (Field13) — string
  • diagnosis_status (Field14) — string
  • encounter_id (Key) — string — 외래 키 → subjective.encounter_id — NOT NULL

subjective (Untitled3)

  • encounter_id (Key) — string — 기본 키 — NOT NULL
  • raw_text (Field) — TEXT
  • chief_complaint (Field2) — string
  • encounter_date (Field3) — date
  • subjective_note (Field4) — TEXT