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