-- ----------------------------
|
-- 条码表
|
-- ----------------------------
|
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;
|
