=== device 表结构 === id | int(10) unsigned | NO company_id | int(10) unsigned | NO unit_id | int(10) unsigned | NO sn | varchar(100) | NO device_code | varchar(64) | NO name | varchar(100) | NO type | varchar(30) | NO model_id | int(10) unsigned | NO protocol | varchar(20) | YES ip | varchar(45) | YES port | int(10) unsigned | YES stream_url | varchar(500) | YES gb_code | varchar(64) | YES lng | decimal(10,7) | YES lat | decimal(10,7) | YES status | tinyint(4) | NO online | tinyint(4) | NO signal_level | tinyint(4) | NO signal_dbm | smallint(6) | YES last_heartbeat | datetime | YES last_data | longtext | YES data_updated_at | datetime | YES remark | varchar(500) | YES created_at | datetime | YES updated_at | datetime | YES === sim_card 表是否存在 === sim_card 表存在: yes === sim_card 表结构 === id | int(10) unsigned device_id | int(10) unsigned iccid | varchar(30) phone | varchar(20) operator | varchar(20) quota_mb | bigint(20) used_mb | bigint(20) expire_date | date last_sync | datetime status | tinyint(4) created_at | datetime