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