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 = '服务分类信息表';

CREATE TABLE pet_system.sys_sub_order_appeal
(
    id                     bigint PRIMARY KEY NOT NULL COMMENT '序号',
    order_id               bigint             NOT NULL COMMENT '订单ID',
    service                bigint             NOT NULL COMMENT '实际服务',
    photos                 varchar(255) COMMENT '图片',
    fulfiller              bigint             NOT NULL COMMENT '履约者',
    fulfillment_commission bigint             NOT NULL COMMENT '履约佣金',
    reason                 varchar(512) COMMENT '申诉理由',
    audit_status           tinyint            NOT NULL DEFAULT 0 COMMENT '审核状态',
    reject_reason          varchar(512) COMMENT '驳回理由',
    auditor                bigint COMMENT '审核人',
    audit_time             datetime COMMENT '审核时间',
    del_flag               char(1)                     DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    tenant_id              varchar(20)        NOT NULL 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 = '服务分类信息表';