-- ----------------------------
-- 条码表
-- ----------------------------
CREATE TABLE `hazmat_manage`.`sys_sequence`  (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '序列名',
`min_val` int NOT NULL DEFAULT 0 COMMENT '最小值',
`max_val` int NOT NULL DEFAULT 0 COMMENT '最大值',
`current_val` int NOT NULL DEFAULT 0 COMMENT '当前值',
`step` int NOT NULL DEFAULT 1 COMMENT '增长值',
`company_id` bigint NOT NULL COMMENT '企业id',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`,`company_id`) USING BTREE
)  ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '条码表' ROW_FORMAT = Dynamic;


