Table users {
id int [pk]
username varchar
password varchar
email varchar
phone varchar
created_at date
updated_at date
}
Table contacts {
id int [pk]
name varchar
phone varchar
address text
created_at date
updated_at date
}
Table devices {
id int [pk]
device_name varchar
device_type json
serial_number varchar
status json
location text
created_at date
updated_at date
}
Table device_bindings {
id int [pk]
master_device_id int
slave_device_id int
created_at date
updated_at date
}
Ref: device_bindings.master_device_id > devices.id
Ref: device_bindings.slave_device_id > devices.id
Table events {
id int [pk]
event_type varchar
device_id int
event_description text
event_time date
created_at date
updated_at date
}
Ref: events.device_id > devices.id
Table scheduled_tasks {
id int [pk]
task_name varchar
cron_expression varchar
description text
created_at date
updated_at date
}