pawwalk
Tables (15)
blocks
- id — UUID — Primary key — NOT NULL
- blocker_id — UUID — Foreign key — NOT NULL
- blocked_id — UUID — Foreign key — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
chat_messages
- id — UUID — Primary key — NOT NULL
- connection_id — UUID — Foreign key → connections.id — NOT NULL
- sender_id — UUID — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
connections
- id — UUID — Primary key — NOT NULL
- user_a_id — UUID — Foreign key → users.id — NOT NULL
- user_b_id — UUID — Foreign key → users.id — NOT NULL
- source_walk_post_id — UUID — Foreign key → walk_posts.id
- created_at — TIMESTAMPTZ — NOT NULL
device_tokens
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key — NOT NULL
- apns_token — TEXT — NOT NULL
- platform — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
dogs
- id — UUID — Primary key — NOT NULL
- owner_id — UUID — Foreign key → users.id — NOT NULL
- name — TEXT — NOT NULL
- breed — TEXT
- birth_date — DATE
- gender — TEXT
- size — TEXT
- energy_level — TEXT
- neutered — BOOLEAN
- profile_image_url — TEXT
- animal_registration_number — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
reports
- id — UUID — Primary key — NOT NULL
- reporter_id — UUID — Foreign key — NOT NULL
- reported_user_id — UUID — Foreign key — NOT NULL
- reason — TEXT — NOT NULL
- details — TEXT
- status — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
service_areas
- id — UUID — Primary key — NOT NULL
- name — TEXT — NOT NULL
- center_lat — DOUBLE PRECISION — NOT NULL
- center_lng — DOUBLE PRECISION — NOT NULL
- radius_meters — INTEGER — NOT NULL
- status — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
subscriptions
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- tier — TEXT — NOT NULL
- apple_transaction_id — TEXT
- started_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ
- status — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
users
- id — UUID — Primary key — NOT NULL
- email — TEXT — NOT NULL
- display_name — TEXT — NOT NULL
- profile_image_url — TEXT
- subscription_tier — TEXT — NOT NULL
- onboarding_completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
vaccination_records
- id — UUID — Primary key — NOT NULL
- dog_id — UUID — Foreign key → dogs.id — NOT NULL
- vaccine_type — TEXT — NOT NULL
- administered_date — DATE — NOT NULL
- next_due_date — DATE
- reminder_sent_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
waitlist_signups
- id — UUID — Primary key — NOT NULL
- email — TEXT — NOT NULL
- lat — DOUBLE PRECISION
- lng — DOUBLE PRECISION
- nearest_service_area_id — UUID — Foreign key → service_areas.id
- created_at — TIMESTAMPTZ — NOT NULL
walk_cards
- id — UUID — Primary key — NOT NULL
- walk_session_id — UUID — Foreign key → walk_sessions.id — NOT NULL
- image_url — TEXT — NOT NULL
- template_style — TEXT — NOT NULL
- shared_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
walk_post_requests
- id — UUID — Primary key — NOT NULL
- walk_post_id — UUID — Foreign key → walk_posts.id — NOT NULL
- requester_dog_id — UUID — Foreign key → dogs.id — NOT NULL
- status — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- responded_at — TIMESTAMPTZ
walk_posts
- id — UUID — Primary key — NOT NULL
- host_dog_id — UUID — Foreign key → dogs.id — NOT NULL
- service_area_id — UUID — Foreign key → service_areas.id — NOT NULL
- lat — DOUBLE PRECISION — NOT NULL
- lng — DOUBLE PRECISION — NOT NULL
- scheduled_at — TIMESTAMPTZ — NOT NULL
- size_filter — TEXT
- age_filter — TEXT
- energy_filter — TEXT
- status — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
walk_sessions
- id — UUID — Primary key — NOT NULL
- dog_id — UUID — Foreign key → dogs.id — NOT NULL
- walk_post_id — UUID — Foreign key → walk_posts.id
- started_at — TIMESTAMPTZ — NOT NULL
- ended_at — TIMESTAMPTZ
- distance_meters — NUMERIC
- route — JSONB
- weather_condition — TEXT
- weather_temp_celsius — NUMERIC
- created_at — TIMESTAMPTZ — NOT NULL