网站关键词优化代码_网页制作与设计自考_销售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)