像素网站制作教程_天地亿家装修公司_免费网站软件app网站_设计公司网站唐山

用户表 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)