동물병원 구글 시트 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