smarthealthdog
Tables (4)
FamilyDiseaseAlert
- id — BIGSERIAL
- target_user_id — BIGINT — NOT NULL
- target_pet_id — BIGINT — Foreign key → Pet.id — NOT NULL
- source_pet_id — BIGINT — Foreign key → Pet.id — NOT NULL
- source_diagnosis_id — BIGINT — NOT NULL
- alert_message — TEXT
- is_read — BOOLEAN
- created_at — TIMESTAMP
Pedigree
- id — BIGSERIAL
- lineage_name — VARCHAR(100) — NOT NULL
- description — TEXT
- species — VARCHAR(255)
- created_at — TIMESTAMP
PeriodontalMeasurement
- id — BIGSERIAL
- submission_id — BIGINT — NOT NULL
- image_url — VARCHAR(255)
- ai_confidence_score — NUMERIC(5,2)
- severity_stage — INTEGER
- detected_symptoms — JSONB
- measured_at — TIMESTAMP
Pet
- id — BIGSERIAL
- name — VARCHAR(50)
- user_id — BIGINT
- pedigree_id — BIGINT — Foreign key → Pedigree.id
- sire_id — BIGINT — Foreign key → Pet.id
- dam_id — BIGINT — Foreign key → Pet.id
- birth_order — INTEGER