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)