alzq-onest-monitor/sql/centernonitor_t_gas_tank_devices.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.13
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : 192.168.1.13:63306
 Source Schema         : onest_monitor_yanshi

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 26/09/2024 09:58:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for centernonitor_t_gas_tank_devices
-- ----------------------------
DROP TABLE IF EXISTS `centernonitor_t_gas_tank_devices`;
CREATE TABLE `centernonitor_t_gas_tank_devices`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `deviceid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '设备序列号，全局唯一',
  `devicename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备名称',
  `devicetype` int(11) NULL DEFAULT NULL COMMENT '设备类型',
  `simnum` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'SIM号码',
  `overduetime` bigint(20) NULL DEFAULT NULL COMMENT '过期时间',
  `expirnotifytime` bigint(20) NULL DEFAULT NULL COMMENT '到期通知时间',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `creater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '哪个用户创建的，方便快速查找分组',
  `videochannelcount` int(11) NULL DEFAULT 0 COMMENT '默认摄像头数量',
  `lastactivetime` bigint(20) NULL DEFAULT NULL COMMENT '上一次在线时间',
  `isfree` int(11) NULL DEFAULT NULL COMMENT '是否能正常使用: 1 正常使用, 2 正在体验, 3 已禁用, 4 设备到期, 5 设备过期',
  `allowedit` int(11) NULL DEFAULT 0 COMMENT '0代表不允许二级普通用户编辑, 1代表允许',
  `icon` int(11) NULL DEFAULT 0 COMMENT '默认图标, 0代表小车',
  `stared` int(11) NULL DEFAULT 0 COMMENT '是否关注: 0 代表未关注, 1代表关注',
  `loginname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录名称',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `deviceid`(`deviceid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '煤气罐设备信息表' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;