guide_eye_db

Tables (5)

connection

  • Key (id) — Primary key — NOT NULL
  • Key (disabled) — Int — Foreign key → user.Key — NOT NULL
  • Field (guardian) — Int

connection_request (Untitled)

  • Key (id) — Int — Primary key — NOT NULL
  • Key (request) — Int — Foreign key → user.Key — NOT NULL
  • Key (receiver) — Int
  • Field (accepted) — Boolean

user

  • Key (id) — Int — Primary key — NOT NULL
  • Field (email) — String
  • Field (password) — String
  • Field (role) — Enum
  • Field (crosswalk) — Boolean
  • Field (sidewalk_block) — Boolean
  • Field (notification_access) — Boolean
  • Field (location_access) — Boolean
  • Field (guardian_tracking_access) — Boolean

user_gps_log

  • Key (id) — Primary key — NOT NULL
  • Key (userId) — Int — Foreign key → user.Key — NOT NULL
  • Field (latitude) — Number
  • Field (datetime) — Date

user_hazard_access_log

  • Key (id) — Primary key — NOT NULL
  • Key (userId) — Int — Foreign key → user.Key — NOT NULL
  • Field (latitude) — Number
  • Field (longitude) — Number
  • Field (datetime) — Date
  • Field (hazard) — Enum