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