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