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