-
用户表 user
user (email, password, user_name, name, gender, work_school, description, phone, address)
-
登录Token表 token
token (email, token_value, expire)
-
设备表 device
device (device_id, state, longitude, latitude, class, type)
-
设备数据表 device_information
device_information (device_id, message_content, message_time)
-
用户-设备拥有关系表 own
own (email, device_id)
-
设备历史信息表 history
history (device_id, device_state, message, longitude, latitude, timestamp)