SSARA
Tables (4)
activity_logs
- id — BIGINT — Primary key — NOT NULL
- robot_id — BIGINT — Foreign key → robot.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- detail — VARCHAR(255)
- created_at — DATETIME — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255)
- serial_number — VARCHAR(255) — NOT NULL
- role — VARCHAR(255)
- created_at — DATETIME — NOT NULL
notification_settings
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- fcm_token — VARCHAR(255)
- push_enabled — BOOLEAN
- robot_status_enabled — BOOLEAN
- battery_enabled — BOOLEAN
- alert_enabled — BOOLEAN
- marketing_enabled — BOOLEAN
robot
- id — BIGINT — Primary key — NOT NULL
- serial_number — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- battery — INT — NOT NULL
- location — VARCHAR(255)
- member_id — BIGINT — Foreign key → member.id
- created_at — DATETIME — NOT NULL