| 123456789101112131415 |
- -- auto Generated on 2018-12-21
- -- DROP TABLE IF EXISTS sc_device_date_base;
- CREATE TABLE sc_device_date_base(
- id BIGINT (20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- max VARCHAR (128) DEFAULT '' COMMENT 'max',
- appeui VARCHAR (128) DEFAULT '' COMMENT 'appeui',
- last_upate_time VARCHAR (128) DEFAULT '' COMMENT 'lastUpateTime',
- data VARCHAR (128) DEFAULT '' COMMENT 'data',
- reserver VARCHAR (512) DEFAULT '' COMMENT 'reserver',
- data_type INT (11) DEFAULT -1 COMMENT 'dataType',
- gateways VARCHAR (512) DEFAULT '' COMMENT 'gateways',
- is_analyse INT (11) DEFAULT -1 COMMENT 'isAnalyse',
- date_create TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'dateCreate',
- PRIMARY KEY (id)
- )ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '设备上报数据';
|
