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