system_common_seal.sql 912 B

123456789101112
  1. DROP TABLE IF EXISTS `system_common_seal`;
  2. CREATE TABLE `system_common_seal` (
  3. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  4. `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  5. `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公章url',
  6. `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '机构id',
  7. `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  8. `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  9. `updater` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
  10. `creator` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  11. PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '公章管理' ROW_FORMAT = Dynamic;