PathKeeper

Tables (4)

alert_history

  • alert_history_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — VARCHAR(255) — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)

location_logs

  • location_log_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • location — GEOMETRY(Point, 4326) — NOT NULL
  • battery_level — INTEGER — NOT NULL
  • recorded_at — TIMESTAMP(6) — NOT NULL
  • created_at — TIMESTAMP(6)

safe_zone

  • safe_zone_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id
  • polygon — GEOMETRY(Polygon, 4326) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)

users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • invite_code — VARCHAR(6)
  • partner_id — BIGINT — Foreign key → users.user_id
  • fcm_token — VARCHAR(255)
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)