smarthealthdog1

Tables (28)

CheckMethodTranslation

  • check_method_id — BIGINT — Foreign key → ConditionCheckMethod.id
  • language_id — BIGINT — Foreign key → Language.id
  • translated_name — VARCHAR(100)
  • translated_description — TEXT

Condition

  • id — BIGSERIAL
  • name — VARCHAR(100)
  • species — VARCHAR(50)
  • description — TEXT

ConditionCheckMethod

  • id — BIGSERIAL
  • name — VARCHAR(100)
  • description — TEXT

ConditionTranslation

  • condition_id — BIGINT — Foreign key → Condition.id
  • language_id — BIGINT — Foreign key → Language.id
  • translated_name — VARCHAR(100)
  • translated_description — TEXT

Condition_ConditionCheckMethod

  • condition_id — BIGINT — Foreign key → Condition.id
  • check_method_id — BIGINT — Foreign key → ConditionCheckMethod.id

Diagnosis

  • id — BIGSERIAL
  • submission_id — BIGINT — Foreign key → Submission.id
  • condition_id — BIGINT — Foreign key → Condition.id
  • probability — NUMERIC(5, 4)
  • model_md5_hash — VARCHAR(255)

DiagnosisResult

  • id — BIGSERIAL
  • pet_species — VARCHAR(50)
  • body_part — VARCHAR(50)
  • name — VARCHAR(100)
  • description — TEXT

DiagnosisStatus

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT

EmailVerification

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • email_verification_token — VARCHAR(255)
  • email_verification_tries — INT
  • email_verification_requested_at — TIMESTAMP
  • email_verification_expiry — TIMESTAMP
  • email_verification_fail_count — INT
  • email_verification_locked_at — TIMESTAMP

FamilyDiseaseAlert

  • id — BIGSERIAL
  • target_user_id — BIGINT — Foreign key → User.id — 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 — Foreign key → Diagnosis.id — NOT NULL
  • alert_message — TEXT
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

Language

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • native_name — VARCHAR(50)
  • code — VARCHAR(10) — NOT NULL

NotificationTemplateType

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • color_code — VARCHAR(20)

Pedigree

  • id — BIGSERIAL
  • lineage_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP

PeriodontalMeasurement

  • id — BIGSERIAL
  • submission_id — BIGINT — Foreign key → Submission.id — NOT NULL
  • image_url — VARCHAR(255)
  • ai_confidence_score — NUMERIC(5,2)
  • severity_stage — INTEGER
  • detected_symptoms — JSONB
  • measured_at — TIMESTAMP

Permission

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT

Pet

  • id — BIGSERIAL
  • owner_id — BIGINT — Foreign key → User.id
  • name — VARCHAR(50)
  • species — VARCHAR(50)
  • gender — VARCHAR(20)
  • breed — VARCHAR(50)
  • weight_kg — NUMERIC(5, 2)
  • birthday — DATE
  • is_neutered — BOOLEAN
  • profile_image — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • pedigree_id — BIGINT — Foreign key → Pedigree.id
  • sire_id — BIGINT — Foreign key → Pet.id
  • dam_id — BIGINT — Foreign key → Pet.id
  • birth_order — INTEGER

RefreshToken

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → User.id
  • expires_at — TIMESTAMP

Role

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT

RolePermission

  • role_id — BIGINT — Foreign key → Role.id
  • permission_id — BIGINT — Foreign key → Permission.id

Shelter

  • id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(50)
  • address — TEXT
  • introduction — TEXT
  • latitude — NUMERIC(10, 7)
  • longitude — NUMERIC(10, 7)

SocialLoginProvider

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL

SocialLoginUser

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → User.id
  • provider_id — BIGINT — Foreign key → SocialLoginProvider.id
  • provider_user_id — VARCHAR(255)
  • extra_data — JSONB
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Submission

  • id — BIGSERIAL
  • pet_id — BIGINT — Foreign key → Pet.id
  • type — VARCHAR(50)
  • photo_url — VARCHAR(255)
  • status — VARCHAR(50)
  • submitted_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • failure_reason — TEXT
  • celery_task_string — VARCHAR(255)
  • retry_count — INT

UrineAnalyte

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT

UrineMeasurement

  • id — BIGSERIAL
  • submission_id — BIGINT — Foreign key → Submission.id
  • analyte_id — BIGINT — Foreign key → UrineAnalyte.id
  • value — NUMERIC(10, 4)
  • color_r — INT
  • color_g — INT
  • color_b — INT

User

  • id — BIGSERIAL
  • public_id — VARCHAR(100)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • role_id — BIGINT — Foreign key → Role.id
  • nickname — VARCHAR(50)
  • profile_pic — VARCHAR(255)
  • login_attempt — INT
  • login_attempt_started_at — TIMESTAMP
  • password_reset_token — VARCHAR(255)
  • password_reset_token_expiry — TIMESTAMP
  • password_reset_requested_at — TIMESTAMP
  • password_reset_token_verify_fail_count — INT
  • email_verification_token — VARCHAR(255)
  • email_verification_expiry — TIMESTAMP
  • email_verification_requested_at — TIMESTAMP
  • email_verification_tries — INT
  • email_verification_fail_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

UserAccountAction

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → User.id
  • action_type — VARCHAR(50)
  • reason — TEXT
  • action_by_user_id — BIGINT — Foreign key → User.id
  • action_timestamp — TIMESTAMP

Walk

  • id — BIGSERIAL
  • pet_id — BIGINT — Foreign key → Pet.id
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • distance_km — NUMERIC(5, 2)
  • path_coordinates — JSONB