DB_V1
Tables (12)
encounter
- encounter_id — VARCHAR(50) — NOT NULL
- pet_id — VARCHAR(50) — NOT NULL
- hospital_id — VARCHAR(50) — NOT NULL
- encounter_date — DATETIME
- chief_complaint — VARCHAR(255)
- subjective_note — TEXT
- assessment_note — TEXT
- raw_text — TEXT
hospital
- hospital_id — VARCHAR(50) — NOT NULL
- practitioner_id — VARCHAR(50)
image
- image_id — VARCHAR(50) — NOT NULL
- encounter_id — VARCHAR(50) — NOT NULL
- image_path — VARCHAR(255)
- modality — VARCHAR(50)
- image_desc — VARCHAR(255)
- image_date — DATE
invoice
- invoice_id — VARCHAR(50) — NOT NULL
- encounter_id — VARCHAR(50) — NOT NULL
- billing_date — DATETIME
- total_amount — DECIMAL(15, 2)
invoice_item
- item_id — INT
- invoice_id — VARCHAR(50) — NOT NULL
- item_name — VARCHAR(100) — NOT NULL
- unit_price — DECIMAL(15, 2) — NOT NULL
- quantity — DECIMAL(10, 2) — NOT NULL
- subtotal — DECIMAL(15, 2) — NOT NULL
objective_lab
- lab_id — INT
- encounter_id — VARCHAR(50) — NOT NULL
- lab_test_name — VARCHAR(100)
- lab_device_name — VARCHAR(100)
- lab_value — FLOAT
- lab_reference_range — VARCHAR(50)
- lab_result — VARCHAR(50)
- lab_unit — VARCHAR(20)
- objective_note — TEXT
objective_vital
- encounter_id — VARCHAR(50) — NOT NULL
- body_weight — FLOAT
- body_temperature — FLOAT
- respiratory_rate — INT
- heart_rate — INT
- systolic_bp — INT
pet
- pet_id — VARCHAR(50) — NOT NULL
- hospital_id — VARCHAR(50) — NOT NULL
- species — VARCHAR(50)
- breed — VARCHAR(50)
- sex — VARCHAR(10)
- birth_date — DATE
- allergy — VARCHAR(255)
- immunization_history — VARCHAR(255)
- updated_at — DATETIME
plan_medication
- med_id — INT
- encounter_id — VARCHAR(50) — NOT NULL
- dose_name — VARCHAR(100)
- dose_value — FLOAT
- dose_unit — VARCHAR(20)
- dose_frequency — INT
- dose_days — INT
- dose_route — VARCHAR(50)
plan_procedure
- proc_id — INT
- encounter_id — VARCHAR(50) — NOT NULL
- procedure_name — VARCHAR(100)
- procedure_date — DATETIME
- admission_date — DATE
- discharge_date — DATE
- plan_note — TEXT
- diagnosis_name — VARCHAR(255)
- diagnosis_status — VARCHAR(50)
practitioner
- practitioner_id — VARCHAR(50) — Primary key — NOT NULL
- practitioner_name — VARCHAR(100)
- hospital_id — VARCHAR(50) — Foreign key — NOT NULL
- data_source — VARCHAR(50) — Foreign key — NOT NULL
sex_master
- sex_id — INT — Primary key — NOT NULL
- sex_name — VARCHAR(20) — NOT NULL