SweetHome

Tables (4)

device_log

  • Key (ack) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → user.Key — NOT NULL
  • Key (device_id) — not null — Foreign key → reg_device.Key — NOT NULL
  • Field (history) — not null
  • Field (time) — not null

reg_device

  • Key (ack) — not null — Primary key — NOT NULL
  • Key (device_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → user.Key — NOT NULL
  • Field (dd) — not null
  • Field (host) — not null
  • Field (mac) — not null

user

  • Key (ack) — not null — Primary key — NOT NULL
  • Key (id) — not null — Primary key — NOT NULL
  • Field (username) — not null
  • Field (password) — not null
  • Field (mail) — not null
  • Field (phone_os) — not null
  • Field (phone_model) — not null

user_log

  • Key (ack) — not null — Primary key — NOT NULL
  • Key (id) — not null — Foreign key → user.Key — NOT NULL
  • Field (history) — not null
  • Field (time) — not null