pet-system/script/sql/business/v2/create.sql

CREATE TABLE `pet_system`.`sys_service_classification`
(
    `id`          bigint PRIMARY KEY NOT NULL COMMENT '序号',
    `name`        varchar(128)       NOT NULL COMMENT '类型名称',
    `sort`        int                NOT NULL DEFAULT 0 COMMENT '排序',
    `remark`      varchar(512) COMMENT '备注',
    `create_dept` bigint(20) COMMENT '创建部门',
    `create_by`   bigint(20) COMMENT '创建者',
    `create_time` datetime COMMENT '创建时间',
    `update_by`   bigint(20) COMMENT '更新者',
    `update_time` datetime COMMENT '更新时间'
) ENGINE = innoDB COMMENT = '服务分类信息表';