cnbg-be/doc/db/2initddl.sql

create table ent_data
(
    商业公司名称       varchar(255) null,
    商业公司地址       varchar(255) null,
    商业公司规模       varchar(255) null,
    三合一社会信用代码 varchar(255) null,
    GSP证书编号        varchar(255) null,
    公司注册地         varchar(255) null,
    注册资本           varchar(255) null,
    法人代表           varchar(255) null,
    服务药企           varchar(255) null,
    公司简介           varchar(255) null,
    经营优势           varchar(255) null,
    备注               varchar(255) null,
    f13                varchar(255) null,
    f14                varchar(255) null
)
    row_format = DYNAMIC;

create table ent_his
(
    医院名称 varchar(255) null,
    医院地址 varchar(255) null,
    医院规模 varchar(255) null,
    医院性质 varchar(255) null,
    联系总机 varchar(255) null,
    公共邮箱 varchar(255) null,
    医院简介 varchar(255) null,
    备注     varchar(255) null
)
    row_format = DYNAMIC;

create table hnqz_sequence
(
    id           bigint auto_increment
        primary key,
    value        bigint      not null,
    name         varchar(32) not null,
    gmt_create   datetime    not null,
    gmt_modified datetime    not null,
    constraint uk_name
        unique (name)
);

create table huiqiyun_input_record
(
    id           int auto_increment comment '主键id'
        primary key,
    req_msg_id   varchar(64)                        null comment '报文流水号',
    req_body     text                               null comment '请求body',
    decrypt_body text                               null comment '解密后的body',
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '汇企云回调异步通知记录';

create table lingcaiai_input_record
(
    id           int auto_increment comment '主键id'
        primary key,
    verify       varchar(128)                        not null comment '签名',
    channel      varchar(32)                         not null comment '通知类型',
    req_body     text                                not null comment '请求body内容',
    batch_no     varchar(32)                         null comment '项目单号',
    account_no   varchar(32)                         null comment '账号单号',
    order_status int                                 null comment '订单状态',
    create_time  timestamp default CURRENT_TIMESTAMP not null comment '创建时间'
)
    comment '浪潮(灵才接好活)结算回调请求记录';

create table medical_equipment
(
    id            int auto_increment comment '医疗器械'
        primary key,
    name          varchar(64)      null comment '器械名称',
    manufacturer  varchar(64)      null comment '生产厂家',
    drug_ent_id   int              null comment '所属企业id',
    drug_ent_name varchar(64)      null comment '所属企业名称',
    specification varchar(64)      null comment '规格',
    measure_unit  varchar(64)      null comment '计量单位组名称',
    level         varchar(20)      null comment '等级',
    remark        varchar(64)      null comment '备注',
    del_flag      char default '0' null comment '删除标记,1:已删除,0:正常',
    create_time   datetime         null comment '创建时间',
    create_user   int              null comment '创建人',
    update_time   datetime         null comment '更新时间',
    update_user   int              null comment '更新人'
)
    comment '医疗器械';

create table monitoring_indicator
(
    id                 int(20) auto_increment
        primary key,
    alarm_amount       decimal(18) default 0 not null comment '报警金额',
    limit_amount       decimal(18) default 0 not null comment '限制金额',
    yaoyi_limit_amount decimal(18)           not null comment '平台限额',
    subject_location   varchar(64)           null comment '税源地'
)
    comment '风险监控' row_format = DYNAMIC;

create table olading_input_record
(
    id             int auto_increment comment '主键id'
        primary key,
    request_id     varchar(32)                         null comment '请求流水号',
    interface_name varchar(32)                         not null comment '请求接口名称',
    req_body       text                                not null comment '请求body内容',
    public_key     varchar(2048)                       null comment '请求公钥',
    private_key    varchar(2048)                       null comment '请求时私钥',
    create_time    timestamp default CURRENT_TIMESTAMP not null comment '创建时间'
)
    comment '自由职家请求记录';

create table party_a_encrypted_input_record
(
    id              int(20) auto_increment
        primary key,
    dept_id         int(20)                             not null comment '主体id',
    ser_public_key  varchar(2048)                       not null comment '请求时服务器公钥',
    ser_private_key varchar(2048)                       not null comment '请求时服务器私钥',
    cli_public_key  varchar(2048)                       not null comment '请求时客户端公钥',
    cli_private_key varchar(2048)                       not null comment '请求时客户端私钥',
    signature       varchar(32)                         not null comment '请求时签名字符串',
    original_text   longtext                            not null comment '加密后的信息',
    password        varchar(2048)                       not null comment '密码',
    create_time     timestamp default CURRENT_TIMESTAMP not null comment '创建时间'
)
    comment '甲方请求加密信息记录' row_format = DYNAMIC;

create table party_b_encrypted_output_record
(
    id              int(20) auto_increment
        primary key,
    dept_id         int(20)                             not null comment '主体id',
    ser_public_key  varchar(2048)                       not null comment '请求时服务器公钥',
    ser_private_key varchar(2048)                       not null comment '请求时服务器私钥',
    cli_public_key  varchar(2048)                       not null comment '请求时客户端公钥',
    cli_private_key varchar(2048)                       not null comment '请求时客户端私钥',
    signature       varchar(32)                         not null comment '请求时签名字符串',
    original_text   longtext                            not null comment '加密后的信息',
    password        varchar(2048)                       not null comment '密码',
    input_id        int(20)                             not null comment '请求id',
    create_time     timestamp default CURRENT_TIMESTAMP not null comment '创建时间'
)
    comment '乙方响应加密信息记录' row_format = DYNAMIC;

create table qifu_input_record
(
    id           int auto_increment comment '主键id'
        primary key,
    req_type     varchar(20)                        not null comment '请求业务类型',
    req_id       varchar(64)                        null comment '请求序号',
    req_body     text                               null comment '请求body',
    decrypt_body text                               null comment '解密后的body',
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '福建企赋回调异步通知记录';

create table qrtz_calendars
(
    sched_name    varchar(120) charset utf8 not null,
    calendar_name varchar(200) charset utf8 not null,
    calendar      blob                      not null,
    primary key (sched_name, calendar_name)
)
    row_format = DYNAMIC;

create table qrtz_fired_triggers
(
    sched_name        varchar(120) charset utf8 not null,
    entry_id          varchar(95) charset utf8  not null,
    trigger_name      varchar(200) charset utf8 not null,
    trigger_group     varchar(200) charset utf8 not null,
    instance_name     varchar(200) charset utf8 not null,
    fired_time        bigint(13)                not null,
    sched_time        bigint(13)                not null,
    priority          int                       not null,
    state             varchar(16) charset utf8  not null,
    job_name          varchar(200) charset utf8 null,
    job_group         varchar(200) charset utf8 null,
    is_nonconcurrent  varchar(1) charset utf8   null,
    requests_recovery varchar(1) charset utf8   null,
    primary key (sched_name, entry_id)
)
    row_format = DYNAMIC;

create table qrtz_job_details
(
    sched_name        varchar(120) charset utf8 not null,
    job_name          varchar(200) charset utf8 not null,
    job_group         varchar(200) charset utf8 not null,
    description       varchar(250) charset utf8 null,
    job_class_name    varchar(250) charset utf8 not null,
    is_durable        varchar(1) charset utf8   not null,
    is_nonconcurrent  varchar(1) charset utf8   not null,
    is_update_data    varchar(1) charset utf8   not null,
    requests_recovery varchar(1) charset utf8   not null,
    job_data          blob                      null,
    primary key (sched_name, job_name, job_group)
)
    row_format = DYNAMIC;

create table qrtz_locks
(
    sched_name varchar(120) charset utf8 not null,
    lock_name  varchar(40) charset utf8  not null,
    primary key (sched_name, lock_name)
)
    row_format = DYNAMIC;

create table qrtz_paused_trigger_grps
(
    sched_name    varchar(120) charset utf8 not null,
    trigger_group varchar(200) charset utf8 not null,
    primary key (sched_name, trigger_group)
)
    row_format = DYNAMIC;

create table qrtz_scheduler_state
(
    sched_name        varchar(120) charset utf8 not null,
    instance_name     varchar(200) charset utf8 not null,
    last_checkin_time bigint(13)                not null,
    checkin_interval  bigint(13)                not null,
    primary key (sched_name, instance_name)
)
    row_format = DYNAMIC;

create table qrtz_triggers
(
    sched_name     varchar(120) charset utf8 not null,
    trigger_name   varchar(200) charset utf8 not null,
    trigger_group  varchar(200) charset utf8 not null,
    job_name       varchar(200) charset utf8 not null,
    job_group      varchar(200) charset utf8 not null,
    description    varchar(250) charset utf8 null,
    next_fire_time bigint(13)                null,
    prev_fire_time bigint(13)                null,
    priority       int                       null,
    trigger_state  varchar(16) charset utf8  not null,
    trigger_type   varchar(8) charset utf8   not null,
    start_time     bigint(13)                not null,
    end_time       bigint(13)                null,
    calendar_name  varchar(200) charset utf8 null,
    misfire_instr  smallint(2)               null,
    job_data       blob                      null,
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_triggers_ibfk_1
        foreign key (sched_name, job_name, job_group) references qrtz_job_details (sched_name, job_name, job_group)
)
    row_format = DYNAMIC;

create table qrtz_blob_triggers
(
    sched_name    varchar(120) charset utf8 not null,
    trigger_name  varchar(200) charset utf8 not null,
    trigger_group varchar(200) charset utf8 not null,
    blob_data     blob                      null,
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_blob_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers (sched_name, trigger_name, trigger_group)
)
    row_format = DYNAMIC;

create table qrtz_cron_triggers
(
    sched_name      varchar(120) charset utf8 not null,
    trigger_name    varchar(200) charset utf8 not null,
    trigger_group   varchar(200) charset utf8 not null,
    cron_expression varchar(200) charset utf8 not null,
    time_zone_id    varchar(80) charset utf8  null,
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_cron_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers (sched_name, trigger_name, trigger_group)
)
    row_format = DYNAMIC;

create table qrtz_simple_triggers
(
    sched_name      varchar(120) charset utf8 not null,
    trigger_name    varchar(200) charset utf8 not null,
    trigger_group   varchar(200) charset utf8 not null,
    repeat_count    bigint(7)                 not null,
    repeat_interval bigint(12)                not null,
    times_triggered bigint(10)                not null,
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_simple_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers (sched_name, trigger_name, trigger_group)
)
    row_format = DYNAMIC;

create table qrtz_simprop_triggers
(
    sched_name    varchar(120) charset utf8 not null,
    trigger_name  varchar(200) charset utf8 not null,
    trigger_group varchar(200) charset utf8 not null,
    str_prop_1    varchar(512) charset utf8 null,
    str_prop_2    varchar(512) charset utf8 null,
    str_prop_3    varchar(512) charset utf8 null,
    int_prop_1    int                       null,
    int_prop_2    int                       null,
    long_prop_1   bigint                    null,
    long_prop_2   bigint                    null,
    dec_prop_1    decimal(13, 4)            null,
    dec_prop_2    decimal(13, 4)            null,
    bool_prop_1   varchar(1) charset utf8   null,
    bool_prop_2   varchar(1) charset utf8   null,
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_simprop_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers (sched_name, trigger_name, trigger_group)
)
    row_format = DYNAMIC;

create index sched_name
    on qrtz_triggers (sched_name, job_name, job_group);

create table re_album_drug
(
    album_id int not null comment '产品相册ID',
    drug_id  int not null comment '药品ID',
    constraint re_album_drug_index
        unique (album_id, drug_id)
)
    row_format = DYNAMIC;

create table re_dept_drug
(
    drug_id int null,
    dept_id int null
)
    charset = utf8
    row_format = DYNAMIC;

create table report_handler_dept_relation
(
    id            int auto_increment comment '主键id'
        primary key,
    report_type   varchar(20)   null comment '报告类型',
    detp_id       int           null comment '企业id',
    handler_class varchar(64)   null comment '处理类',
    create_time   datetime      null comment '创建时间',
    create_user   int           null comment '创建人',
    update_time   datetime      null comment '更新时间',
    update_user   int           null comment '更新人',
    template      varchar(1024) null comment '模板文件名称'
)
    comment '导出报告处理类和企业关系表';

create table single_ent_settle_same_amount_for_members_in_current_month
(
    record_id               int unsigned auto_increment comment 'id'
        primary key,
    note_id                 int unsigned                       null comment '积分包计算记录id',
    realname                varchar(32)                        null comment '用户名称',
    username                varchar(11)                        null comment '用户名',
    id_number               varchar(18)                        null comment '身份证',
    dept_id                 int                                null comment '结算企业id',
    dept_name               varchar(64)                        null comment '结算企业名称',
    settle_amount           decimal(20, 2)                     null comment '结算金额',
    sub_to_gig_time         datetime                           null comment '结算时间',
    settle_state            varchar(16)                        null comment '结算企业名称',
    sub_type_name           varchar(16)                        null comment '结算渠道名称',
    package_name            varchar(64)                        null comment '积分包名称',
    settle_note_create_time datetime                           null comment '结算记录创建时间',
    period int unsigned null comment '统计周期',
    member_count            int unsigned                       null comment '风控人数',
    uuid                    varchar(64)                        not null comment 'uuid',
    create_time             datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '单人连续多月结算相同金额';

create index idx_uuid
    on single_ent_settle_same_amount_for_members_in_current_month (uuid);

create table single_member_settle_amount_overrun_in_several_months
(
    record_id               int unsigned auto_increment comment 'id'
        primary key,
    note_id                 int unsigned                       null comment '积分包计算记录id',
    realname                varchar(32)                        null comment '用户名称',
    username                varchar(11)                        null comment '用户名',
    dept_id                 int                                null comment '结算企业id',
    dept_name               varchar(64)                        null comment '结算企业名称',
    settle_amount           decimal(20, 2)                     null comment '结算金额',
    sub_to_gig_time         datetime                           null comment '结算时间',
    settle_state            varchar(16)                        null comment '结算企业名称',
    sub_type_name           varchar(16)                        null comment '结算渠道名称',
    package_name            varchar(64)                        null comment '积分包名称',
    settle_note_create_time datetime                           null comment '结算记录创建时间',
    period int unsigned null comment '统计周期',
    platform_limit          decimal                            null comment '结算限制',
    uuid                    varchar(64)                        not null comment 'uuid',
    create_time             datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '单人连续多月结算额超标';

create index idx_uuid
    on single_member_settle_amount_overrun_in_several_months (uuid);

create table single_member_settle_same_amount_in_several_months
(
    record_id               int unsigned auto_increment comment 'id'
        primary key,
    note_id                 int unsigned                       null comment '积分包计算记录id',
    realname                varchar(32)                        null comment '用户名称',
    username                varchar(11)                        null comment '用户名',
    id_number               varchar(18)                        null comment '身份证',
    dept_id                 int                                null comment '结算企业id',
    dept_name               varchar(64)                        null comment '结算企业名称',
    settle_amount           decimal(20, 2)                     null comment '结算金额',
    sub_to_gig_time         datetime                           null comment '结算时间',
    settle_state            varchar(16)                        null comment '结算企业名称',
    sub_type_name           varchar(16)                        null comment '结算渠道名称',
    package_name            varchar(64)                        null comment '积分包名称',
    settle_note_create_time datetime                           null comment '结算记录创建时间',
    period int unsigned null comment '统计周期',
    uuid                    varchar(64)                        not null comment 'uuid',
    create_time             datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '单人连续多月结算相同金额';

create index idx_uuid
    on single_member_settle_same_amount_in_several_months (uuid);

create table single_member_without_such_task_types_in_several_months
(
    record_id            int unsigned auto_increment comment 'id'
        primary key,
    user_id              int unsigned                       null comment '用户id',
    package_id           int unsigned                       null comment '积分包id',
    package_name         varchar(32)                        null comment '积分包名称',
    status               varchar(11)                        null comment '积分包状态',
    realname             varchar(32)                        null comment '用户名称',
    username             varchar(11)                        null comment '用户名',
    dept_id              int                                null comment '结算企业id',
    dept_name            varchar(64)                        null comment '结算企业名称',
    period int unsigned null comment '统计周期',
    type_list            varchar(255)                       null comment '风控任务类型',
    package_create_time  datetime                           null comment '积分包创建时间',
    package_pick_up_time datetime                           null comment '积分包领取时间',
    first_task_time      datetime                           null comment '首个任务时间',
    uuid                 varchar(64)                        not null comment 'uuid',
    create_time          datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '单人连续多月结算相同金额';

create index idx_uuid
    on single_member_without_such_task_types_in_several_months (uuid);

create table sys_cert_result_record
(
    id           int(20) auto_increment
        primary key,
    user_id      int(20)                             not null comment '用户id',
    dept_id      int(20)                             not null comment '归属体id',
    subject_type int(1)                              not null comment '归属类型：0-> 人力家，1-> 税邦云',
    method       varchar(25)                         not null comment '请求方法',
    code         varchar(5)                          null comment '状态码',
    status       varchar(5)                          null comment '结果码',
    message      varchar(256)                        not null comment '结果信息',
    create_time  timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '创建时间'
)
    comment '认证结果记录表' row_format = DYNAMIC;

create table sys_csm_user_relation
(
    user_id   int not null comment 'csm用户id',
    parent_id int not null comment '父级用户id',
    primary key (user_id, parent_id)
)
    comment 'csm用户关系表';

create table sys_dept
(
    dept_id                      int(20) auto_increment
        primary key,
    name                         varchar(50)                        not null,
    sort                         int      default 0                 not null comment '排序',
    create_time                  datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time                  datetime                           null on update CURRENT_TIMESTAMP comment '修改时间',
    del_flag                     char     default '0'               null,
    parent_id                    int                                null,
    tenant_id                    int                                null,
    dept_code                    varchar(50)                        null,
    level                        int(2)                             null comment '级别',
    level1_name                  varchar(50)                        null comment '药企名称',
    level1_id                    int                                null comment '药企ID',
    level2_name                  varchar(50)                        null comment '一级代理商名称',
    level2_id                    int                                null comment '一级代理商ID',
    level3_name                  varchar(50)                        null comment '二级代理商名称',
    level3_id                    int                                null comment '二级代理商ID',
    app_id                       varchar(32)                        null,
    app_secret                   varchar(255)                       null,
    rsa_public_key               varchar(256)                       null,
    query_url                    varchar(255)                       null,
    subject_name                 varchar(128)                       null comment '结算主体',
    subject_type                 varchar(1024)                      null,
    tax_code                     varchar(50)                        null comment '税号',
    dept_permissions             varchar(255)                       null comment '部门专用权限限制（字符串逗号分隔:0.导出）',
    gmv1_rate                    int                                null comment 'gmv1收益率（万分之）',
    gmv2_rate                    int                                null comment 'gmv2收益率（万分之）',
    renlijia_service_charge_rate int                                null comment '人力家服务费（万分之）',
    issue_date                   date                               null comment '服务起始时间',
    expiry_date                  date                               null comment '服务截止时间',
    financial_review_type        char(10)                           null comment '财务复核方式',
    emails                       varchar(1024)                      null comment '邮箱(多个逗号分隔)',
    constraint sys_dept_dept_code_uindex
        unique (dept_code)
)
    comment '部门管理' row_format = DYNAMIC;

create table sys_dept_0517
(
    dept_id        int(20) auto_increment
        primary key,
    name           varchar(50)                        not null,
    sort           int      default 0                 not null comment '排序',
    create_time    datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time    datetime                           null on update CURRENT_TIMESTAMP comment '修改时间',
    del_flag       char     default '0'               null,
    parent_id      int                                null,
    tenant_id      int                                null,
    dept_code      varchar(50)                        null,
    level          int(2)                             null comment '级别',
    level1_name    varchar(50)                        null comment '药企名称',
    level1_id      int                                null comment '药企ID',
    level2_name    varchar(50)                        null comment '一级代理商名称',
    level2_id      int                                null comment '一级代理商ID',
    level3_name    varchar(50)                        null comment '二级代理商名称',
    level3_id      int                                null comment '二级代理商ID',
    app_id         varchar(32)                        null,
    app_secret     varchar(255)                       null,
    rsa_public_key varchar(256)                       null,
    query_url      varchar(255)                       null,
    subject_name   varchar(128)                       null comment '结算主体',
    subject_type   varchar(2)                         null comment '认证方式0-人力家 1-税邦云'
)
    comment '部门管理' row_format = DYNAMIC;

create table sys_dept_csm
(
    rec_id       int(20) auto_increment comment 'id'
        primary key,
    dept_id      int(20)                            not null comment '企业id',
    wl_qrcode_id varchar(32)                        not null comment '绑定的智能码 id',
    corp_id      varchar(32)                        not null comment '企业id',
    csm_name     varchar(32)                        not null comment '客户成功姓名',
    user_id      int                                null comment '用户id',
    create_time  datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time  datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '企业csm表';

create index idx_dept_id
    on sys_dept_csm (dept_id);

create table sys_dept_encryptor
(
    id              int(20) auto_increment
        primary key,
    dept_id         int(20)                             not null comment '主体id',
    ser_public_key  varchar(2048)                       not null comment '服务器公钥',
    ser_private_key varchar(2048)                       not null comment '服务器私钥',
    cli_public_key  varchar(2048)                       null comment '客户端公钥',
    cli_private_key varchar(2048)                       null comment '客户端私钥',
    signature       varchar(32)                         not null comment '签名字符串',
    create_time     timestamp default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time     timestamp default CURRENT_TIMESTAMP not null comment '更新时间'
)
    comment '主体加密器' row_format = DYNAMIC;

create table sys_dept_invoice
(
    id                      int auto_increment comment '主键id'
        primary key,
    dept_id                 int                                      null comment '组织机构ID',
    invoice_amount          decimal(10, 2) default 0.00              not null comment '开票金额（元）',
    relation_package_score  int            default 0                 not null comment '关联积分值',
    relation_package_number int            default 0                 not null comment '关联积分包个数',
    approval_status         varchar(10)    default 'PENDING'         not null comment '审核状态',
    approval_time           datetime                                 null comment '审核时间',
    invoice_type            char(10)                                 not null comment '发票类型',
    address                 varchar(64)                              null comment '邮寄地址',
    addressee_name          varchar(32)                              null comment '收件人姓名',
    addressee_phone         varchar(20)                              null comment '收件人手机号',
    del_flag                varchar(10)    default '0'               not null comment '是否删除',
    create_time             datetime       default CURRENT_TIMESTAMP null comment '创建时间',
    create_user             int                                      null comment '创建人',
    update_time             datetime                                 null comment '更新时间',
    update_user             int                                      null comment '更新人'
)
    comment '企业开票表';

create index sys_dept_invoice_dept_id_index
    on sys_dept_invoice (dept_id);

create table sys_dept_invoice_relation
(
    id             int auto_increment comment '主键id'
        primary key,
    invoice_id     int                                   null comment '企业开票表ID',
    dept_id        int                                   not null comment '发包企业id',
    package_id     int                                   not null comment '积分包id',
    invoice_status varchar(10) default 'PENDING'         not null comment '开票状态',
    invoice_time   datetime                              null comment '开票时间',
    del_flag       varchar(10) default '0'               not null comment '是否删除',
    create_time    datetime    default CURRENT_TIMESTAMP null comment '创建/申请时间',
    create_user    int                                   null comment '创建人',
    update_time    datetime                              null comment '更新时间',
    update_user    int                                   null comment '更新人',
    constraint sys_dept_invoice_relation_invoice_id_package_id_uindex
        unique (invoice_id, package_id)
)
    comment '企业开票关联表';

create table sys_dept_recharge
(
    id              int auto_increment comment '主键id'
        primary key,
    dept_id         int                                      null comment '组织机构ID',
    score           int            default 0                 not null comment '积分余额',
    balance         decimal(10, 2) default 0.00              not null comment '余额（元）(已废弃)',
    permissions     varchar(64)                              null comment '权限,多个逗号分隔',
    service_charge  decimal(5, 2)  default 0.00              not null comment '服务费率',
    overdraw_amount decimal(10, 2) default 0.00              not null comment '可透支金额(已废弃)',
    overdraw_score  int            default 0                 not null comment '可透支积分',
    del_flag        varchar(10)    default '0'               not null comment '是否删除',
    create_time     datetime       default CURRENT_TIMESTAMP null comment '创建时间',
    create_user     int                                      null comment '创建人',
    update_time     datetime                                 null comment '更新时间',
    update_user     int                                      null comment '更新人',
    version         int            default 0                 null,
    constraint sys_dept_recharge_dept_id_uindex
        unique (dept_id)
)
    comment '积分充值表';

create table sys_dept_recharge_record
(
    id               int auto_increment comment '主键id'
        primary key,
    recharge_id      int                                      null comment '积分充值表ID',
    dept_id          int                                      null comment '组织机构ID',
    relation_dept_id int                                      null comment '关联组织机构ID（关联操作对象）',
    change_score     int                                      not null comment '充值积分',
    change_amount    decimal(10, 2) default 0.00              not null comment '充值金额（元）(已废弃)',
    type             char(25)                                 not null comment '操作类型',
    current_score    int                                      not null comment '充值后积分余额',
    current_balance  decimal(10, 2) default 0.00              not null comment '充值后积分余额（元）(已废弃)',
    package_id       int                                      null comment '积分包id',
    package_type     varchar(32)                              null comment '积分包类型',
    del_flag         varchar(10)    default '0'               not null comment '是否删除',
    create_time      datetime       default CURRENT_TIMESTAMP null comment '创建时间',
    create_user      int                                      null comment '创建人'
)
    comment '积分充值/使用记录表';

create index sys_dept_recharge_record_dept_id_index
    on sys_dept_recharge_record (dept_id);

create table sys_dept_relation
(
    ancestor   int not null comment '祖先节点',
    descendant int not null comment '后代节点'
)
    comment '部门关系表' row_format = DYNAMIC;

create index idx1
    on sys_dept_relation (ancestor);

create index idx2
    on sys_dept_relation (descendant);

create table sys_dept_sub
(
    sub_id                   int auto_increment
        primary key,
    dept_id                  int(20)                    not null,
    subject_type             varchar(2)    default '0'  not null comment '认证方式0-人力家 1-税邦云',
    subject_channel          int           default 0    not null comment '结算通道',
    subject_location         varchar(64)                null comment '税源地',
    app_id                   varchar(255)  default '0'  null,
    app_secret               varchar(2048)              null,
    rsa_public_key           varchar(2048)              null,
    query_url                varchar(255)               null,
    subject_name             varchar(128)               null comment '结算主体',
    limit_amount             decimal(18, 2)             null,
    enable_flag              varchar(2)    default '0'  null,
    subject_user_type        varchar(2)                 null comment '税邦云用户类型id',
    subject_invoice_category varchar(25)                null comment '税邦云用户类型对应的发票类目',
    path_no                  varchar(128)               null comment '汇企云批次付款渠道编号',
    update_time              datetime                   null comment '更新时间',
    service_charge           decimal(4, 2) default 0.00 not null,
    cert_enable              tinyint       default 1    null comment '认证是否启用：1：启用，0：停用',
    settle_enable            tinyint       default 1    null comment '结算是否启用：1：启用，0：停用',
    eid_enable               tinyint       default 1    null comment 'E证通认证是否启用：1-启用，0-停用'
)
    comment '部门结算主体管理' row_format = DYNAMIC;

create table sys_dict
(
    id          int(64) auto_increment comment '编号'
        primary key,
    type        varchar(100)                       null,
    description varchar(100)                       null,
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null comment '更新时间',
    remarks     varchar(255)                       null,
    `system`    char     default '0'               null,
    del_flag    char     default '0'               null,
    tenant_id   int      default 0                 not null comment '所属租户'
)
    comment '字典表' row_format = DYNAMIC;

create index sys_dict_del_flag
    on sys_dict (del_flag);

create table sys_dict_item
(
    id          int(64) auto_increment comment '编号'
        primary key,
    dict_id     int                                not null,
    value       varchar(100)                       null,
    label       varchar(100)                       null,
    type        varchar(100)                       null,
    description varchar(512)                       null,
    sort        int(10)  default 0                 not null comment '排序（升序）',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
    remarks     varchar(255)                       null,
    del_flag    char     default '0'               null,
    tenant_id   int      default 0                 not null comment '所属租户'
)
    comment '字典项' row_format = DYNAMIC;

create index sys_dict_del_flag
    on sys_dict_item (del_flag);

create index sys_dict_label
    on sys_dict_item (label);

create index sys_dict_value
    on sys_dict_item (value);

create table sys_dict_item_copy
(
    id          int(64) auto_increment comment '编号'
        primary key,
    dict_id     int                                not null,
    value       varchar(100)                       null,
    label       varchar(100)                       null,
    type        varchar(100)                       null,
    description varchar(100)                       null,
    sort        int(10)  default 0                 not null comment '排序（升序）',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
    remarks     varchar(255)                       null,
    del_flag    char     default '0'               null,
    tenant_id   int      default 0                 not null comment '所属租户'
)
    comment '字典项' row_format = DYNAMIC;

create index sys_dict_del_flag
    on sys_dict_item_copy (del_flag);

create index sys_dict_label
    on sys_dict_item_copy (label);

create index sys_dict_value
    on sys_dict_item_copy (value);

create table sys_ent_rel
(
    rel_id      int(20) auto_increment comment 'id'
        primary key,
    ent_id      int(20)                            not null comment '企业id',
    e_type      varchar(8)                         not null comment '租户类型',
    pro_line    varchar(8)                         not null comment '产品线',
    e_level     varchar(8)                         not null comment '租户层级',
    parent_id   int(20)                            not null comment '父级id',
    root_id     int(20)                            not null comment '顶层id',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '企业层级关系表';

create index idx_level
    on sys_ent_rel (e_level);

create index idx_pid
    on sys_ent_rel (parent_id);

create index idx_pro_line
    on sys_ent_rel (pro_line);

create index idx_rid
    on sys_ent_rel (root_id);

create index idx_type
    on sys_ent_rel (e_type);

create table sys_file
(
    id          bigint(32) auto_increment comment '编号'
        primary key,
    file_name   varchar(1500)                      null,
    bucket_name varchar(200)                       null,
    original    varchar(1500)                      null,
    type        varchar(50)                        null,
    file_size   bigint(50)                         null comment '文件大小',
    create_user varchar(32)                        null,
    create_time datetime default CURRENT_TIMESTAMP null comment '上传时间',
    update_user varchar(32)                        null,
    update_time datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '更新时间',
    del_flag    char     default '0'               null,
    tenant_id   int                                null comment '所属租户'
)
    comment '文件管理表' row_format = DYNAMIC;

create table sys_job
(
    job_id              int auto_increment comment '任务id',
    job_name            varchar(64)                            not null comment '任务名称',
    job_group           varchar(64)                            not null comment '任务组名',
    job_order           char         default '1'               null comment '组内执行顺利，值越大执行优先级越高，最大值9，最小值1',
    job_type            char         default '1'               not null comment '1、java类;2、spring bean名称;3、rest调用;4、jar调用;9其他',
    execute_path        varchar(500)                           null comment 'job_type=3时，rest调用地址，仅支持rest get协议,需要增加String返回值，0成功，1失败;job_type=4时，jar路径;其它值为空',
    class_name          varchar(500)                           null comment 'job_type=1时，类完整路径;job_type=2时，spring bean名称;其它值为空',
    method_name         varchar(500)                           null comment '任务方法',
    method_params_value varchar(2000)                          null comment '参数值',
    cron_expression     varchar(255)                           null comment 'cron执行表达式',
    misfire_policy      varchar(20)  default '3'               null comment '错失执行策略（1错失周期立即执行 2错失周期执行一次 3下周期执行）',
    job_tenant_type     char         default '1'               null comment '1、多租户任务;2、非多租户任务',
    job_status          char         default '0'               null comment '状态（1、未发布;2、运行中;3、暂停;4、删除;）',
    job_execute_status  char         default '0'               null comment '状态（0正常 1异常）',
    create_by           varchar(64)                            null comment '创建者',
    create_time         datetime     default CURRENT_TIMESTAMP not null comment '创建时间',
    update_by           varchar(64)  default ''                null comment '更新者',
    update_time         datetime     default CURRENT_TIMESTAMP not null comment '更新时间',
    start_time          timestamp                              null comment '初次执行时间',
    previous_time       timestamp                              null comment '上次执行时间',
    next_time           timestamp                              null comment '下次执行时间',
    tenant_id           int          default 1                 null comment '租户',
    remark              varchar(500) default ''                null comment '备注信息',
    primary key (job_id, job_name, job_group)
)
    comment '定时任务调度表' row_format = DYNAMIC;

create table sys_job_log
(
    job_log_id          int auto_increment comment '任务日志ID'
        primary key,
    job_id              int                                                  not null comment '任务id',
    job_name            varchar(64) charset utf8                             null comment '任务名称',
    job_group           varchar(64) charset utf8                             null comment '任务组名',
    job_order           char charset utf8                                    null comment '组内执行顺利，值越大执行优先级越高，最大值9，最小值1',
    job_type            char charset utf8          default '1'               not null comment '1、java类;2、spring bean名称;3、rest调用;4、jar调用;9其他',
    execute_path        varchar(500) charset utf8                            null comment 'job_type=3时，rest调用地址，仅支持post协议;job_type=4时，jar路径;其它值为空',
    class_name          varchar(500) charset utf8                            null comment 'job_type=1时，类完整路径;job_type=2时，spring bean名称;其它值为空',
    method_name         varchar(500) charset utf8                            null comment '任务方法',
    method_params_value varchar(2000) charset utf8                           null comment '参数值',
    cron_expression     varchar(255) charset utf8                            null comment 'cron执行表达式',
    job_message         varchar(500) charset utf8                            null comment '日志信息',
    job_log_status      char charset utf8          default '0'               null comment '执行状态（0正常 1失败）',
    execute_time        varchar(30) charset utf8                             null comment '执行时间',
    exception_info      varchar(2000) charset utf8 default ''                null comment '异常信息',
    create_time         datetime                   default CURRENT_TIMESTAMP not null comment '创建时间',
    tenant_id           int                        default 1                 not null comment '租户id',
    uuid                varchar(64)                                          null comment 'uuid'
)
    comment '定时任务执行日志表' row_format = DYNAMIC;

create table sys_log
(
    id          bigint(64) auto_increment comment '编号'
        primary key,
    type        char     default '0'               null,
    title       varchar(255)                       null,
    service_id  varchar(32)                        null,
    create_by   varchar(255)                       null,
    create_time datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time datetime                           null on update CURRENT_TIMESTAMP comment '更新时间',
    remote_addr varchar(255)                       null,
    user_agent  varchar(1000)                      null,
    request_uri varchar(255)                       null,
    method      varchar(10)                        null,
    params      text                               null,
    resp        text                               null comment '响应信息',
    time        mediumtext charset utf8            null comment '执行时间',
    del_flag    char     default '0'               null,
    exception   text                               null,
    tenant_id   int      default 0                 null comment '所属租户'
)
    comment '日志表' row_format = DYNAMIC;

create index sys_log_create_by
    on sys_log (create_by(191));

create index sys_log_create_date
    on sys_log (create_time);

create index sys_log_request_uri
    on sys_log (request_uri(191));

create index sys_log_type
    on sys_log (type);

create table sys_menu
(
    menu_id     int auto_increment comment '菜单ID'
        primary key,
    name        varchar(32)                        null,
    permission  varchar(32)                        null,
    path        varchar(128)                       null,
    parent_id   int                                null comment '父菜单ID',
    icon        varchar(32)                        null,
    sort        int      default 1                 null comment '排序值',
    keep_alive  char     default '0'               null,
    type        char     default '0'               null,
    create_time datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time datetime                           null comment '更新时间',
    del_flag    char     default '0'               null,
    tenant_id   int(11) unsigned                   null comment '租户ID'
)
    comment '菜单权限表' row_format = DYNAMIC;

create table sys_oauth_client_details
(
    id                      int auto_increment comment 'ID'
        primary key,
    client_id               varchar(32)      not null,
    resource_ids            varchar(256)     null,
    client_secret           varchar(256)     null,
    scope                   varchar(256)     null,
    authorized_grant_types  varchar(256)     null,
    web_server_redirect_uri varchar(256)     null,
    authorities             varchar(256)     null,
    access_token_validity   int              null,
    refresh_token_validity  int              null,
    additional_information  varchar(4096)    null,
    autoapprove             varchar(256)     null,
    del_flag                char default '0' null,
    tenant_id               int  default 0   not null comment '所属租户'
)
    comment '终端信息表' row_format = DYNAMIC;

create table sys_plat
(
    id        int          not null
        primary key,
    phone     varchar(255) null comment '手机号',
    idcard    varchar(255) null comment '身份证号',
    temp1     varchar(255) null comment '备用字段1',
    temp2     varchar(255) null comment '备用字段2',
    temp3     varchar(255) null comment '备用字段3',
    temp4     varchar(255) null comment '备用字段4',
    备用字段5 varchar(255) null comment '备用字段5'
)
    comment '平台用户信息' row_format = DYNAMIC;

create table sys_portal_conf
(
    conf_id       bigint auto_increment comment '主键'
        primary key,
    spec_path     varchar(32)                        not null comment '专属路径',
    portal_logo   varchar(255)                       not null comment 'logo',
    portal_icon   varchar(255)                       not null comment 'icon',
    portal_title  varchar(32)                        not null comment 'title',
    portal_name   varchar(16)                        not null comment '名称',
    bg_img        varchar(255)                       null comment '背景图',
    theme_color   json                               null comment '主题色',
    icp_no        varchar(128)                       not null comment 'icp备案',
    pc_no         varchar(128)                       not null comment 'pc备案号',
    created_by    varchar(64)                        not null comment '创建人',
    modified_by   varchar(64)                        not null comment '修改人',
    created_time  datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    modified_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '门户配置信息' collate = utf8_bin;

create index sys_portal_conf_spec_path_index
    on sys_portal_conf (spec_path);

create table sys_public_param
(
    public_id     bigint auto_increment comment '编号'
        primary key,
    public_name   varchar(128)                       null comment '名称',
    public_key    varchar(128)                       null comment '键',
    public_value  varchar(128)                       null comment '值',
    status        char     default '0'               null comment '状态（0：正常，9：冻结）',
    validate_code varchar(64)                        null,
    create_time   datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time   datetime                           null on update CURRENT_TIMESTAMP comment '修改时间',
    public_type   char     default '0'               null,
    `system`      char     default '0'               null,
    del_flag      char     default '0'               null,
    tenant_id     int                                null comment '租户ID'
)
    comment '公共参数配置表' row_format = DYNAMIC;

create table sys_role
(
    role_id     int auto_increment
        primary key,
    role_name   varchar(64)                        null,
    role_code   varchar(64)                        null,
    role_desc   varchar(255)                       null,
    ds_type     char     default '2'               null,
    ds_scope    varchar(255)                       null,
    create_time datetime default CURRENT_TIMESTAMP not null,
    update_time datetime                           null,
    del_flag    char     default '0'               null,
    tenant_id   int                                null
)
    comment '系统角色表' row_format = DYNAMIC;

create index role_idx1_role_code
    on sys_role (role_code);

create table sys_role_menu
(
    role_id int not null comment '角色ID',
    menu_id int not null comment '菜单ID',
    primary key (role_id, menu_id)
)
    comment '角色菜单表' row_format = DYNAMIC;

create table sys_route_conf
(
    id          int auto_increment comment '主键'
        primary key,
    route_name  varchar(30)                        null,
    route_id    varchar(30)                        null,
    predicates  json                               null comment '断言',
    filters     json                               null comment '过滤器',
    uri         varchar(50)                        null,
    `order`     int(2)   default 0                 null comment '排序',
    create_time datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time datetime                           null on update CURRENT_TIMESTAMP comment '修改时间',
    del_flag    char     default '0'               null
)
    comment '路由配置表' row_format = DYNAMIC;

create table sys_social_details
(
    id           int auto_increment comment '主鍵'
        primary key,
    type         varchar(16)                        null,
    remark       varchar(64)                        null,
    app_id       varchar(64)                        null,
    app_secret   varchar(64)                        null,
    random_key   varchar(16)                        null comment '随机key（16位）',
    redirect_url varchar(128)                       null,
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time  datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '更新时间',
    del_flag     char     default '0'               null,
    tenant_id    int      default 0                 not null comment '所属租户'
)
    comment '系统社交登录账号表' row_format = DYNAMIC;

create table sys_social_details_copy
(
    id           int auto_increment comment '主鍵'
        primary key,
    type         varchar(16)                        null,
    remark       varchar(64)                        null,
    app_id       varchar(64)                        null,
    app_secret   varchar(64)                        null,
    redirect_url varchar(128)                       null,
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time  datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '更新时间',
    del_flag     char     default '0'               null,
    tenant_id    int      default 0                 not null comment '所属租户'
)
    comment '系统社交登录账号表' row_format = DYNAMIC;

create table sys_social_details_copy1
(
    id           int auto_increment comment '主鍵'
        primary key,
    type         varchar(16)                        null,
    remark       varchar(64)                        null,
    app_id       varchar(64)                        null,
    app_secret   varchar(64)                        null,
    random_key   varchar(16)                        null comment '随机key（16位）',
    redirect_url varchar(128)                       null,
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time  datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '更新时间',
    del_flag     char     default '0'               null,
    tenant_id    int      default 0                 not null comment '所属租户'
)
    comment '系统社交登录账号表' row_format = DYNAMIC;

create table sys_tenant
(
    id          int auto_increment comment '租户id'
        primary key,
    name        varchar(255)                       null,
    code        varchar(64)                        null,
    start_time  datetime                           null comment '开始时间',
    end_time    datetime                           null comment '结束时间',
    status      char     default '0'               null,
    del_flag    char     default '0'               null,
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间'
)
    comment '租户表' row_format = DYNAMIC;

create table sys_user
(
    user_id                        int auto_increment comment '主键ID'
        primary key,
    username                       varchar(64)                          null,
    password                       varchar(255)                         null,
    salt                           varchar(255)                         null,
    phone                          varchar(20)                          null,
    avatar                         varchar(1024)                        null,
    dept_id                        int                                  null comment '部门ID',
    create_time                    datetime   default CURRENT_TIMESTAMP null comment '创建时间',
    update_time                    datetime                             null on update CURRENT_TIMESTAMP comment '修改时间',
    lock_flag                      char       default '0'               null,
    del_flag                       char       default '0'               null,
    wx_openid                      varchar(32)                          null comment '微信登录openId',
    mini_openid                    varchar(32)                          null comment '小程序openId',
    qq_openid                      varchar(32)                          null comment 'QQ openId',
    gitee_login                    varchar(100)                         null comment '码云 标识',
    osc_id                         varchar(100)                         null comment '开源中国 标识',
    tenant_id                      int        default 0                 not null comment '所属租户',
    realname                       varchar(30)                          null comment '用户姓名',
    province                       varchar(20)                          null comment '省',
    city                           varchar(20)                          null comment '市',
    area                           varchar(20)                          null comment '区',
    address                        varchar(255)                         null comment '地址',
    temp1                          varchar(255)                         null comment '备用字段1',
    temp2                          varchar(2000)                        null comment '备用字段2',
    temp3                          varchar(255)                         null comment '备用字段3',
    temp4                          varchar(255)                         null comment '备用字段4',
    temp5                          varchar(255)                         null comment '备用字段5',
    plat_id                        varchar(50)                          null comment '平台ID',
    drug_ent_id                    varchar(11)                          null comment '药企ID',
    w1                             varchar(255)                         null,
    id_card_number                 varchar(32)                          null comment '身份证',
    user_sign                      varchar(255)                         null comment '签名',
    cert_status                    int(2)                               null comment '认证状态',
    cert_remark                    varchar(255)                         null comment '认证结果描述',
    province_code                  varchar(11)                          null comment '省份编码',
    city_code                      varchar(11)                          null comment '城市编码',
    user_type                      varchar(2) default '0'               null comment '认证方式0-人力家 1-税邦云',
    bank_card_number               varchar(19)                          null comment '银行卡号',
    rlj_cert_status                int(2)                               null comment '人力家认证状态',
    tax_helper_agreement_signature int(1)     default 0                 null comment '税邦云协议签署记录 0 未签署 1 已签署',
    bank_phone                     varchar(11)                          null comment '银行预留手机号',
    bank_name                      varchar(32)                          null comment '开户行',
    sign_agreement                 varchar(1024)                        null comment '小程序签署协议信息',
    age_reminder                   tinyint    default 1                 null comment '年龄超60周岁提醒',
    re_signed_agreement            int        default 1                 null comment '是否已补签协议',
    gender                         char(5)                              null comment '性别，1男，2女',
    degree                         char(2)                              null comment '学历',
    qualification_record_number    varchar(64)                          null comment '医药代表资质备案号',
    qualifications_url             varchar(256)                         null comment '资质证书url'
)
    comment '用户表' row_format = DYNAMIC;

create index user_idx1_username
    on sys_user (username);

create index user_qq_openid
    on sys_user (qq_openid);

create index user_wx_openid
    on sys_user (wx_openid);

create table sys_user_0226
(
    user_id        int auto_increment comment '主键ID'
        primary key,
    username       varchar(64)                        null,
    password       varchar(255)                       null,
    salt           varchar(255)                       null,
    phone          varchar(20)                        null,
    avatar         varchar(255)                       null,
    dept_id        int                                null comment '部门ID',
    create_time    datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time    datetime                           null on update CURRENT_TIMESTAMP comment '修改时间',
    lock_flag      char     default '0'               null,
    del_flag       char     default '0'               null,
    wx_openid      varchar(32)                        null comment '微信登录openId',
    mini_openid    varchar(32)                        null comment '小程序openId',
    qq_openid      varchar(32)                        null comment 'QQ openId',
    gitee_login    varchar(100)                       null comment '码云 标识',
    osc_id         varchar(100)                       null comment '开源中国 标识',
    tenant_id      int      default 0                 not null comment '所属租户',
    realname       varchar(30)                        null comment '用户姓名',
    province       varchar(20)                        null comment '省',
    city           varchar(20)                        null comment '市',
    area           varchar(20)                        null comment '区',
    address        varchar(255)                       null comment '地址',
    temp1          varchar(255)                       null comment '备用字段1',
    temp2          varchar(2000)                      null comment '备用字段2',
    temp3          varchar(255)                       null comment '备用字段3',
    temp4          varchar(255)                       null comment '备用字段4',
    temp5          varchar(255)                       null comment '备用字段5',
    plat_id        varchar(50)                        null comment '平台ID',
    drug_ent_id    varchar(11)                        null comment '药企ID',
    w1             varchar(255)                       null,
    id_card_number varchar(32)                        null comment '身份证',
    user_sign      varchar(255)                       null comment '签名',
    cert_status    int(2)                             null comment '认证状态',
    cert_remark    varchar(255)                       null comment '认证结果描述',
    province_code  varchar(11)                        null comment '省份编码',
    city_code      varchar(11)                        null comment '城市编码'
)
    comment '用户表' row_format = DYNAMIC;

create index user_idx1_username
    on sys_user_0226 (username);

create index user_qq_openid
    on sys_user_0226 (qq_openid);

create index user_wx_openid
    on sys_user_0226 (wx_openid);

create table sys_user_0517
(
    user_id          int auto_increment comment '主键ID'
        primary key,
    username         varchar(64)                          null,
    password         varchar(255)                         null,
    salt             varchar(255)                         null,
    phone            varchar(20)                          null,
    avatar           varchar(255)                         null,
    dept_id          int                                  null comment '部门ID',
    create_time      datetime   default CURRENT_TIMESTAMP null comment '创建时间',
    update_time      datetime                             null on update CURRENT_TIMESTAMP comment '修改时间',
    lock_flag        char       default '0'               null,
    del_flag         char       default '0'               null,
    wx_openid        varchar(32)                          null comment '微信登录openId',
    mini_openid      varchar(32)                          null comment '小程序openId',
    qq_openid        varchar(32)                          null comment 'QQ openId',
    gitee_login      varchar(100)                         null comment '码云 标识',
    osc_id           varchar(100)                         null comment '开源中国 标识',
    tenant_id        int        default 0                 not null comment '所属租户',
    realname         varchar(30)                          null comment '用户姓名',
    province         varchar(20)                          null comment '省',
    city             varchar(20)                          null comment '市',
    area             varchar(20)                          null comment '区',
    address          varchar(255)                         null comment '地址',
    temp1            varchar(255)                         null comment '备用字段1',
    temp2            varchar(2000)                        null comment '备用字段2',
    temp3            varchar(255)                         null comment '备用字段3',
    temp4            varchar(255)                         null comment '备用字段4',
    temp5            varchar(255)                         null comment '备用字段5',
    plat_id          varchar(50)                          null comment '平台ID',
    drug_ent_id      varchar(11)                          null comment '药企ID',
    w1               varchar(255)                         null,
    id_card_number   varchar(32)                          null comment '身份证',
    user_sign        varchar(255)                         null comment '签名',
    cert_status      int(2)                               null comment '认证状态',
    cert_remark      varchar(255)                         null comment '认证结果描述',
    province_code    varchar(11)                          null comment '省份编码',
    city_code        varchar(11)                          null comment '城市编码',
    user_type        varchar(2) default '0'               null comment '认证方式0-人力家 1-税邦云',
    bank_card_number varchar(19)                          null comment '银行卡号'
)
    comment '用户表' row_format = DYNAMIC;

create index user_idx1_username
    on sys_user_0517 (username);

create index user_qq_openid
    on sys_user_0517 (qq_openid);

create index user_wx_openid
    on sys_user_0517 (wx_openid);

create table sys_user_ext_record
(
    id                   int auto_increment comment '主键id'
        primary key,
    user_id              int              not null comment '用户id',
    dept_id              int              not null comment '部门id',
    real_name            varchar(30)      null comment '用户姓名',
    phone                varchar(20)      null comment '手机号',
    id_card_number       varchar(32)      null comment '身份证号',
    bank_card_number     varchar(19)      null comment '银行卡号',
    bank_phone           varchar(11)      null comment '银行预留手机号',
    id_card_front_url    varchar(255)     null comment '身份证照片-正面',
    id_card_back_url     varchar(255)     null comment '身份证照片-反面',
    id_card_front_base64 longtext         null comment '身份证照片-正面base64',
    id_card_back_base64  longtext         null comment '身份证照片-反面base64',
    best_frame_url       varchar(255)     null comment '最佳帧照片url',
    best_frame_base64    longtext         null comment '最佳帧照片base64',
    etoken               varchar(40)      null comment 'etoken',
    remark               varchar(255)     null comment '备注',
    del_flag             char default '0' null comment '删除标记',
    create_time          datetime         null comment '创建时间',
    create_user          int              null comment '创建人',
    update_time          datetime         null comment '更新时间',
    update_user          int              null comment '更新人'
)
    comment '用户认证相关的扩展信息';

create index sys_user_ext_record_user_id_index
    on sys_user_ext_record (user_id);

create table sys_user_record
(
    id          int auto_increment comment '主键id'
        primary key,
    user_id     varchar(64)                        null comment '用户id',
    type        varchar(64)                        null comment '记录类型',
    msg         varchar(1024)                      null comment '记录信息',
    del_flag    char(64) default '0'               not null comment '删除标记位',
    create_user varchar(64)                        null comment '创建人',
    create_time datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_user varchar(64)                        null comment '更新人',
    update_time datetime                           null on update CURRENT_TIMESTAMP comment '更新时间时间'
)
    comment '用户回访记录表';

create table sys_user_role
(
    user_id int not null comment '用户ID',
    role_id int not null comment '角色ID',
    primary key (user_id, role_id)
)
    comment '用户角色表' row_format = DYNAMIC;

create table sys_user_sub
(
    id                int auto_increment comment '主键ID'
        primary key,
    user_id           int              not null comment '用户ID',
    dept_id           int              null comment '部门id',
    gig_type          int(2)           not null comment '零工平台类型（订单支付方式类型:0-人力家 1-税邦云 2-自由职家 3-易联数科）',
    gig_channel       int    default 0 null comment '渠道',
    subject_location  varchar(64)      null comment '税源地',
    callback_status   int(1) default 0 null comment '回调状态',
    cert_status       int    default 0 not null comment '认证状态',
    cert_remark       longtext         null comment '认证结果描述',
    fail_reason       varchar(255)     null comment '认证失败原因',
    user_type         varchar(2)       null comment '人员类型',
    bank_card_number  varchar(19)      null comment '银行卡号',
    bank_phone        varchar(11)      null comment '银行预留手机号',
    bank_name         varchar(64)      null comment '开户行',
    id_card_front_url varchar(255)     null comment '身份证照片-正面',
    id_card_back_url  varchar(255)     null comment '身份证照片-反面',
    cert_video1_url   varchar(255)     null comment '认证视频1',
    cert_video2_url   varchar(255)     null comment '认证视频1',
    agreement_url     varchar(255)     null comment '协议',
    request_id        varchar(255)     null comment '请求流水号',
    create_time       datetime         null comment '创建时间',
    create_user       int              null comment '创建人',
    update_time       datetime         null comment '更新时间',
    update_user       int              null comment '更新人',
    callback_time     datetime         null comment '回调时间'
)
    comment '用户签约认证主体信息表';

create table sys_wx_reply_message
(
    id          int auto_increment comment '主鍵'
        primary key,
    keyword     varchar(255)                         not null comment '关键字',
    type        tinyint(1)                           not null comment '消息类型（0：文字，1：图片，2：视频，3：图文消息）',
    create_time datetime   default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime                             not null comment '更新时间',
    enable_flag tinyint(1) default 0                 not null comment '是否生效（0：未生效，1：生效）'
)
    comment '微信自动回复消息表' row_format = DYNAMIC;

create table sys_wx_reply_message_media
(
    id           int auto_increment comment '主键'
        primary key,
    media_type   tinyint(1)                         not null comment '素材类型（1：文字，2：图片，3：视频）',
    title        varchar(255)                       null comment '视频的标题',
    introduction varchar(255)                       null comment '视频的描述',
    content      varchar(1024)                      null comment '内容',
    name         varchar(255)                       null comment '文件名称',
    url          varchar(512)                       null comment 'url地址',
    wx_media_id  varchar(128)                       null comment '微信素材id',
    sort         int(2)                             not null comment '排序',
    create_time  datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time  datetime                           not null comment '更新时间'
)
    comment '微信自动回复消息素材表' row_format = DYNAMIC;

create table sys_wx_reply_message_relation
(
    id               int auto_increment
        primary key,
    message_id       int not null comment '微信消息id',
    message_media_id int not null comment '微信消息素材id'
)
    comment '微信消息和素材关联表' row_format = DYNAMIC;

create table upms_sequence
(
    id           bigint auto_increment
        primary key,
    value        bigint      not null,
    name         varchar(32) not null,
    gmt_create   datetime    not null,
    gmt_modified datetime    not null,
    constraint uk_name
        unique (name)
);

create table user_agreement_signature_record
(
    id          int auto_increment comment 'id'
        primary key,
    user_id     int                                not null comment '用户id',
    target      int(1)                             not null comment '协议方',
    agreement   mediumtext                         null comment '协议文本',
    sign_time   datetime                           not null comment '签署时间',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    sign_img    longtext                           null comment '手签图片'
)
    comment '用户协议签名';

create table wm_ad_record
(
    record_id    bigint unsigned auto_increment comment 'id'
        primary key,
    user_id      int                                not null comment '用户id',
    ad_url       varchar(255)                       not null comment '跳转地址',
    created_time datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '部门管理';

create table wm_af_customer
(
    id               int auto_increment comment '主键id'
        primary key,
    dept_id          int                          null comment '部门id',
    customer_number  varchar(20) charset utf8mb4  not null comment '客户id',
    customer_name    varchar(50) charset utf8mb4  not null comment '客户名称',
    customer_type    varchar(20)                  not null comment '客户类别(0-药企、1-CSO、2-CRO、3-其他)',
    customer_manager varchar(50) charset utf8mb4  not null comment '客户经理',
    channel_name     varchar(50) charset utf8mb4  null comment '渠道名称',
    sign_date        datetime                     null comment '签订日期',
    expiration_date  datetime                     null comment '有效期截止',
    customer_status  varchar(20)                  null comment '客户状态:(0-客户备案、1-合同立项、2-签约 、3-上线)',
    remark           varchar(128) charset utf8mb4 null comment '说明',
    contract_file    varchar(512) charset utf8mb4 null comment '合同附件',
    contract_name    varchar(50) charset utf8mb4  null comment '合同名称',
    create_time      datetime                     null comment '创建时间',
    create_user      int                          null comment '创建人',
    update_time      datetime                     null comment '更新时间',
    update_user      int                          null comment '更新人'
)
    comment '档案-客户管理' charset = utf8
                            row_format = DYNAMIC;

create table wm_contract
(
    id              bigint(11) auto_increment comment '编号'
        primary key,
    customer_id     int                          null comment '客户主键id',
    tenant_id       int                          null comment '租户id',
    serial_no       varchar(255)                 null comment '合同编号',
    title           varchar(255) charset utf8    null comment '合同名称',
    party_a         varchar(255) charset utf8    null comment '签约甲方',
    party_b         varchar(255) charset utf8    null comment '签约乙方',
    sign_time       datetime                     null comment '签约时间',
    expiration_time datetime                     null comment '有效截止时间',
    filing_time     datetime                     null comment '归档时间',
    state           varchar(255) charset utf8    null comment '说明',
    pic_url         varchar(255) charset utf8mb4 null comment '合同图片地址',
    mgr             varchar(50) charset utf8mb4  null comment '客户经理名称',
    remark          varchar(255) charset utf8    null comment '备注',
    create_user     int                          null comment '创建人',
    create_time     datetime                     null comment '创建时间',
    update_user     int                          null comment '修改人',
    update_time     datetime                     null comment '修改时间'
)
    comment '档案-合同管理' charset = latin1
                            row_format = DYNAMIC;

create table wm_contract0609
(
    id              bigint(11) auto_increment comment '编号'
        primary key,
    contract_number varchar(255)                 null comment '合同编号',
    contract_name   varchar(255) charset utf8    null comment '合同名称',
    sign_jia        varchar(255) charset utf8    null comment '签约甲方',
    sign_yi         varchar(255) charset utf8    null comment '签约乙方',
    sign_time       datetime                     null comment '签约时间',
    filing_time     datetime                     null comment '归档时间',
    state           varchar(255) charset utf8    null comment '说明',
    annex_contract  varchar(500) charset utf8mb4 null comment '合同附件',
    remark          varchar(255) charset utf8    null comment '备注',
    create_time     datetime                     null comment '创建时间',
    update_user     varchar(128) charset utf8    null comment '修改人',
    update_time     datetime                     null comment '修改时间',
    dept_id         varchar(11) charset utf8mb4  null comment '组织机构ID'
)
    comment '档案-合同管理' charset = latin1
                            row_format = DYNAMIC;

create table wm_da_agent
(
    id                 int auto_increment
        primary key,
    gsmc               varchar(50)                        not null comment '公司名称',
    yyzz               varchar(5000)                      null comment '营业执照',
    sbjnzm             varchar(5000)                      null comment '社保缴纳证明',
    frsfzzm_zm         varchar(500)                       null comment '法人身份证证明-正面',
    frsfzzm_bm         varchar(500)                       null comment '法人身份证证明-背面',
    frsfzzm_sc         varchar(500)                       null comment '法人身份证证明-手持',
    is_examine         char                               null comment '是否审核',
    zj_type            varchar(20)                        null comment '证件类型',
    zj_number          varchar(50)                        null comment '证件号码',
    ext_drug_ent       varchar(255)                       null comment '扩展可选药企',
    dept_id            varchar(11)                        null comment '组织机构ID',
    del_flag           char     default '0'               not null comment '是否删除',
    enable_flag        char     default '0'               not null comment '是否禁用',
    tenant_id          int      default 1                 not null comment '所属租户',
    create_time        datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user        int                                null comment '创建人',
    update_time        datetime                           null comment '更新时间',
    update_user        varchar(200)                       null comment '更新人',
    drug_ent_id        varchar(20)                        null comment '所属药企',
    temp1              varchar(255)                       null,
    temp2              varchar(255)                       null,
    js_account         varchar(32)                        null comment '结算账号 ',
    management         varchar(2)                         null comment '管理模式',
    pgqx               varchar(11)                        null comment '派工权限',
    qylx               varchar(11)                        null comment '企业类型',
    subject_type       varchar(1024)                      null,
    agent_type         char(2)                            not null,
    mah_settle_dept_id int                                null comment 'MAH结算-药企deptId'
)
    comment '档案-代理商' row_format = DYNAMIC;

create table wm_da_agent_0517
(
    id           int auto_increment
        primary key,
    gsmc         varchar(50)                        not null comment '公司名称',
    yyzz         varchar(500)                       null comment '营业执照',
    sbjnzm       varchar(500)                       null comment '社保缴纳证明',
    frsfzzm_zm   varchar(500)                       null comment '法人身份证证明-正面',
    frsfzzm_bm   varchar(500)                       null comment '法人身份证证明-背面',
    frsfzzm_sc   varchar(500)                       null comment '法人身份证证明-手持',
    is_examine   char                               null comment '是否审核',
    zj_type      varchar(20)                        null comment '证件类型',
    zj_number    varchar(50)                        null comment '证件号码',
    ext_drug_ent varchar(255)                       null comment '扩展可选药企',
    dept_id      varchar(11)                        null comment '组织机构ID',
    del_flag     char     default '0'               not null comment '是否删除',
    enable_flag  char     default '0'               not null comment '是否禁用',
    tenant_id    int      default 1                 not null comment '所属租户',
    create_time  datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user  int                                null comment '创建人',
    update_time  datetime                           null comment '更新时间',
    update_user  varchar(200)                       null comment '更新人',
    drug_ent_id  varchar(20)                        null comment '所属药企',
    temp1        varchar(255)                       null,
    temp2        varchar(255)                       null,
    js_account   varchar(32)                        null comment '结算账号 ',
    management   varchar(2)                         null comment '管理模式',
    pgqx         varchar(11)                        null comment '派工权限',
    qylx         varchar(11)                        null comment '企业类型',
    subject_type varchar(50)                        null
)
    comment '档案-代理商' row_format = DYNAMIC;

create table wm_da_dis_excel
(
    商业公司名称       varchar(255) null,
    商业公司地址       varchar(255) null,
    f3                 varchar(255) null,
    三合一社会信用代码 varchar(255) null,
    GSP证书编号        varchar(255) null,
    公司注册地         varchar(255) null,
    注册资本           varchar(255) null,
    法人代表           varchar(255) null
)
    row_format = DYNAMIC;

create table wm_da_distribution
(
    id                          int auto_increment
        primary key,
    gsmc                        varchar(50)            not null comment '商业公司名称',
    province                    longtext               null comment '省',
    city                        longtext               null comment '市',
    area                        longtext               null comment '区',
    address                     varchar(255)           not null comment '地址',
    longitude                   varchar(255)           null comment '经度',
    latitude                    varchar(255)           null comment '纬度',
    gsgm                        varchar(50)            null comment '公司规模',
    shyshxydm                   varchar(20)            not null comment '三合一社会信用代码',
    gszcd                       varchar(255)           not null comment '公司注册地',
    zczb                        varchar(20)            null comment '注册资本',
    gspzsbh                     varchar(20)            null comment 'GSP证书编号',
    frdb                        varchar(20)            not null comment '法人代表',
    zjl                         varchar(20)            null comment '总经理',
    cjbmfzrxm                   varchar(20)            null comment '采购部门负责人姓名',
    cjbmfzrlxfs                 varchar(20)            null comment '采购部门负责人联系方式',
    cgbmdjrxm                   varchar(20)            null comment '采购部门对接人姓名',
    cgbmdjrlxfs                 varchar(20)            null comment '采购部门对接人联系方式',
    xsbmfzrxm                   varchar(20)            null comment '销售部门负责人姓名',
    xsbmfzrlxfs                 varchar(20)            null comment '销售部门负责人联系方式',
    xsbmdjrxm                   varchar(20)            null comment '销售部门对接人姓名',
    xsbmdjrlxfs                 varchar(20)            null comment '销售部门对接人联系方式',
    gsjj                        varchar(2048)          null comment '公司简介',
    jyys                        varchar(500)           null comment '经营优势',
    dept_id                     varchar(11)            null comment '组织机构ID',
    del_flag                    varchar(1) default '0' not null comment '是否删除',
    enable_flag                 varchar(1) default '0' not null comment '是否禁用',
    tenant_id                   int        default 1   not null comment '所属租户',
    create_time                 datetime               null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user                 int                    null comment '创建人',
    update_time                 datetime               null comment '更新时间',
    update_user                 int                    null comment '更新人',
    sygsdz                      varchar(255)           null comment '商业公司地址',
    medicine_traceability       varchar(1)             not null comment '药品信息化追溯体系（0-扫码入库，1-其他）',
    medicine_traceability_other varchar(255)           null comment '药品信息化追溯体系-其他（追溯体系介绍）'
)
    comment '档案-配送公司' row_format = DYNAMIC;

create table wm_da_drug_ent
(
    id           int auto_increment
        primary key,
    entname      varchar(50)      null comment '企业名称',
    entcode      varchar(50)      null comment '组织机构代码',
    temp1        varchar(50)      null,
    temp2        varchar(50)      null,
    temp3        varchar(50)      null,
    temp4        varchar(50)      null,
    dept_id      int              null comment '组织机构ID',
    del_flag     int(1) default 0 not null comment '是否删除',
    enable_flag  int(1) default 0 not null comment '是否禁用',
    tenant_id    int    default 1 not null comment '所属租户',
    create_time  datetime         null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user  int              null comment '创建人',
    update_time  datetime         null comment '更新时间',
    update_user  int              null comment '更新人',
    pgqx         varchar(2)       null comment '派工权限',
    management   varchar(2)       null comment '管理模式',
    subject_type varchar(1024)    null,
    constraint code
        unique (entcode)
)
    comment '档案-药企' row_format = DYNAMIC;

create table wm_da_drug_ent_drugtable
(
    id            int auto_increment
        primary key,
    drugname      varchar(50)      null comment '药品名称',
    drugname_ty   varchar(255)     null comment '通用药品你名称',
    drug_ent_id   char(11)         null comment '企业ID',
    is_yb         char             null comment '是否医保',
    dose_id       char(11)         null comment '剂型ID',
    guige_id      char(11)         null comment '规格ID',
    remark        varchar(255)     null comment '备注',
    dept_id       int              null comment '组织机构ID',
    del_flag      int(1) default 0 not null comment '是否删除',
    enable_flag   int(1) default 0 not null comment '是否禁用',
    tenant_id     int    default 1 not null comment '所属租户',
    create_time   datetime         null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user   int              null comment '创建人',
    update_time   datetime         null comment '更新时间',
    update_user   int              null comment '更新人',
    drug_ent_name varchar(255)     null comment '所属药企名称',
    drug_ent_num  int              null comment '分配统计',
    ssxkcyy       varchar(64)      null comment '上市许可持有人',
    yyfz          varchar(128)     null comment '原验/仿制',
    dose_name     varchar(128)     null comment '剂型名称',
    guige_name    varchar(128)     null comment '规格名称',
    detail        text             null comment '详情信息(暂手动维护,用于报告)'
)
    comment '档案-药企药品' row_format = DYNAMIC;

create index 剂型
    on wm_da_drug_ent_drugtable (dose_id);

create index 药企外键
    on wm_da_drug_ent_drugtable (drug_ent_id);

create index 规格
    on wm_da_drug_ent_drugtable (guige_id);

create table wm_da_hospital
(
    id          int auto_increment
        primary key,
    yymc        varchar(100)           not null comment '医院名称',
    province    varchar(20)            null comment '省',
    city        varchar(20)            null comment '市',
    area        varchar(20)            null comment '区',
    address     varchar(255)           null comment '地址',
    longitude   varchar(255)           null comment '经度',
    latitude    varchar(255)           null comment '纬度',
    yygm        varchar(20)            null comment '医院规模',
    yyxz        varchar(255)           null comment '医院性质',
    lxzj        varchar(50)            null comment '联系总机',
    ggyx        varchar(50)            null comment '公共邮箱',
    yzxm        varchar(50)            null comment '院长姓名',
    yzlxfs      varchar(20)            null comment '院长联系方式',
    fyzxm       varchar(20)            null comment '副院长姓名',
    fyzlxfs     varchar(20)            null comment '副院长联系方式',
    ywcczxm     varchar(20)            null comment '医务处处长姓名',
    ywcczlxfs   varchar(20)            null comment '医务处处长联系方式',
    jwcczxm     varchar(20)            null comment '教务处处长姓名',
    jwcczlxfs   varchar(20)            null comment '教务处处长联系方式',
    yjkzrxm     varchar(20)            null comment '药剂科主任姓名',
    yjkzrlsfs   varchar(20)            null comment '药剂科主任联系方式',
    ybczs       varchar(10)            null comment '院病床总数（张）',
    zlghsy      varchar(255)           null comment '主流供货商业',
    pspzsfry    char                   null comment '普什品种是否入院',
    pspzpssy    varchar(50)            null comment '普什品种配送商业',
    dept_id     varchar(11)            null comment '组织机构ID',
    website     varchar(1024)          null comment '医院官网',
    del_flag    varchar(1) default '0' not null comment '是否删除',
    enable_flag varchar(1) default '0' not null comment '是否禁用',
    tenant_id   int        default 1   not null comment '所属租户',
    create_time datetime               null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user int                    null comment '创建人',
    update_time datetime               null comment '更新时间',
    update_user int                    null comment '更新人',
    ybczs_bak   int(10)                null comment '备份床位数字段历史数据'
)
    comment '档案-医院' row_format = DYNAMIC;

create table wm_da_pharmacy
(
    id            int auto_increment
        primary key,
    pharmacy_name varchar(255)                  null comment '药店名称',
    province      longtext                      null comment '省',
    city          varchar(20)                   null comment '市',
    area          varchar(20)                   null comment '区',
    address       varchar(255)                  null comment '地址',
    longitude     varchar(255)                  null comment '经度',
    latitude      varchar(255)                  null comment '纬度',
    dept_id       varchar(11)                   null comment '组织机构ID',
    del_flag      varchar(1) default '0'        not null comment '是否删除',
    enable_flag   varchar(1) default '0'        not null comment '是否禁用',
    tenant_id     int        default 1          not null comment '所属租户',
    create_time   datetime                      null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user   int                           null comment '创建人',
    update_time   datetime                      null comment '更新时间',
    update_user   int                           null comment '更新人',
    pharmacy_type char(10)   default 'ORDINARY' null comment '药店类型'
)
    comment '药店档案' row_format = DYNAMIC;

create table wm_da_project
(
    id              int(50) auto_increment comment '主键id'
        primary key,
    project_id      bigint                                  null comment '项目id',
    project_name    varchar(50) charset utf8mb4             null comment '项目名称',
    partya          varchar(30) charset utf8mb4             null comment '项目甲方',
    partyb          varchar(30) charset utf8mb4             null comment '项目乙方',
    sign_data       datetime                                null comment '签订日期',
    expiration_date datetime                                null comment '有效期截止',
    project_status  int(1)                                  null comment '项目状态 2进行中 1已完成',
    customer_care   varchar(30) charset utf8mb4             null comment '客户维护',
    remark          varchar(50) charset utf8mb4  default '' null comment '说明',
    contract_file   varchar(500) charset utf8mb4 default '' null comment '合同附件',
    contract_name   varchar(30) charset utf8mb4             null comment '合同名称',
    create_time     datetime                                null comment '创建时间',
    create_user     int                                     null comment '创建人',
    update_time     datetime                                null comment '更新时间',
    update_user     int                                     null comment '更新人',
    export1         varchar(30) charset utf8mb4             null comment '备用1',
    export2         varchar(30) charset utf8mb4             null comment '备用2',
    export3         varchar(30) charset utf8mb4             null comment '备用3'
)
    comment '档案-项目管理' charset = utf8
                            row_format = DYNAMIC;

create table wm_da_track
(
    id                   int auto_increment comment '主键id'
        primary key,
    trace_principal_name varchar(50) charset utf8mb4            null comment '跟踪主体名称',
    trace_object_name    varchar(50) charset utf8mb4            null comment '跟踪客体名称',
    status               int(1)                                 null comment '状态 0进行中 1已完成',
    create_time          datetime                               null comment '创建时间',
    create_user          int                                    null comment '创建人',
    update_time          datetime                               null comment '更新时间',
    update_user          int                                    null comment '更新人',
    project_id           bigint                                 null comment '项目id',
    export1              varchar(30) charset utf8mb4 default '' null comment '备用1',
    export2              varchar(30) charset utf8mb4 default '' null comment '备用2',
    export3              varchar(30) charset utf8mb4 default '' null comment '备用3'
)
    comment '档案-跟踪信息' charset = utf8
                            row_format = DYNAMIC;

create table wm_da_zb
(
    地区     varchar(255) null,
    医院编码 varchar(255) null,
    医院名称 varchar(255) null,
    医院地址 varchar(255) null,
    邮编     varchar(255) null,
    电话     varchar(255) null,
    院长     varchar(255) null,
    床位数   varchar(255) null,
    日门诊量 varchar(255) null,
    等级     varchar(255) null,
    专科     varchar(255) null,
    设备     varchar(255) null,
    网址     varchar(255) null,
    邮箱     varchar(255) null,
    f15      varchar(255) null,
    f16      varchar(255) null,
    id       int auto_increment
        primary key
)
    row_format = DYNAMIC;

create table wm_dept_budget
(
    id           int auto_increment
        primary key,
    dept_id      int          null comment '所属机构',
    belong_date  varchar(20)  null comment '预算月份',
    declare_dept varchar(255) null comment '申报机构',
    budget_type  varchar(2)   null comment '预算类型',
    budget       int(20)      null comment '预算值',
    create_time  datetime     null comment '创建时间'
)
    comment '预算管理' row_format = DYNAMIC;

create table wm_dept_gmv
(
    id                           int auto_increment comment '主键id'
        primary key,
    dept_id                      int                                not null comment '部门ID',
    year                         char(4)                            not null comment '年份',
    month                        char(4)                            not null comment '月份',
    gmv1                         bigint                             not null comment '按积分值统计的GMV（单位：积分）',
    gmv1_rate                    int                                not null comment 'gmv1收益率（万分之）',
    gmv2                         bigint                             not null comment '按结算额统计的GMV（单位：分）',
    gmv2_rate                    int                                not null comment 'gmv2收益率（万分之）',
    renlijia_service_charge_rate int                                null comment '人力家服务费（万分之）',
    income                       bigint                             not null comment '要易收益（单位：分）',
    update_time                  datetime default CURRENT_TIMESTAMP not null comment '修改时间'
)
    comment 'GMV数据统计主表' row_format = DYNAMIC;

create table wm_dept_gmv_record
(
    id                           int auto_increment comment 'id'
        primary key,
    gmv_id                       int                                not null comment 'GMV数据统计主表id',
    statistics_day               char(2)                            not null comment '统计日(1-31)',
    gmv1                         bigint                             not null comment '按积分值统计的GMV（单位：积分）',
    gmv1_rate                    int                                not null comment 'gmv1收益率（万分之）',
    gmv2                         bigint                             not null comment '按结算额统计的GMV（单位：分）',
    gmv2_rate                    int                                not null comment 'gmv2收益率（万分之）',
    renlijia_service_charge_rate int                                null comment '人力家服务费（万分之）',
    income                       bigint                             not null comment '要易收益（单位：分）',
    update_time                  datetime default CURRENT_TIMESTAMP not null comment '修改时间'
)
    comment 'GMV数据统计每日记录表' row_format = DYNAMIC;

create table wm_dept_regulations
(
    id          int auto_increment comment 'id'
        primary key,
    dept_id     int                                null comment '部门id',
    file_name   varchar(50)                        not null comment '文件名称',
    file_url    varchar(1024)                      not null comment '文件地址',
    sort        int      default 0                 not null comment '排序',
    del_flag    char     default '0'               not null comment '删除标记:0(未删除)，1(已删除)',
    enable_flag char     default '0'               not null comment '是否禁用:0(启用)，1(禁用)',
    create_time datetime default CURRENT_TIMESTAMP null comment '创建时间',
    update_time datetime                           null on update CURRENT_TIMESTAMP comment '修改时间',
    constraint wm_dept_regulations_dept_id_uindex
        unique (dept_id, file_name)
)
    comment '企业规章制度';

create table wm_dept_task_type_config
(
    id             int auto_increment
        primary key,
    dept_id        int      not null comment '组织机构ID',
    task_type_json text     null comment '任务类型配置',
    create_time    datetime null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user    int      null comment '创建人',
    update_time    datetime null comment '更新时间',
    update_user    int      null comment '更新人'
)
    comment '部门任务类型配置';

create table wm_dept_task_type_template
(
    id           int auto_increment
        primary key,
    dept_id      int         not null comment '组织机构ID',
    task_type_id int         null comment '任务类型id',
    template     varchar(64) null comment '模板',
    detail       json        null comment '规则详情',
    create_time  datetime    null comment '创建时间',
    create_user  int         null comment '创建人',
    update_time  datetime    null comment '更新时间',
    update_user  int         null comment '更新人'
)
    comment '部门任务类型模板';

create table wm_ent_rate
(
    id               int auto_increment,
    dept_id          int         not null,
    end_type         varchar(32) not null,
    subject_location varchar(32) not null comment '结算渠道',
    type             int         not null comment '结算手续费包含；0不包含、1包含',
    rate             double      null comment '结算渠道的服务费率',
    constraint wm_ent_rate_id_uindex
        unique (id)
)
    comment '企业服务费率';

create table wm_ent_relation
(
    id             int auto_increment
        primary key,
    dept_id_parent int         not null comment '当前企业的父级企业',
    dept_id        int         null comment '当前企业',
    dept_name      varchar(32) null comment '冗余字段，用于matebase检索企业名称',
    constraint wm_end_relation_id_uindex
        unique (id)
)
    comment '企业关联关系（仅限单层，暂不支持递归父级）';

create table wm_ent_type
(
    id       int auto_increment,
    dept_id  int         not null comment '关联企业id，详见sys_dept.dept_id'
        primary key,
    end_type varchar(32) not null comment '企业所属类型；CSO、HCP',
    constraint wm_end_type_id_uindex
        unique (id)
)
    comment '企业类型';

create table wm_feedback
(
    id          int auto_increment
        primary key,
    yj_userid   char(11)         null comment '反馈意见用户ID',
    yg_content  longtext         null comment '反馈意见内容',
    dept_id     int              null comment '组织机构ID',
    del_flag    int(1) default 0 not null comment '是否删除',
    enable_flag int(1) default 0 not null comment '是否禁用',
    tenant_id   int    default 1 not null comment '所属租户',
    create_time datetime         null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user int              null comment '创建人',
    update_time datetime         null comment '更新时间',
    update_user int              null comment '更新人'
)
    comment '意见反馈' row_format = DYNAMIC;

create index 反馈人ID
    on wm_feedback (yj_userid);

create table wm_import_user
(
    id                    int auto_increment
        primary key,
    score_id              varchar(50)      not null comment '积分包ID',
    import_name           varchar(20)      null comment '姓名',
    import_phone          varchar(20)      null comment '手机号',
    import_id_card_number varchar(18)      null comment '身份证号',
    user_sign             varchar(255)     null comment '签名',
    cert_status           int(2)           null comment '认证状态',
    cert_remark           varchar(255)     null comment '认证结果描述',
    create_time           datetime         null comment '创建时间',
    create_user           int              null comment '创建人',
    del_flag              char default '0' not null comment '是否删除',
    real_flag             char default '0' not null comment '是否禁用'
)
    comment '导入任务成员表' row_format = DYNAMIC;

create table wm_payoff
(
    id              int auto_increment comment '主键id'
        primary key,
    score_name      varchar(50) charset utf8mb4 null comment '积分包名称',
    id_number       varchar(20) charset utf8mb4 null comment '身份证号',
    settle_status   int(2)                      null comment '结算状态',
    cause_failure   varchar(50) charset utf8mb4 null comment '失败原因',
    cert_status     int(2)                      null comment '实名认证状态',
    submitted_value varchar(50) charset utf8mb4 null comment '已提交积分值',
    settle_amount   decimal(30, 2)              null comment '实际结算金额',
    discount        decimal(11, 4)              null comment '折扣',
    score_id        varchar(50) charset utf8mb4 null comment '关联积分包id',
    settle_people   varchar(20) charset utf8mb4 null comment '结算人',
    settle_time     datetime                    null comment '结算时间',
    statement_no    varchar(64) charset utf8mb4 null comment '结算单号',
    export1         varchar(20) charset utf8mb4 null comment '备用1',
    export2         varchar(20) charset utf8mb4 null comment '备用2',
    export3         varchar(20) charset utf8mb4 null comment '备用3'
)
    comment '结算表' charset = utf8
                     row_format = DYNAMIC;

create table wm_pkg_quiz_rel
(
    rel_id       int auto_increment comment 'Id'
        primary key,
    pkg_id       int                                    not null comment '积分包ID',
    quiz_id      int                                    null comment '试卷id',
    quiz_title   varchar(64)                            not null comment '标题',
    item_qty     int unsigned                           not null comment '试卷项数量',
    total_mark   int unsigned default 0                 not null comment '总分',
    passing_mark int unsigned default 0                 not null comment '及格分',
    quiz_items   json                                   null comment '试卷项',
    avail        tinyint(1)   default 1                 not null comment '可视化',
    create_time  datetime     default CURRENT_TIMESTAMP not null comment '创建时间'
)
    comment '积分包试卷表';

create table wm_project
(
    id             int auto_increment comment '主键id'
        primary key,
    dept_id        int          not null comment '部门id',
    project_number varchar(50)  not null comment '项目编号',
    project_name   varchar(50)  not null comment '项目名称',
    delegate       varchar(50)  not null comment '委托方',
    sign_time      datetime     not null comment '项目签约时间',
    remark         varchar(128) null comment '备注',
    create_time    datetime     null comment '创建时间',
    create_user    int          null comment '创建人',
    update_time    datetime     null comment '更新时间',
    update_user    int          null comment '更新人',
    constraint dept_id_project_number_unique
        unique (dept_id, project_number)
)
    comment '项目管理' row_format = DYNAMIC;

create table wm_project_evidence
(
    id          int auto_increment comment '主键id'
        primary key,
    project_id  int          not null comment '项目id',
    filename    varchar(64)  not null comment '文件名称',
    url         varchar(512) not null comment '静态证据url',
    type        varchar(10)  not null comment '文件类型',
    create_time datetime     null comment '创建时间',
    create_user int          null comment '创建人'
)
    comment '项目管理-静态证据子表' row_format = DYNAMIC;

create table wm_question
(
    qst_id      int auto_increment comment 'Id'
        primary key,
    serial_num  varchar(64)                        not null comment '序列号',
    label       varchar(64)                        not null comment '标题',
    options     json                               null comment '选项',
    answer      varchar(255)                       null comment '答案',
    ent_id      int unsigned                       not null comment '企业信息',
    create_by   varchar(64)                        not null comment '创建人',
    update_by   varchar(64)                        not null comment '修改人',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
    constraint uk_sn
        unique (serial_num)
)
    comment '试题表';

create index idx_eid
    on wm_question (ent_id);

create table wm_quiz
(
    quiz_id      int auto_increment comment 'Id'
        primary key,
    serial_num   varchar(64)                        not null comment '序列号',
    quiz_title   varchar(64)                        not null comment '标题',
    introduction varchar(255)                       null comment '简介',
    source_type  varchar(8)                         not null comment '问卷来源类型',
    quiz_state   varchar(8)                         not null comment '问卷状态',
    ent_id       int unsigned                       not null comment '企业信息',
    quiz_expand  json                               null comment '试卷统计',
    create_by    varchar(64)                        not null comment '创建人',
    update_by    varchar(64)                        not null comment '修改人',
    create_time  datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time  datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
    constraint uk_sn
        unique (serial_num)
)
    comment '试卷表';

create index idx_eid
    on wm_quiz (ent_id);

create index idx_st
    on wm_quiz (source_type);

create index idx_state
    on wm_quiz (quiz_state);

create table wm_quiz_item
(
    item_id      int auto_increment comment 'Id'
        primary key,
    quiz_sn      varchar(64)                        not null comment '试卷序号',
    label        varchar(1024)                      not null comment '标题',
    quiz_options json                               null comment '选项',
    answer       varchar(255)                       null comment '答案',
    widget       bigint                             not null comment '排序权重',
    mark         int      default 0                 not null comment '分数',
    create_by    varchar(64)                        not null comment '创建人',
    update_by    varchar(64)                        not null comment '修改人',
    create_time  datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time  datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间'
)
    comment '试卷项表';

create index idx_quiz_sn
    on wm_quiz_item (quiz_sn);

create table wm_relation
(
    up_id       int                                not null,
    down_id     int                                not null,
    create_time datetime default CURRENT_TIMESTAMP null comment '创建时间',
    constraint wm_relation_pk
        unique (up_id, down_id)
)
    comment '企业关系表' row_format = DYNAMIC;

create table wm_report
(
    id                int auto_increment comment '主键id'
        primary key,
    report_no         varchar(64)                 not null comment '报告单号',
    drug_ent_id       int                         null comment '结算企业ID',
    score_id          int                         not null comment '积分包ID',
    apply_drug_ent_id int                         null comment '申请结算企业ID',
    package_score     varchar(11)                 null comment '积分包值',
    task_number       varchar(11)                 null comment '任务数量',
    total_score       varchar(11)                 null comment '合计分值',
    report_status     varchar(2)                  null comment '报告状态',
    create_people     varchar(50)                 null comment '创建人',
    create_time       datetime                    null comment '创建时间',
    approval_people   varchar(20)                 null comment '审核人',
    approval_time     datetime                    null comment '审核时间',
    update_people     varchar(20)                 null comment '更新人',
    update_time       datetime                    null comment '更新时间',
    del_flag          varchar(2) default '0'      not null comment '是否删除',
    export1           varchar(20) charset utf8mb4 null comment '备用1',
    export2           varchar(20) charset utf8mb4 null comment '备用2',
    export3           varchar(20) charset utf8mb4 null comment '备用3'
)
    comment '报告审核表' charset = utf8
                         row_format = DYNAMIC;

create index wm_report_score_id_index
    on wm_report (score_id);

create table wm_report_export_record
(
    record_id     int auto_increment comment '主键id'
        primary key,
    report_no     varchar(64)  not null comment '报告单号',
    report_title  varchar(128) not null comment '报告名称',
    dept_id       int          null comment '结算企业ID',
    export_status varchar(2)   null comment '报告状态',
    oss_url       varchar(255) null comment '报告地址',
    created_by    varchar(50)  null comment '创建人',
    created_time  datetime     null comment '创建时间',
    finish_time   datetime     null comment '完成时间'
)
    comment '报告审核表' charset = utf8;

create table wm_score_package
(
    id                         int auto_increment
        primary key,
    task_rule_id               varchar(11)                 null comment '规则ID',
    drug_ent_id                varchar(11)                 null,
    score_id                   varchar(50)                 null,
    score_name                 varchar(255)                null comment '积分包名称',
    score                      varchar(11)                 null,
    agent_type_id              varchar(1)                  null,
    level1_id                  varchar(11)                 null comment '一级代理商',
    level2_id                  varchar(11)                 null comment '二级代理商',
    zb_id                      varchar(11)                 null comment '众包ID',
    xxdb_id                    varchar(11)                 null comment '销售代表ID',
    typeid                     varchar(11)                 null comment '分配对象类型',
    package_status             varchar(11)                 null comment '积分包状态',
    package_finish_status      varchar(2)                  null comment '积分包完成状态',
    package_audit_status       varchar(2)                  null comment '积分包审核状态',
    send_package_dept_id       varchar(11)                 null comment '发包方ID',
    dept_id                    varchar(11)                 null comment '组织机构ID',
    del_flag                   char           default '0'  not null comment '是否删除',
    enable_flag                char           default '0'  not null comment '是否禁用',
    tenant_id                  int            default 1    not null comment '所属租户',
    create_time                datetime                    null comment '创建时间',
    create_user                int                         null comment '创建人',
    update_time                datetime                    null comment '更新时间',
    update_user                int                         null comment '更新人',
    ytj                        int                         null,
    ysh                        int                         null,
    dsh                        int                         null,
    ytjtt                      int                         null,
    ywctt                      int                         null,
    yshtt                      int                         null,
    receive_date               datetime                    null comment '领取时间',
    is_conduct                 varchar(1)                  null comment '是否进行中',
    drugs_ids                  varchar(255)                null,
    statement_no               varchar(64)                 null comment '结算单号',
    settle_status              int(2)                      null comment '结算状态',
    remark                     varchar(255)                null comment '结算结果描述',
    invoice_category           varchar(50)                 null comment '发票类目',
    settle_amount              decimal(30, 2)              null comment '实际结算金额',
    discount                   decimal(11, 4)              null comment '折扣',
    package_finish_time        datetime                    null comment '完成时间',
    relation_score_id          varchar(11)                 null comment '关联积分包id',
    package_type1              varchar(11)                 null comment '积分包任务类型1',
    package_type2              varchar(11)                 null comment '积分包任务类型2',
    user_num                   int                         null comment '需求人数',
    task_num                   int                         null comment '任务个数',
    package_user_scope         varchar(11)                 null comment '接单对象范围',
    kfpjf                      int(30)                     null comment '可分配积分',
    belong_date                varchar(20)                 null comment '所属月份',
    allocation_date            datetime                    null comment '分配日期',
    pay_rate                   decimal(20, 2)              null comment '已支付百分比',
    finish_rate                decimal(20, 2)              null comment '已完成百分比',
    pay_score                  varchar(11)                 null comment '已支付积分值',
    end_label_date             varchar(64)                 null comment '查询结束日期',
    score_package_name         varchar(255)                null comment '积分包名称',
    related_service            varchar(11)                 null comment '关联服务企业',
    package_is_conduct         varchar(1)                  null comment '积分包是否进行中',
    description                varchar(255)                null comment '描述',
    user_score                 varchar(11)                 null comment '个人预计包值',
    enable_type                char           default '0'  null comment '终止方式',
    is_receive                 varchar(1)                  null comment '是否允许接单',
    rule_id                    varchar(50)                 null comment '规则id',
    accept_sug                 varchar(20)    default ''   null comment '接包对象',
    task_add_flag              varchar(1)     default '1'  null comment '是否可以新增任务1-可以  0-不可以',
    settle_flag                char           default '0'  null comment '结算状态',
    score_package_status       varchar(11)                 null comment '积分包状态',
    old_package                char(2)        default '0'  null comment '是否为旧数据',
    settlement_date            datetime                    null comment '结算时间',
    source_type                char           default '0'  null comment '数据来源类型（0：手动上传，1：系统对接）',
    project_num                varchar(50)                 null comment '项目编号',
    drug_producer              varchar(512)                null comment '关联药品生产厂商名称',
    p2p_amount                 decimal(11, 2)              null,
    p2p_time                   datetime                    null comment '公对公提交时间',
    oms_order_sn               varchar(64)                 null comment '订单号',
    sub_type                   varchar(2)                  null comment '结算渠道',
    sub_location               varchar(64)                 null comment '税源地',
    p2p_service_amount         decimal(11, 2) default 0.00 null comment '公对公服务费',
    pkg_sn                     varchar(32)                 null comment '积分包编号',
    mah_settle_dept_id         int                         null comment 'MAH结算-药企deptId',
    mah_settle_step            char(8)                     null comment 'MAH结算-步进状态(BUSINESS-业务, FINANCE-财务)',
    mah_settle_time            datetime                    null comment 'mah结算时间',
    ent_task_limit             decimal(5, 2)  default 0.00 null comment '企业任务上限(单位%)',
    drugtable                  varchar(255)                null comment '推广药品id',
    invoice_number             varchar(64)                 null comment '发票号码',
    invoice_file               json                        null comment '发票文件',
    audit_management_fee_rates decimal(5, 2)  default 0.00 not null comment '审核管理费比例',
    end_time                   date                        null comment '截止日期'
)
    comment '积分包' row_format = DYNAMIC;

create index wm_score_package_accept_sug_index
    on wm_score_package (accept_sug);

create index wm_score_package_mah_settle_dept_id_index
    on wm_score_package (mah_settle_dept_id);

create index wm_score_package_relation_score_id_index
    on wm_score_package (relation_score_id);

create index wm_score_package_send_dept_id_index
    on wm_score_package (send_package_dept_id);

create index 一级代理商1
    on wm_score_package (level1_id);

create index 二级代理商2
    on wm_score_package (level2_id);

create index 代理商
    on wm_score_package (agent_type_id);

create index 代理商类型
    on wm_score_package (drug_ent_id);

create index 众包
    on wm_score_package (zb_id);

create table wm_score_package_0226
(
    id                    int auto_increment
        primary key,
    task_rule_id          varchar(11)             null comment '规则ID',
    drug_ent_id           varchar(11)             null,
    score_id              varchar(50)             null,
    score_name            varchar(255)            null comment '积分包名称',
    score                 varchar(11)             null,
    agent_type_id         varchar(1)              null,
    level1_id             varchar(11)             null comment '一级代理商',
    level2_id             varchar(11)             null comment '二级代理商',
    zb_id                 varchar(11)             null comment '众包ID',
    xxdb_id               varchar(11)             null comment '销售代表ID',
    typeid                varchar(11)             null comment '分配对象类型',
    package_status        varchar(11)             null comment '积分包状态',
    package_finish_status varchar(2)              null comment '积分包完成状态',
    package_audit_status  varchar(2)              null comment '积分包审核状态',
    send_package_dept_id  varchar(11)             null comment '发包方ID',
    dept_id               varchar(11)             null comment '组织机构ID',
    del_flag              char        default '0' not null comment '是否删除',
    enable_flag           char        default '0' not null comment '是否禁用',
    tenant_id             int         default 1   not null comment '所属租户',
    create_time           datetime                null comment '创建时间',
    create_user           int                     null comment '创建人',
    update_time           datetime                null comment '更新时间',
    update_user           int                     null comment '更新人',
    ytj                   int                     null,
    ysh                   int                     null,
    dsh                   int                     null,
    ytjtt                 int                     null,
    ywctt                 int                     null,
    yshtt                 int                     null,
    receive_date          datetime                null comment '领取时间',
    is_conduct            varchar(1)              null comment '是否进行中',
    drugs_ids             varchar(255)            null,
    statement_no          varchar(64)             null comment '结算单号',
    settle_status         int(2)                  null comment '结算状态',
    remark                varchar(255)            null comment '结算结果描述',
    invoice_category      varchar(50)             null comment '发票类目',
    settle_amount         decimal(30, 2)          null comment '实际结算金额',
    discount              decimal(11, 4)          null comment '折扣',
    package_finish_time   datetime                null comment '完成时间',
    relation_score_id     varchar(11)             null comment '关联积分包id',
    package_type1         varchar(11)             null comment '积分包任务类型1',
    package_type2         varchar(11)             null comment '积分包任务类型2',
    user_num              int                     null comment '需求人数',
    task_num              int                     null comment '任务个数',
    package_user_scope    varchar(11)             null comment '接单对象范围',
    kfpjf                 int(30)                 null comment '可分配积分',
    belong_date           varchar(20)             null comment '所属月份',
    allocation_date       datetime                null comment '分配日期',
    pay_rate              decimal(20, 2)          null comment '已支付百分比',
    finish_rate           decimal(20, 2)          null comment '已完成百分比',
    pay_score             varchar(11)             null comment '已支付积分值',
    end_label_date        varchar(64)             null comment '查询结束日期',
    score_package_name    varchar(255)            null comment '积分包名称',
    related_service       varchar(11)             null comment '关联服务企业',
    package_is_conduct    varchar(1)              null comment '积分包是否进行中',
    description           varchar(255)            null comment '描述',
    user_score            varchar(11)             null comment '个人预计包值',
    enable_type           char        default '0' null comment '终止方式',
    is_receive            varchar(1)              null comment '是否允许接单',
    rule_id               varchar(50)             null comment '规则id',
    accept_sug            varchar(20) default ''  null comment '接包对象',
    task_add_flag         varchar(1)  default '1' null comment '是否可以新增任务1-可以  0-不可以',
    settle_flag           char        default '0' null comment '结算状态',
    score_package_status  varchar(11)             null comment '积分包状态',
    old_package           char(2)     default '0' null comment '是否为旧数据'
)
    comment '积分包' row_format = DYNAMIC;

create index 一级代理商1
    on wm_score_package_0226 (level1_id);

create index 二级代理商2
    on wm_score_package_0226 (level2_id);

create index 代理商
    on wm_score_package_0226 (agent_type_id);

create index 代理商类型
    on wm_score_package_0226 (drug_ent_id);

create index 众包
    on wm_score_package_0226 (zb_id);

create table wm_score_package_0517
(
    id                    int auto_increment
        primary key,
    task_rule_id          varchar(11)             null comment '规则ID',
    drug_ent_id           varchar(11)             null,
    score_id              varchar(50)             null,
    score_name            varchar(255)            null comment '积分包名称',
    score                 varchar(11)             null,
    agent_type_id         varchar(1)              null,
    level1_id             varchar(11)             null comment '一级代理商',
    level2_id             varchar(11)             null comment '二级代理商',
    zb_id                 varchar(11)             null comment '众包ID',
    xxdb_id               varchar(11)             null comment '销售代表ID',
    typeid                varchar(11)             null comment '分配对象类型',
    package_status        varchar(11)             null comment '积分包状态',
    package_finish_status varchar(2)              null comment '积分包完成状态',
    package_audit_status  varchar(2)              null comment '积分包审核状态',
    send_package_dept_id  varchar(11)             null comment '发包方ID',
    dept_id               varchar(11)             null comment '组织机构ID',
    del_flag              char        default '0' not null comment '是否删除',
    enable_flag           char        default '0' not null comment '是否禁用',
    tenant_id             int         default 1   not null comment '所属租户',
    create_time           datetime                null comment '创建时间',
    create_user           int                     null comment '创建人',
    update_time           datetime                null comment '更新时间',
    update_user           int                     null comment '更新人',
    ytj                   int                     null,
    ysh                   int                     null,
    dsh                   int                     null,
    ytjtt                 int                     null,
    ywctt                 int                     null,
    yshtt                 int                     null,
    receive_date          datetime                null comment '领取时间',
    is_conduct            varchar(1)              null comment '是否进行中',
    drugs_ids             varchar(255)            null,
    statement_no          varchar(64)             null comment '结算单号',
    settle_status         int(2)                  null comment '结算状态',
    remark                varchar(255)            null comment '结算结果描述',
    invoice_category      varchar(50)             null comment '发票类目',
    settle_amount         decimal(30, 2)          null comment '实际结算金额',
    discount              decimal(11, 4)          null comment '折扣',
    package_finish_time   datetime                null comment '完成时间',
    relation_score_id     varchar(11)             null comment '关联积分包id',
    package_type1         varchar(11)             null comment '积分包任务类型1',
    package_type2         varchar(11)             null comment '积分包任务类型2',
    user_num              int                     null comment '需求人数',
    task_num              int                     null comment '任务个数',
    package_user_scope    varchar(11)             null comment '接单对象范围',
    kfpjf                 int(30)                 null comment '可分配积分',
    belong_date           varchar(20)             null comment '所属月份',
    allocation_date       datetime                null comment '分配日期',
    pay_rate              decimal(20, 2)          null comment '已支付百分比',
    finish_rate           decimal(20, 2)          null comment '已完成百分比',
    pay_score             varchar(11)             null comment '已支付积分值',
    end_label_date        varchar(64)             null comment '查询结束日期',
    score_package_name    varchar(255)            null comment '积分包名称',
    related_service       varchar(11)             null comment '关联服务企业',
    package_is_conduct    varchar(1)              null comment '积分包是否进行中',
    description           varchar(255)            null comment '描述',
    user_score            varchar(11)             null comment '个人预计包值',
    enable_type           char        default '0' null comment '终止方式',
    is_receive            varchar(1)              null comment '是否允许接单',
    rule_id               varchar(50)             null comment '规则id',
    accept_sug            varchar(20) default ''  null comment '接包对象',
    task_add_flag         varchar(1)  default '1' null comment '是否可以新增任务1-可以  0-不可以',
    settle_flag           char        default '0' null comment '结算状态',
    score_package_status  varchar(11)             null comment '积分包状态',
    old_package           char(2)     default '0' null comment '是否为旧数据',
    settlement_date       datetime                null comment '结算时间'
)
    comment '积分包' row_format = DYNAMIC;

create index 一级代理商1
    on wm_score_package_0517 (level1_id);

create index 二级代理商2
    on wm_score_package_0517 (level2_id);

create index 代理商
    on wm_score_package_0517 (agent_type_id);

create index 代理商类型
    on wm_score_package_0517 (drug_ent_id);

create index 众包
    on wm_score_package_0517 (zb_id);

create table wm_score_package_settle_note
(
    id                 int auto_increment
        primary key,
    package_status_id  varchar(20)      null,
    package_id         varchar(20)      null,
    settle_amount      decimal(10, 2)   null,
    user_id            varchar(20)      null,
    invoice_type       int(20)          null,
    settle_no          varchar(128)     null,
    discount           decimal(10, 2)   null,
    settle_note_status int(2) default 0 null,
    remark             text             null,
    notify_time        datetime         null,
    task_id            varchar(20)      null comment '任务ID',
    category_name      varchar(128)     null comment '开票类型名称',
    create_time        datetime         null comment '创建时间',
    sub_time           datetime         null comment '提交时间',
    update_time        datetime         null comment '更新时间',
    stream_id          varchar(50)      null comment '税邦云流水号',
    id_card_number     varchar(20)      null comment '身份证号',
    sub_to_gig_time    datetime         null comment '提交到零工平台时间',
    sub_type           varchar(2)       null comment '结算类型',
    subject_location   varchar(64)      null comment '税源地',
    third_task_id      varchar(20)      null comment '第三方任务id',
    finish_task_flag   int    default 0 null comment '是否完成完单操作',
    actual_amount      decimal(18, 2)   null,
    settle_dept_id     int              null comment '实际结算企业id',
    settle_dept_sub_id int              null comment '实际结算企业subId',
    review_status      char(20)         null comment '财务复核状态',
    review_time        datetime         null comment '复核时间',
    review_user        int              null comment '复核人'
)
    charset = utf8
    row_format = DYNAMIC;

create table wm_score_package_settle_note_0510
(
    id                 int auto_increment
        primary key,
    package_status_id  varchar(20)                         null,
    package_id         varchar(20)                         null,
    settle_amount      decimal(10, 2)                      null,
    user_id            varchar(20)                         null,
    invoice_type       int(20)                             null,
    settle_no          varchar(128)                        null,
    discount           decimal(10, 2)                      null,
    settle_note_status int(2)    default 0                 null,
    remark             varchar(256)                        null,
    notify_time        timestamp default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP
)
    charset = utf8
    row_format = DYNAMIC;

create table wm_score_package_settle_note_0517
(
    id                 int auto_increment
        primary key,
    package_status_id  varchar(20)                         null,
    package_id         varchar(20)                         null,
    settle_amount      decimal(10, 2)                      null,
    user_id            varchar(20)                         null,
    invoice_type       int(20)                             null,
    settle_no          varchar(128)                        null,
    discount           decimal(10, 2)                      null,
    settle_note_status int(2)    default 0                 null,
    remark             varchar(256)                        null,
    notify_time        timestamp default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP
)
    charset = utf8
    row_format = DYNAMIC;

create table wm_score_package_settle_note_111
(
    id                 int auto_increment
        primary key,
    package_status_id  varchar(20)      null,
    package_id         varchar(20)      null,
    settle_amount      decimal(10, 2)   null,
    user_id            varchar(20)      null,
    invoice_type       int(20)          null,
    settle_no          varchar(128)     null,
    discount           decimal(10, 2)   null,
    settle_note_status int(2) default 0 null,
    remark             varchar(256)     null,
    notify_time        timestamp        null,
    task_id            varchar(20)      null comment '任务ID',
    category_name      varchar(128)     null comment '开票类型名称',
    create_time        datetime         null comment '创建时间',
    sub_time           datetime         null comment '提交时间',
    update_time        datetime         null comment '更新时间',
    stream_id          varchar(50)      null comment '税邦云流水号',
    id_card_number     varchar(20)      null comment '身份证号',
    sub_type           varchar(2)       null comment '结算类型'
)
    charset = utf8
    row_format = DYNAMIC;

create table wm_score_package_settle_note_20220113
(
    id                 int            null,
    package_status_id  varchar(20)    null,
    package_id         varchar(20)    null,
    settle_amount      decimal(10, 2) null,
    user_id            varchar(20)    null,
    invoice_type       int            null,
    settle_no          varchar(128)   null,
    discount           decimal(10, 2) null,
    settle_note_status int            null,
    remark             varchar(256)   null,
    notify_time        datetime       null,
    task_id            varchar(20)    null,
    category_name      varchar(128)   null,
    create_time        datetime       null,
    sub_time           datetime       null,
    update_time        datetime       null,
    stream_id          varchar(50)    null,
    id_card_number     varchar(20)    null,
    sub_type           varchar(2)     null,
    sub_to_gig_time    datetime       null
)
    comment '税邦云回调数据异常，数据回滚前备份';

create table wm_score_package_status
(
    id            int auto_increment
        primary key,
    user_id       varchar(11)            null comment '用户id',
    package_id    varchar(11)            null comment '积分包id',
    status        varchar(11)            null comment '审核状态：1.审核中，2.审核通过，3.审核不通过',
    dept_id       varchar(11)            null comment '组织机构ID',
    del_flag      char       default '0' not null comment '是否删除',
    enable_flag   char       default '0' not null comment '是否禁用',
    tenant_id     int        default 1   not null comment '所属租户',
    create_time   datetime               null comment '创建时间',
    create_user   int                    null comment '创建人',
    update_time   datetime               null comment '更新时间',
    update_user   int                    null comment '更新人',
    user_score    varchar(11)            null comment '个人预计包值',
    enable_type   char       default '0' null comment '终止方式',
    task_num      int                    null comment '个人包任务个数',
    task_add_flag varchar(1) default '1' null comment '是否可以新增任务1-可以  0-不可以',
    quiz_res      json                   null comment '测评结果'
)
    comment '积分包状态' row_format = DYNAMIC;

create table wm_score_package_status_0226
(
    id            int auto_increment
        primary key,
    user_id       varchar(11)            null,
    package_id    varchar(11)            null,
    status        varchar(11)            null,
    dept_id       varchar(11)            null comment '组织机构ID',
    del_flag      char       default '0' not null comment '是否删除',
    enable_flag   char       default '0' not null comment '是否禁用',
    tenant_id     int        default 1   not null comment '所属租户',
    create_time   datetime               null comment '创建时间',
    create_user   int                    null comment '创建人',
    update_time   datetime               null comment '更新时间',
    update_user   int                    null comment '更新人',
    user_score    varchar(11)            null comment '个人预计包值',
    enable_type   char       default '0' null comment '终止方式',
    task_num      int                    null comment '个人包任务个数',
    task_add_flag varchar(1) default '1' null comment '是否可以新增任务1-可以  0-不可以'
)
    comment '积分包状态' row_format = DYNAMIC;

create table wm_score_package_task_ref
(
    id              int              not null
        primary key,
    task_id         varchar(11)      null comment '任务ID',
    task_package_id varchar(11)      null comment '任务所属积分包ID',
    user_id         varchar(11)      null comment '医药代表ID',
    status          varchar(11)      null comment '任务状态',
    dept_id         varchar(11)      null comment '组织机构ID',
    del_flag        char default '0' not null comment '是否删除',
    enable_flag     char default '0' not null comment '是否禁用',
    tenant_id       int  default 1   not null comment '所属租户',
    create_time     datetime         null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user     int              null comment '创建人',
    update_time     datetime         null comment '更新时间',
    update_user     int              null comment '更新人'
)
    comment '任务-积分包关联' row_format = DYNAMIC;

create index package1
    on wm_score_package_task_ref (task_package_id);

create index rw1
    on wm_score_package_task_ref (task_id);

create index user11
    on wm_score_package_task_ref (user_id);

create table wm_score_task_type
(
    id           bigint auto_increment comment '主键id'
        primary key,
    score_id     varchar(20) charset utf8mb4  null comment '关联积分包id',
    task_type_id varchar(11) charset utf8mb4  null comment '有效任务类型id',
    type         varchar(255) charset utf8mb4 null comment '积分包类型，1:定额，2定量'
)
    comment '积分包任务类型表' charset = utf8
                               row_format = DYNAMIC;

create table wm_settle_account_receive
(
    id             int auto_increment
        primary key,
    account_name   varchar(255)                       null,
    account_no     varchar(255)                       null,
    op_type        varchar(255)                       null,
    amount         varchar(255)                       null,
    bank_serial_no varchar(255)                       null,
    explore1       varchar(255)                       null,
    explore2       varchar(255)                       null,
    explore3       varchar(255)                       null,
    update_time    datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间'
)
    charset = utf8
    row_format = DYNAMIC;

create table wm_task
(
    id                             int auto_increment
        primary key,
    task_number                    varchar(32)             null comment '任务编号',
    task_rule_id                   varchar(11)             null comment '积分规则',
    score                          int(5)                  null comment '积分值',
    score_package_drug_id          varchar(11)             null comment '任务提交到的积分包ID',
    score_package_level1_id        varchar(11)             null comment '任务提交到一级经销商的集分宝id',
    score_package_id               varchar(11)             null comment '积分包',
    task_type_id                   varchar(11)             null comment '任务类型ID',
    lookinto_date                  datetime                null comment '调研时间',
    province                       varchar(20)             null comment '省',
    city                           varchar(20)             null comment '市',
    area                           varchar(20)             null comment '区',
    address                        varchar(255)            null comment '地址',
    lookinto_type_id               varchar(11)             null comment '调研类型ID',
    task_content_id                varchar(11)             null comment '任务内容ID',
    task_status                    char(2)                 null comment '任务状态',
    task_user_id                   varchar(11)             null comment '任务用户ID',
    task_user_type                 varchar(11)             null comment '用户类型ID',
    drug_ent_id                    varchar(11)             null comment '服务药企',
    dept_id                        varchar(11)             null comment '组织机构ID',
    del_flag                       char        default '0' not null comment '是否删除',
    enable_flag                    char        default '0' not null comment '是否禁用',
    tenant_id                      int         default 1   not null comment '所属租户',
    create_time                    datetime                null comment '创建时间',
    create_user                    int                     null comment '创建人',
    update_time                    datetime                null comment '更新时间',
    update_user                    int                     null comment '更新人',
    submit_status                  varchar(2)              null comment '提交状态',
    share_img_url                  varchar(255)            null comment '分享图片地址',
    plat_audit_status              char(2)     default '0' null comment '平台审核状态',
    ext_ids                        varchar(255)            null comment '备用字段',
    task_info_img                  varchar(255)            null comment '任务详情图片',
    compare_result                 varchar(2)              null comment '对比结果',
    approval_opinion               varchar(2)              null comment '审批意见',
    approval_info                  varchar(500)            null comment '审批说明',
    real_flag                      char(2)     default '0' null comment '是否真实',
    report_one_id                  int                     null comment '任务提交到一级cso的报告ID',
    report_one_approval_status     varchar(32) default '0' null comment '任务提交到一级cso的报告审核状态',
    report_one_approval_opinion    varchar(2)              null comment '任务提交到一级cso的报告审批意见',
    report_one_approval_info       varchar(1024)           null comment '任务提交到一级cso的报告审批说明',
    report_second_id               int                     null comment '任务提交到二级cso的报告ID',
    report_second_approval_status  varchar(32) default '0' null comment '任务提交到二级cso的报告审核状态',
    report_second_approval_opinion varchar(2)              null comment '任务提交到二级cso的报告审批意见',
    report_second_approval_info    varchar(1024)           null comment '任务提交到二级cso的报告审批说明',
    report_drug_id                 int                     null comment '任务提交到药企的报告ID',
    report_drug_approval_status    varchar(32) default '0' null comment '任务提交到药企的报告审核状态',
    report_drug_approval_opinion   varchar(2)              null comment '任务提交到药企的报告审批意见',
    report_drug_approval_info      varchar(1024)           null comment '任务提交到药企的报告审批说明',
    task_status_info               varchar(500)            null comment 'cso审核审核意见',
    task_from                      varchar(2)  default '1' null comment '来源',
    task_settle_status             int                     null comment '任务结算状态',
    review_task_count              int         default 0   not null comment '复审次数记录',
    dept_review_task_count         int         default 0   not null comment '企业复审次数记录',
    approval_user_id               int                     null comment '审核人userId',
    approval_time                  datetime                null comment '审核时间',
    dept_approval_user_id          int                     null comment '企业审核人userId',
    dept_approval_time             datetime                null comment '企业审核时间',
    remote_ip                      varchar(255)            null comment '远端ip',
    ip2region                      varchar(255)            null comment '地址'
)
    comment '任务表' row_format = DYNAMIC;

create index sp_ts_rf_index
    on wm_task (score_package_id, real_flag, task_status);

create index wm_task_report_drug_id_index
    on wm_task (report_drug_id);

create index wm_task_report_one_id_index
    on wm_task (report_one_id);

create index wm_task_report_second_id_index
    on wm_task (report_second_id);

create index wm_task_score_package_id_index
    on wm_task (score_package_id);

create index wm_task_user_id_index
    on wm_task (task_user_id);

create index 任务内容
    on wm_task (task_content_id);

create index 任务类型task
    on wm_task (task_type_id);

create index 调研类型
    on wm_task (lookinto_type_id);

create table wm_task_0514
(
    id                             int auto_increment
        primary key,
    task_rule_id                   varchar(11)             null comment '积分规则',
    score                          int(5)                  null comment '积分值',
    score_package_drug_id          varchar(11)             null comment '任务提交到的积分包ID',
    score_package_level1_id        varchar(11)             null comment '任务提交到一级经销商的集分宝id',
    score_package_id               varchar(11)             null comment '积分包',
    task_type_id                   varchar(11)             null comment '任务类型ID',
    lookinto_date                  datetime                null comment '调研时间',
    province                       varchar(20)             null comment '省',
    city                           varchar(20)             null comment '市',
    area                           varchar(20)             null comment '区',
    address                        varchar(255)            null comment '地址',
    lookinto_type_id               varchar(11)             null comment '调研类型ID',
    task_content_id                varchar(11)             null comment '任务内容ID',
    task_status                    char(2)                 null comment '任务状态',
    task_user_id                   varchar(11)             null comment '任务用户ID',
    task_user_type                 varchar(11)             null comment '用户类型ID',
    drug_ent_id                    varchar(11)             null comment '服务药企',
    dept_id                        varchar(11)             null comment '组织机构ID',
    del_flag                       char        default '0' not null comment '是否删除',
    enable_flag                    char        default '0' not null comment '是否禁用',
    tenant_id                      int         default 1   not null comment '所属租户',
    create_time                    datetime                null comment '创建时间',
    create_user                    int                     null comment '创建人',
    update_time                    datetime                null comment '更新时间',
    update_user                    int                     null comment '更新人',
    submit_status                  varchar(2)              null comment '提交状态',
    share_img_url                  varchar(255)            null comment '分享图片地址',
    plat_audit_status              char(2)     default '0' null comment '平台审核状态',
    ext_ids                        varchar(255)            null comment '备用字段',
    task_info_img                  varchar(255)            null comment '任务详情图片',
    compare_result                 varchar(2)              null comment '对比结果',
    approval_opinion               varchar(2)              null comment '审批意见',
    approval_info                  varchar(500)            null comment '审批说明',
    real_flag                      char(2)     default '0' null comment '是否真实',
    report_one_id                  int                     null comment '任务提交到一级cso的报告ID',
    report_one_approval_status     varchar(32) default '0' null comment '任务提交到一级cso的报告审核状态',
    report_one_approval_opinion    varchar(2)              null comment '任务提交到一级cso的报告审批意见',
    report_one_approval_info       varchar(50)             null comment '任务提交到一级cso的报告审批说明',
    report_second_id               int                     null comment '任务提交到二级cso的报告ID',
    report_second_approval_status  varchar(32) default '0' null comment '任务提交到二级cso的报告审核状态',
    report_second_approval_opinion varchar(2)              null comment '任务提交到二级cso的报告审批意见',
    report_second_approval_info    varchar(50)             null comment '任务提交到二级cso的报告审批说明',
    report_drug_id                 int                     null comment '任务提交到药企的报告ID',
    report_drug_approval_status    varchar(32) default '0' null comment '任务提交到药企的报告审核状态',
    report_drug_approval_opinion   varchar(2)              null comment '任务提交到药企的报告审批意见',
    report_drug_approval_info      varchar(50)             null comment '任务提交到药企的报告审批说明',
    task_status_info               varchar(500)            null comment 'cso审核审核意见',
    task_from                      varchar(2)  default '1' null comment '来源'
)
    comment '任务表' row_format = DYNAMIC;

create index 任务内容
    on wm_task_0514 (task_content_id);

create index 任务类型task
    on wm_task_0514 (task_type_id);

create index 调研类型
    on wm_task_0514 (lookinto_type_id);

create table wm_task_0518
(
    id                             int auto_increment
        primary key,
    task_rule_id                   varchar(11)             null comment '积分规则',
    score                          int(5)                  null comment '积分值',
    score_package_drug_id          varchar(11)             null comment '任务提交到的积分包ID',
    score_package_level1_id        varchar(11)             null comment '任务提交到一级经销商的集分宝id',
    score_package_id               varchar(11)             null comment '积分包',
    task_type_id                   varchar(11)             null comment '任务类型ID',
    lookinto_date                  datetime                null comment '调研时间',
    province                       varchar(20)             null comment '省',
    city                           varchar(20)             null comment '市',
    area                           varchar(20)             null comment '区',
    address                        varchar(255)            null comment '地址',
    lookinto_type_id               varchar(11)             null comment '调研类型ID',
    task_content_id                varchar(11)             null comment '任务内容ID',
    task_status                    char(2)                 null comment '任务状态',
    task_user_id                   varchar(11)             null comment '任务用户ID',
    task_user_type                 varchar(11)             null comment '用户类型ID',
    drug_ent_id                    varchar(11)             null comment '服务药企',
    dept_id                        varchar(11)             null comment '组织机构ID',
    del_flag                       char        default '0' not null comment '是否删除',
    enable_flag                    char        default '0' not null comment '是否禁用',
    tenant_id                      int         default 1   not null comment '所属租户',
    create_time                    datetime                null comment '创建时间',
    create_user                    int                     null comment '创建人',
    update_time                    datetime                null comment '更新时间',
    update_user                    int                     null comment '更新人',
    submit_status                  varchar(2)              null comment '提交状态',
    share_img_url                  varchar(255)            null comment '分享图片地址',
    plat_audit_status              char(2)     default '0' null comment '平台审核状态',
    ext_ids                        varchar(255)            null comment '备用字段',
    task_info_img                  varchar(255)            null comment '任务详情图片',
    compare_result                 varchar(2)              null comment '对比结果',
    approval_opinion               varchar(2)              null comment '审批意见',
    approval_info                  varchar(500)            null comment '审批说明',
    real_flag                      char(2)     default '0' null comment '是否真实',
    report_one_id                  int                     null comment '任务提交到一级cso的报告ID',
    report_one_approval_status     varchar(32) default '0' null comment '任务提交到一级cso的报告审核状态',
    report_one_approval_opinion    varchar(2)              null comment '任务提交到一级cso的报告审批意见',
    report_one_approval_info       varchar(50)             null comment '任务提交到一级cso的报告审批说明',
    report_second_id               int                     null comment '任务提交到二级cso的报告ID',
    report_second_approval_status  varchar(32) default '0' null comment '任务提交到二级cso的报告审核状态',
    report_second_approval_opinion varchar(2)              null comment '任务提交到二级cso的报告审批意见',
    report_second_approval_info    varchar(50)             null comment '任务提交到二级cso的报告审批说明',
    report_drug_id                 int                     null comment '任务提交到药企的报告ID',
    report_drug_approval_status    varchar(32) default '0' null comment '任务提交到药企的报告审核状态',
    report_drug_approval_opinion   varchar(2)              null comment '任务提交到药企的报告审批意见',
    report_drug_approval_info      varchar(50)             null comment '任务提交到药企的报告审批说明',
    task_status_info               varchar(500)            null comment 'cso审核审核意见',
    task_from                      varchar(2)  default '1' null comment '来源'
)
    comment '任务表' row_format = DYNAMIC;

create index 任务内容
    on wm_task_0518 (task_content_id);

create index 任务类型task
    on wm_task_0518 (task_type_id);

create index 调研类型
    on wm_task_0518 (lookinto_type_id);

create table wm_task_content
(
    id     int auto_increment
        primary key,
    temp1  varchar(1000) null comment '字段1',
    temp2  varchar(1000) null comment '字段2',
    temp3  varchar(1000) null comment '字段3',
    temp4  varchar(1000) null comment '字段4',
    temp5  varchar(1000) null,
    temp6  varchar(1000) null,
    temp7  varchar(1000) null,
    temp8  varchar(1000) null,
    temp9  varchar(1000) null,
    temp10 longtext      null,
    temp11 varchar(255)  null,
    temp12 longtext      null,
    temp13 varchar(255)  null,
    temp14 varchar(255)  null,
    temp15 varchar(255)  null,
    temp16 varchar(255)  null,
    temp17 varchar(255)  null,
    temp18 varchar(255)  null,
    temp19 varchar(255)  null,
    temp20 longtext      null,
    temp21 varchar(2000) null,
    temp22 varchar(255)  null,
    temp23 varchar(255)  null,
    temp24 varchar(255)  null,
    temp25 varchar(255)  null,
    temp26 varchar(255)  null,
    temp28 text          null,
    temp29 text          null,
    temp30 varchar(255)  null,
    temp31 varchar(255)  null comment 'temp31',
    temp32 varchar(255)  null comment 'temp32'
)
    comment '任务内容表' row_format = DYNAMIC;

create table wm_task_content_config
(
    id                 int auto_increment
        primary key,
    base_type_id       char(10)                           null comment '任务大类',
    task_type_id       char(10)                           null comment '任务ID',
    task_filed_key     varchar(255)                       null comment '字段1',
    task_filed_value   varchar(255)                       null comment '字段2',
    seq                int                                null comment '顺序',
    task_filed_type    char(20)                           null comment '字段类型',
    task_filed_minsize int                                null comment '最大长度',
    task_filed_maxsize int                                null comment '最小长度',
    task_filed_alert   varchar(255)                       null comment '弹框提示',
    dict_url           varchar(255)                       null comment '字典值请求URL',
    dict_group_name    varchar(255)                       null comment '字典值分组名称',
    is_mustfill        char                               null comment '是否必填',
    dept_id            int                                null comment '组织机构ID',
    del_flag           char     default '0'               not null comment '是否删除',
    enable_flag        char     default '0'               not null comment '是否禁用',
    tenant_id          int      default 1                 not null comment '所属租户',
    create_time        datetime default CURRENT_TIMESTAMP null comment '创建时间',
    create_user        int                                null comment '创建人',
    update_time        datetime default CURRENT_TIMESTAMP null comment '更新时间',
    update_user        int                                null comment '更新人'
)
    comment '任务内容字段配置' row_format = DYNAMIC;

create index 任务5
    on wm_task_content_config (task_type_id);

create table wm_task_download_job
(
    id               int auto_increment
        primary key,
    agent_id         varchar(10) not null,
    task_type_id     varchar(10) not null,
    download_user_id varchar(10) null
)
    row_format = DYNAMIC;

create table wm_task_info_config_ref
(
    id                    int         not null
        primary key,
    task_table_name       varchar(50) null comment '任务表名称',
    task_table_filed_name varchar(50) not null comment '任务表字段名称',
    config_filed_name     varchar(50) null comment '配置字段名称',
    task_type_id          int         null comment '任务类型ID'
)
    row_format = DYNAMIC;

create table wm_task_rule
(
    id           int auto_increment
        primary key,
    drugent_id   char(10)               null comment '药企ID',
    rule_type_id char(2)                null comment '规则类型，1药企 2一级代理商',
    rule_month   varchar(255)           null comment '规则月份',
    level1_id    varchar(11)            null comment '一级代理商ID',
    level2_id    varchar(11)            null comment '二级代理商ID',
    dept_id      varchar(11)            null comment '组织机构ID',
    del_flag     varchar(1) default '0' not null comment '是否删除',
    enable_flag  varchar(1) default '0' not null comment '是否禁用',
    tenant_id    int        default 1   not null comment '所属租户',
    create_time  datetime               null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user  int                    null comment '创建人',
    update_time  datetime               null comment '更新时间',
    update_user  int                    null comment '更新人'
)
    comment '任务积分规则' row_format = DYNAMIC;

create table wm_task_settle_note
(
    id                 int auto_increment
        primary key,
    package_id         varchar(20)             null,
    package_status_id  varchar(20)             null,
    task_id            varchar(20)             null,
    settle_amount      decimal(10, 2)          null,
    user_id            varchar(20)             null,
    invoice_type       int(20)                 null,
    settle_no          varchar(128)            null,
    discount           decimal(10, 2)          null,
    settle_note_status int(2)       default 0  null,
    remark             varchar(256)            null,
    category_name      varchar(255)            null,
    create_time        datetime                null,
    sub_time           datetime                null,
    notify_time        datetime                null,
    update_time        datetime                null,
    stream_id          varchar(255) default '' null
)
    charset = utf8
    row_format = DYNAMIC;

create table wm_task_sub_percent_rule
(
    rule_id     int(20) auto_increment comment '规则ID'
        primary key,
    dept_id     int(20)                            not null comment '企业id',
    sub_cate    varchar(50)                        not null comment '次级分类',
    batch_id    varchar(32)                        null comment '批量保存编号',
    sub_rule    json                               null comment '规则',
    opt_flag    varchar(32)                        not null comment '操作标记',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '任务提交百分比限制规则表';

create index idx_dept_id
    on wm_task_sub_percent_rule (dept_id);

create index idx_sub_cate
    on wm_task_sub_percent_rule (sub_cate);

create table wm_task_sub_rule
(
    rule_id     int(20) auto_increment comment '规则ID'
        primary key,
    dept_id     int(20)                            not null comment '企业id',
    sub_cate    varchar(32)                        not null comment '次级分类',
    sub_rule    json                               null comment '规则',
    opt_flag    varchar(32)                        not null comment '操作标记',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '任务提交规则表';

create index idx_dept_id
    on wm_task_sub_rule (dept_id);

create index idx_sub_cate
    on wm_task_sub_rule (sub_cate);

create table wm_task_type
(
    id                 int(11) unsigned auto_increment
        primary key,
    task_type_name     varchar(50)             null comment '任务类型名称',
    task_type_level    char                    null comment '任务类型级别',
    task_score_start   int(5)                  null comment '积分范围开始',
    task_score_end     int(5)                  null comment '积分范围结束',
    score              int(10)                 null comment '完成后可获得分',
    task_ent_id        varchar(11)             null comment '积分分配代理商',
    durgent_id         char(11)                null comment '药企ID',
    level1_id          char(11)                null comment '一级代理商ID',
    dept_id            int                     null comment '组织机构ID',
    del_flag           int(1)      default 0   not null comment '是否删除',
    enable_flag        char        default '0' not null comment '是否禁用',
    tenant_id          int         default 1   not null comment '所属租户',
    create_time        datetime                null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user        int                     null comment '创建人',
    update_time        datetime                null comment '更新时间',
    update_user        int                     null comment '更新人',
    status             int(1)      default 0   null comment '积分规则状态',
    base_id            varchar(11)             null comment '父类ID',
    real_flag          char                    null,
    rule_id            varchar(64) default ''  null,
    parent_id          varchar(11)             null comment '父级ID',
    task_receiver_type char        default '1' null comment '承接对象(1-个人,2-企业)',
    task_remark        text                    null comment '任务备注'
)
    comment '任务类型打分表' row_format = DYNAMIC;

create table wm_task_type_0422
(
    id               int(11) unsigned auto_increment
        primary key,
    task_type_name   varchar(50)             null comment '任务类型名称',
    task_type_level  char                    null comment '任务类型级别',
    task_score_start int(5)                  null comment '积分范围开始',
    task_score_end   int(5)                  null comment '积分范围结束',
    score            int(10)                 null comment '完成后可获得分',
    task_ent_id      varchar(11)             null comment '积分分配代理商',
    durgent_id       char(11)                null comment '药企ID',
    level1_id        char(11)                null comment '一级代理商ID',
    dept_id          int                     null comment '组织机构ID',
    del_flag         int(1)      default 0   not null comment '是否删除',
    enable_flag      char        default '0' not null comment '是否禁用',
    tenant_id        int         default 1   not null comment '所属租户',
    create_time      datetime                null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user      int                     null comment '创建人',
    update_time      datetime                null comment '更新时间',
    update_user      int                     null comment '更新人',
    status           int(1)      default 0   null comment '积分规则状态',
    base_id          varchar(11)             null comment '父类ID',
    real_flag        char                    null,
    rule_id          varchar(64) default ''  null,
    parent_id        varchar(11)             null comment '父级ID'
)
    comment '任务类型打分表' row_format = DYNAMIC;

create table wm_task_type_ent_ref
(
    id          int auto_increment
        primary key,
    agent_id    varchar(11)                        null comment '代理商ID',
    drugent_id  varchar(11)                        null comment '药企ID',
    dept_id     int                                null comment '组织机构ID',
    del_flag    char     default '0'               not null comment '是否删除',
    enable_flag char     default '0'               not null comment '是否禁用',
    tenant_id   int      default 1                 not null comment '所属租户',
    create_time datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user int                                null comment '创建人',
    update_time datetime                           null comment '更新时间',
    update_user int                                null comment '更新人'
)
    comment '药企给代理商设定积分规则' row_format = DYNAMIC;

create table wm_task_type_score_ref
(
    id              int              not null
        primary key,
    task_rule_id    int              null comment '积分规则ID',
    task_type_score varchar(255)     null comment '任务类型打分',
    task_type_id    int              null comment '任务类型ID',
    typeid          int(1)           null comment '1.平台给一级代理商打分
2.一级代理商给二级代理商打分',
    level1_id       int(10)          null comment '一级代理商ID',
    level2_id       int(10)          null comment '二级代理商ID',
    drugent_id      int(10)          null comment '药企ID',
    month_str       varchar(255)     null comment '积分规则所属月份',
    dept_id         int              null comment '组织机构ID',
    del_flag        int(1) default 0 not null comment '是否删除',
    enable_flag     int(1) default 0 not null comment '是否禁用',
    tenant_id       int    default 1 not null comment '所属租户',
    create_time     datetime         null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user     int              null comment '创建人',
    update_time     datetime         null comment '更新时间',
    update_user     int              null comment '更新人'
)
    comment '任务类型打分' row_format = DYNAMIC;

create index taskrule11
    on wm_task_type_score_ref (task_rule_id);

create index tasktype112
    on wm_task_type_score_ref (task_type_id);

create table wm_task_type_sub_cate
(
    ttsc_id     int(20) auto_increment comment '规则ID'
        primary key,
    type_id     int(20)                            not null comment '企业id',
    type_name   varchar(32)                        not null comment '任务名称',
    sub_cate    varchar(32)                        not null comment '次级分类',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '任务提交规则表';

create index idx_dept_id
    on wm_task_type_sub_cate (type_id);

create index idx_sub_cate
    on wm_task_type_sub_cate (sub_cate);

create table wm_task_type_sub_cate2
(
    dtt_id      int(20) auto_increment comment '主键ID'
        primary key,
    type_id     int(20)                            not null comment '企业id',
    type_name   varchar(32)                        not null comment '任务名称',
    sub_cate    varchar(50)                        not null comment '次级分类',
    parent_id   varchar(10)                        null comment '对应wm_task_type的parent_id',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间'
)
    comment '任务类型二级分类表';

create index idx_dept_id
    on wm_task_type_sub_cate2 (type_id);

create index idx_sub_cate
    on wm_task_type_sub_cate2 (sub_cate);

create table wm_task_ware
(
    ware_id       bigint unsigned auto_increment comment 'id'
        primary key,
    ware_sn       varchar(64)                               not null comment '库存序号',
    task_id       varchar(18)                               not null comment '任务id',
    ava_count     bigint unsigned default 1                 not null comment '可用库存数',
    locked_count  bigint unsigned default 0                 not null comment '已锁定数量',
    order_sn      bigint                                    null comment '锁定订单',
    created_time  datetime        default CURRENT_TIMESTAMP not null comment '创建时间',
    modified_time datetime                                  not null on update CURRENT_TIMESTAMP comment '修改时间',
    constraint uk_record_id
        unique (task_id)
)
    comment '任务库存表';

create table wm_team
(
    id          int auto_increment
        primary key,
    dept_id     int                                not null comment '组织机构ID',
    name        varchar(50)                        not null comment '团队名称',
    leader      varchar(128)                       null comment '团队负责人',
    member      varchar(2048)                      null comment '团队成员',
    enable_flag char     default '0'               not null comment '是否禁用（0-企业，1-禁用）',
    del_flag    char     default '0'               not null comment '是否删除（0-正常，1-已删除）',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    create_user int                                null comment '创建人',
    update_time datetime                           null comment '更新时间',
    update_user int                                null comment '更新人'
)
    comment '团队管理';

create table wm_user_plat_quiz_res
(
    res_id      int auto_increment comment 'Id'
        primary key,
    user_id     int                                not null comment '用户ID',
    quiz_id     int                                null comment '试卷id',
    quiz_res    json                               null comment '测试结果',
    res_expiry  date                               not null comment '测评有效期',
    create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间'
)
    comment '用户测评的评判结果';

create index idx_qid
    on wm_user_plat_quiz_res (quiz_id);

create index idx_uid
    on wm_user_plat_quiz_res (user_id);

create table wm_user_sign
(
    id            int auto_increment
        primary key,
    sign_userid   varchar(11)  null comment '签到人',
    sign_ent_id   varchar(11)  null comment '签到企业ID',
    sign_date     datetime     null comment '签到日期',
    score         int          null comment '得分',
    longitude     varchar(255) not null comment '经度',
    latitude      varchar(255) not null comment '纬度',
    sign_ent_name varchar(255) null comment '签单企业名称',
    sign_ent_type varchar(11)  null comment '签到企业类型',
    task_type_id  varchar(11)  null comment '任务类型id'
)
    comment '用户签到表' row_format = DYNAMIC;

create table wm_user_sign_detail
(
    id            int auto_increment
        primary key,
    sign_id       int                          not null comment '签到表id',
    drug          text                         not null comment '推广药品',
    purpose       varchar(20)                  not null comment '拜访目的',
    result        char                         not null comment '拜访结果',
    remark        varchar(255)                 null comment '备注',
    department    varchar(64)                  null comment '拜访科室',
    visitor       varchar(64)                  null comment '拜访人员',
    detail        json                         null comment '详情数据',
    template_type char(10) default 'TEMPLATE1' null comment '所属模板类型'
)
    comment '用户签到详情';

create table wm_wk_album
(
    id          int auto_increment
        primary key,
    xcmc        varchar(255)     not null comment '相册名称',
    scfm        varchar(255)     not null comment '封面',
    glyp        varchar(255)     null comment '关联药品',
    wb          longtext         not null comment '文本',
    dept_id     int              null comment '组织机构ID',
    del_flag    int(1) default 0 not null comment '是否删除',
    enable_flag int(1) default 0 not null comment '是否禁用',
    tenant_id   int    default 1 not null comment '所属租户',
    create_time datetime         null on update CURRENT_TIMESTAMP comment '创建时间',
    create_user int              null comment '创建人',
    update_time datetime         null comment '更新时间',
    update_user int              null comment '更新人',
    forward_num int    default 0 null comment '转发数',
    temp1       varchar(255)     null comment '关联药品汉字',
    score       varchar(255)     null comment '前端显示分数使用'
)
    comment '文库-相册' row_format = DYNAMIC;

create table wm_wk_article
(
    id          int auto_increment
        primary key,
    title       varchar(500)     not null comment '文章标题',
    author      varchar(255)     not null comment '作者',
    fm          varchar(255)     null comment '封面',
    content     longtext         not null comment '文章内容',
    source      varchar(255)     null comment '文章来源',
    description varchar(1000)    null comment '描述',
    dept_id     int              null comment '组织机构ID',
    del_flag    int(1) default 0 not null comment '是否删除',
    enable_flag int(1) default 0 not null comment '是否禁用',
    tenant_id   int    default 1 not null comment '所属租户',
    create_time datetime         null comment '创建时间',
    create_user int              null comment '创建人',
    update_time datetime         null comment '更新时间',
    update_user int              null comment '更新人',
    forward_num int              null comment '转发数',
    channel_id  varchar(50)      null comment '抓取文章栏目ID',
    article_id  varchar(50)      null comment '抓取文章ID',
    score       varchar(255)     null,
    read_num    int    default 0 null comment '阅读数',
    new_flag    int(1) default 0 null comment '新标签',
    hot_flag    int(1) default 0 null comment '热门标签',
    area        varchar(128)     null comment '区域',
    source_ent  varchar(255)     null comment '文章来源(来源企业)'
)
    comment '文库-文章' row_format = DYNAMIC;

create table wm_wk_article0507
(
    id          int    default 0 not null,
    title       varchar(500)     not null comment '文章标题',
    author      varchar(255)     not null comment '作者',
    fm          varchar(255)     null comment '封面',
    content     longtext         not null comment '文章内容',
    source      varchar(255)     null comment '文章来源',
    description varchar(1000)    null comment '描述',
    dept_id     int              null comment '组织机构ID',
    del_flag    int(1) default 0 not null comment '是否删除',
    enable_flag int(1) default 0 not null comment '是否禁用',
    tenant_id   int    default 1 not null comment '所属租户',
    create_time datetime         null comment '创建时间',
    create_user int              null comment '创建人',
    update_time datetime         null comment '更新时间',
    update_user int              null comment '更新人',
    forward_num int              null comment '转发数',
    channel_id  varchar(50)      null comment '抓取文章栏目ID',
    article_id  varchar(50)      null comment '抓取文章ID',
    score       varchar(255)     null,
    read_num    int    default 0 null comment '阅读数',
    new_flag    int(1) default 0 null comment '新标签',
    hot_flag    int(1) default 0 null comment '热门标签',
    area        varchar(128)     null comment '区域'
)
    row_format = DYNAMIC;

create table wm_wk_article_20210225
(
    id          int auto_increment
        primary key,
    title       varchar(500)     not null comment '文章标题',
    author      varchar(255)     not null comment '作者',
    fm          varchar(255)     null comment '封面',
    content     longtext         not null comment '文章内容',
    source      varchar(255)     null comment '文章来源',
    description varchar(1000)    null comment '描述',
    dept_id     int              null comment '组织机构ID',
    del_flag    int(1) default 0 not null comment '是否删除',
    enable_flag int(1) default 0 not null comment '是否禁用',
    tenant_id   int    default 1 not null comment '所属租户',
    create_time datetime         null comment '创建时间',
    create_user int              null comment '创建人',
    update_time datetime         null comment '更新时间',
    update_user int              null comment '更新人',
    forward_num int              null comment '转发数',
    channel_id  varchar(50)      null comment '抓取文章栏目ID',
    article_id  varchar(50)      null comment '抓取文章ID',
    score       varchar(255)     null,
    read_num    int    default 0 null comment '阅读数',
    new_flag    int(1) default 0 null comment '新标签',
    hot_flag    int(1) default 0 null comment '热门标签',
    area        varchar(128)     null comment '区域'
)
    comment '文库-文章' row_format = DYNAMIC;

create table wm_wk_article_20210225001
(
    id          int auto_increment
        primary key,
    title       varchar(500)     not null comment '文章标题',
    author      varchar(255)     not null comment '作者',
    fm          varchar(255)     null comment '封面',
    content     longtext         not null comment '文章内容',
    source      varchar(255)     null comment '文章来源',
    description varchar(1000)    null comment '描述',
    dept_id     int              null comment '组织机构ID',
    del_flag    int(1) default 0 not null comment '是否删除',
    enable_flag int(1) default 0 not null comment '是否禁用',
    tenant_id   int    default 1 not null comment '所属租户',
    create_time datetime         null comment '创建时间',
    create_user int              null comment '创建人',
    update_time datetime         null comment '更新时间',
    update_user int              null comment '更新人',
    forward_num int              null comment '转发数',
    channel_id  varchar(50)      null comment '抓取文章栏目ID',
    article_id  varchar(50)      null comment '抓取文章ID',
    score       varchar(255)     null,
    read_num    int    default 0 null comment '阅读数',
    new_flag    int(1) default 0 null comment '新标签',
    hot_flag    int(1) default 0 null comment '热门标签',
    area        varchar(128)     null comment '区域'
)
    comment '文库-文章' row_format = DYNAMIC;

create table wm_wk_article_55798
(
    id          int    default 0 not null,
    title       varchar(500)     not null comment '文章标题',
    author      varchar(255)     not null comment '作者',
    fm          varchar(255)     null comment '封面',
    content     longtext         not null comment '文章内容',
    source      varchar(255)     null comment '文章来源',
    description varchar(1000)    null comment '描述',
    dept_id     int              null comment '组织机构ID',
    del_flag    int(1) default 0 not null comment '是否删除',
    enable_flag int(1) default 0 not null comment '是否禁用',
    tenant_id   int    default 1 not null comment '所属租户',
    create_time datetime         null comment '创建时间',
    create_user int              null comment '创建人',
    update_time datetime         null comment '更新时间',
    update_user int              null comment '更新人',
    forward_num int              null comment '转发数',
    channel_id  varchar(50)      null comment '抓取文章栏目ID',
    article_id  varchar(50)      null comment '抓取文章ID',
    score       varchar(255)     null,
    read_num    int    default 0 null comment '阅读数',
    new_flag    int(1) default 0 null comment '新标签',
    hot_flag    int(1) default 0 null comment '热门标签',
    area        varchar(128)     null comment '区域'
)
    row_format = DYNAMIC;

create table wm_wk_article_config
(
    id          int auto_increment
        primary key,
    type        char(2)                            null,
    source      varchar(11)                        null,
    total       int                                null,
    create_time datetime default CURRENT_TIMESTAMP null
)
    comment '文章抓取配置' row_format = DYNAMIC;

create table wm_wk_article_share
(
    id           int auto_increment
        primary key,
    share_type   varchar(11)  null comment '分享类型',
    arctile_id   varchar(200) null comment '文章ID',
    share_userid varchar(11)  null comment '分享用户ID',
    open_user    varchar(255) null comment '打开文章用户',
    create_time  datetime     null comment '打开时间',
    temp1        varchar(255) null comment '备用字段1',
    temp2        varchar(255) null comment '备用字段2',
    temp3        varchar(255) null comment '备用字段3'
)
    comment '文章分享' row_format = DYNAMIC;

create table xinbada_input_record
(
    id                 int auto_increment comment '主键id'
        primary key,
    signature          varchar(128)                            not null comment '签名',
    action_name        varchar(32)                             not null comment '通知类型',
    req_body           text                                    not null comment '请求body内容',
    order_uuid         varchar(64)                             null comment '订单编号唯一',
    order_status       int                                     null comment '订单状态',
    order_no           varchar(32)                             null,
    customer_user_uuid varchar(64)                             null,
    server_user_uuid   varchar(64)                             null,
    public_key         varchar(2048)                           null comment '请求公钥',
    private_key        varchar(2048)                           null comment '请求时私钥',
    create_time        timestamp   default CURRENT_TIMESTAMP   not null comment '创建时间',
    gig_type           varchar(32) default 'ZHENG_QI_ZHI_XING' null comment '零工平台类型'
)
    comment '正启之星请求记录';

create table xinshiyi_input_record
(
    id           int auto_increment comment '主键id'
        primary key,
    req_id       varchar(64)                        null comment '请求序号',
    batch_id     varchar(64)                        null comment '批次号',
    msg_method   char(20)                           null comment '消息接口名称',
    order_status int                                null comment '订单状态',
    req_body     text                               null comment '请求body',
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '薪事易回调异步通知记录';

create table xxl_job_group
(
    id           int auto_increment
        primary key,
    app_name     varchar(64)       not null comment '执行器AppName',
    title        varchar(12)       not null comment '执行器名称',
    `order`      int     default 0 not null comment '排序',
    address_type tinyint default 0 not null comment '执行器地址类型：0=自动注册、1=手动录入',
    address_list varchar(512)      null comment '执行器地址列表，多地址逗号分隔'
)
    row_format = DYNAMIC;

create table xxl_job_info
(
    id                        int auto_increment
        primary key,
    job_group                 int                  not null comment '执行器主键ID',
    job_cron                  varchar(128)         not null comment '任务执行CRON',
    job_desc                  varchar(255)         not null,
    add_time                  datetime             null,
    update_time               datetime             null,
    author                    varchar(64)          null comment '作者',
    alarm_email               varchar(255)         null comment '报警邮件',
    executor_route_strategy   varchar(50)          null comment '执行器路由策略',
    executor_handler          varchar(255)         null comment '执行器任务handler',
    executor_param            varchar(512)         null comment '执行器任务参数',
    executor_block_strategy   varchar(50)          null comment '阻塞处理策略',
    executor_timeout          int        default 0 not null comment '任务执行超时时间，单位秒',
    executor_fail_retry_count int        default 0 not null comment '失败重试次数',
    glue_type                 varchar(50)          not null comment 'GLUE类型',
    glue_source               mediumtext           null comment 'GLUE源代码',
    glue_remark               varchar(128)         null comment 'GLUE备注',
    glue_updatetime           datetime             null comment 'GLUE更新时间',
    child_jobid               varchar(255)         null comment '子任务ID，多个逗号分隔',
    trigger_status            tinyint    default 0 not null comment '调度状态：0-停止，1-运行',
    trigger_last_time         bigint(13) default 0 not null comment '上次调度时间',
    trigger_next_time         bigint(13) default 0 not null comment '下次调度时间'
)
    row_format = DYNAMIC;

create table xxl_job_lock
(
    lock_name varchar(50) not null comment '锁名称'
        primary key
)
    row_format = DYNAMIC;

create table xxl_job_log
(
    id                        bigint auto_increment
        primary key,
    job_group                 int               not null comment '执行器主键ID',
    job_id                    int               not null comment '任务，主键ID',
    executor_address          varchar(255)      null comment '执行器地址，本次执行的地址',
    executor_handler          varchar(255)      null comment '执行器任务handler',
    executor_param            varchar(512)      null comment '执行器任务参数',
    executor_sharding_param   varchar(20)       null comment '执行器任务分片参数，格式如 1/2',
    executor_fail_retry_count int     default 0 not null comment '失败重试次数',
    trigger_time              datetime          null comment '调度-时间',
    trigger_code              int               not null comment '调度-结果',
    trigger_msg               text              null comment '调度-日志',
    handle_time               datetime          null comment '执行-时间',
    handle_code               int               not null comment '执行-状态',
    handle_msg                text              null comment '执行-日志',
    alarm_status              tinyint default 0 not null comment '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败'
)
    row_format = DYNAMIC;

create index I_handle_code
    on xxl_job_log (handle_code);

create index I_trigger_time
    on xxl_job_log (trigger_time);

create table xxl_job_log_report
(
    id            int auto_increment
        primary key,
    trigger_day   datetime      null comment '调度-时间',
    running_count int default 0 not null comment '运行中-日志数量',
    suc_count     int default 0 not null comment '执行成功-日志数量',
    fail_count    int default 0 not null comment '执行失败-日志数量',
    constraint i_trigger_day
        unique (trigger_day)
)
    row_format = DYNAMIC;

create table xxl_job_logglue
(
    id          int auto_increment
        primary key,
    job_id      int          not null comment '任务，主键ID',
    glue_type   varchar(50)  null comment 'GLUE类型',
    glue_source mediumtext   null comment 'GLUE源代码',
    glue_remark varchar(128) not null comment 'GLUE备注',
    add_time    datetime     null,
    update_time datetime     null
)
    row_format = DYNAMIC;

create table xxl_job_registry
(
    id             int auto_increment
        primary key,
    registry_group varchar(50)  not null,
    registry_key   varchar(255) not null,
    registry_value varchar(255) not null,
    update_time    datetime     null
)
    row_format = DYNAMIC;

create index i_g_k_v
    on xxl_job_registry (registry_group, registry_key(191), registry_value(191));

create table xxl_job_user
(
    id         int auto_increment
        primary key,
    username   varchar(50)  not null comment '账号',
    password   varchar(50)  not null comment '密码',
    role       tinyint      not null comment '角色：0-普通用户、1-管理员',
    permission varchar(255) null comment '权限：执行器ID列表，多个逗号分割',
    constraint i_username
        unique (username)
)
    row_format = DYNAMIC;

create table zhongyiyun_input_record
(
    id           int auto_increment comment '主键id'
        primary key,
    req_type     varchar(20)                        not null comment '请求业务类型',
    req_id       varchar(64)                        null comment '请求序号',
    req_body     text                               null comment '请求body',
    decrypt_body text                               null comment '解密后的body',
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '众蚁云回调异步通知记录';

create table zhongzhi_input_record
(
    id          int auto_increment comment '主键id'
        primary key,
    req_type    varchar(20)                        not null comment '请求业务类型',
    order_no    varchar(64)                        null comment '三方订单号',
    req_body    text                               null comment '请求body',
    create_time datetime default CURRENT_TIMESTAMP null comment '创建时间'
)
    comment '中智回调异步通知记录';

create definer = root@`%` view view_wm_socre_package_total as
select `ccc`.`id`                    AS `id`,
       `ccc`.`invoice_category`      AS `invoice_category`,
       `ccc`.`settle_status`         AS `settle_status`,
       `ccc`.`settle_amount`         AS `settle_amount`,
       `ccc`.`discount`              AS `discount`,
       `ccc`.`task_rule_id`          AS `task_rule_id`,
       `ccc`.`drug_ent_id`           AS `drug_ent_id`,
       `ccc`.`score_id`              AS `score_id`,
       `ccc`.`score_name`            AS `score_name`,
       `ccc`.`score`                 AS `score`,
       `ccc`.`agent_type_id`         AS `agent_type_id`,
       `ccc`.`level1_id`             AS `level1_id`,
       `ccc`.`level2_id`             AS `level2_id`,
       `ccc`.`zb_id`                 AS `zb_id`,
       `ccc`.`xxdb_id`               AS `xxdb_id`,
       `ccc`.`typeid`                AS `typeid`,
       `ccc`.`package_status`        AS `package_status`,
       `ccc`.`package_finish_status` AS `package_finish_status`,
       `ccc`.`package_audit_status`  AS `package_audit_status`,
       `ccc`.`send_package_dept_id`  AS `send_package_dept_id`,
       `ccc`.`dept_id`               AS `dept_id`,
       `ccc`.`del_flag`              AS `del_flag`,
       `ccc`.`enable_flag`           AS `enable_flag`,
       `ccc`.`tenant_id`             AS `tenant_id`,
       `ccc`.`create_time`           AS `create_time`,
       `ccc`.`create_user`           AS `create_user`,
       `ccc`.`update_time`           AS `update_time`,
       `ccc`.`update_user`           AS `update_user`,
       `ccc`.`receive_date`          AS `receive_date`,
       `ccc`.`ytj`                   AS `ytj`,
       `ccc`.`ysh`                   AS `ysh`,
       `ccc`.`dsh`                   AS `dsh`,
       `ccc`.`t_type`                AS `t_type`
from (select `hnqzx`.`wm_score_package`.`id`                    AS `id`,
             `hnqzx`.`wm_score_package`.`invoice_category`      AS `invoice_category`,
             `hnqzx`.`wm_score_package`.`settle_status`         AS `settle_status`,
             `hnqzx`.`wm_score_package`.`settle_amount`         AS `settle_amount`,
             `hnqzx`.`wm_score_package`.`discount`              AS `discount`,
             `hnqzx`.`wm_score_package`.`task_rule_id`          AS `task_rule_id`,
             `hnqzx`.`wm_score_package`.`drug_ent_id`           AS `drug_ent_id`,
             `hnqzx`.`wm_score_package`.`score_id`              AS `score_id`,
             `hnqzx`.`wm_score_package`.`score_name`            AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                 AS `score`,
             `hnqzx`.`wm_score_package`.`agent_type_id`         AS `agent_type_id`,
             `hnqzx`.`wm_score_package`.`level1_id`             AS `level1_id`,
             `hnqzx`.`wm_score_package`.`level2_id`             AS `level2_id`,
             `hnqzx`.`wm_score_package`.`zb_id`                 AS `zb_id`,
             `hnqzx`.`wm_score_package`.`xxdb_id`               AS `xxdb_id`,
             `hnqzx`.`wm_score_package`.`typeid`                AS `typeid`,
             `hnqzx`.`wm_score_package`.`package_status`        AS `package_status`,
             `hnqzx`.`wm_score_package`.`package_finish_status` AS `package_finish_status`,
             `hnqzx`.`wm_score_package`.`package_audit_status`  AS `package_audit_status`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id`  AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`dept_id`               AS `dept_id`,
             `hnqzx`.`wm_score_package`.`del_flag`              AS `del_flag`,
             `hnqzx`.`wm_score_package`.`enable_flag`           AS `enable_flag`,
             `hnqzx`.`wm_score_package`.`tenant_id`             AS `tenant_id`,
             `hnqzx`.`wm_score_package`.`create_time`           AS `create_time`,
             `hnqzx`.`wm_score_package`.`create_user`           AS `create_user`,
             `hnqzx`.`wm_score_package`.`update_time`           AS `update_time`,
             `hnqzx`.`wm_score_package`.`update_user`           AS `update_user`,
             `hnqzx`.`wm_score_package`.`receive_date`          AS `receive_date`,
             `hnqzx`.`wm_score_package`.`is_conduct`            AS `is_conduct`,
             `bb`.`ytj`                                         AS `ytj`,
             `bb`.`ysh`                                         AS `ysh`,
             `bb`.`dsh`                                         AS `dsh`,
             1                                                  AS `t_type`
      from (`hnqzx`.`wm_score_package` left join (select `hnqzx`.`wm_task`.`score_package_id`  AS `score_package_id`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` > 0),
                                                                `hnqzx`.`wm_task`.`score`, 0)) AS `ytj`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 3),
                                                                `hnqzx`.`wm_task`.`score`, 0)) AS `ysh`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 2),
                                                                `hnqzx`.`wm_task`.`score`, 0)) AS `dsh`
                                                  from `hnqzx`.`wm_task`
                                                  where ((`hnqzx`.`wm_task`.`score_package_id` is not null) and
                                                         (`hnqzx`.`wm_task`.`real_flag` = '0'))
                                                  group by `hnqzx`.`wm_task`.`score_package_id`) `bb`
            on ((`hnqzx`.`wm_score_package`.`id` = `bb`.`score_package_id`)))
      where ((`hnqzx`.`wm_score_package`.`del_flag` = '0') and (`hnqzx`.`wm_score_package`.`enable_flag` = '0') and
             (`hnqzx`.`wm_score_package`.`agent_type_id` = 2) and (`hnqzx`.`wm_score_package`.`typeid` in (3, 4)))
      union
      select `hnqzx`.`wm_score_package`.`id`                    AS `id`,
             `hnqzx`.`wm_score_package`.`invoice_category`      AS `invoice_category`,
             `hnqzx`.`wm_score_package`.`settle_status`         AS `settle_status`,
             `hnqzx`.`wm_score_package`.`settle_amount`         AS `settle_amount`,
             `hnqzx`.`wm_score_package`.`discount`              AS `discount`,
             `hnqzx`.`wm_score_package`.`task_rule_id`          AS `task_rule_id`,
             `hnqzx`.`wm_score_package`.`drug_ent_id`           AS `drug_ent_id`,
             `hnqzx`.`wm_score_package`.`score_id`              AS `score_id`,
             `hnqzx`.`wm_score_package`.`score_name`            AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                 AS `score`,
             `hnqzx`.`wm_score_package`.`agent_type_id`         AS `agent_type_id`,
             `hnqzx`.`wm_score_package`.`level1_id`             AS `level1_id`,
             `hnqzx`.`wm_score_package`.`level2_id`             AS `level2_id`,
             `hnqzx`.`wm_score_package`.`zb_id`                 AS `zb_id`,
             `hnqzx`.`wm_score_package`.`xxdb_id`               AS `xxdb_id`,
             `hnqzx`.`wm_score_package`.`typeid`                AS `typeid`,
             `hnqzx`.`wm_score_package`.`package_status`        AS `package_status`,
             `hnqzx`.`wm_score_package`.`package_finish_status` AS `package_finish_status`,
             `hnqzx`.`wm_score_package`.`package_audit_status`  AS `package_audit_status`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id`  AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`dept_id`               AS `dept_id`,
             `hnqzx`.`wm_score_package`.`del_flag`              AS `del_flag`,
             `hnqzx`.`wm_score_package`.`enable_flag`           AS `enable_flag`,
             `hnqzx`.`wm_score_package`.`tenant_id`             AS `tenant_id`,
             `hnqzx`.`wm_score_package`.`create_time`           AS `create_time`,
             `hnqzx`.`wm_score_package`.`create_user`           AS `create_user`,
             `hnqzx`.`wm_score_package`.`update_time`           AS `update_time`,
             `hnqzx`.`wm_score_package`.`update_user`           AS `update_user`,
             `hnqzx`.`wm_score_package`.`receive_date`          AS `receive_date`,
             `hnqzx`.`wm_score_package`.`is_conduct`            AS `is_conduct`,
             `bb`.`ytj`                                         AS `ytj`,
             `bb`.`ysh`                                         AS `ysh`,
             `bb`.`dsh`                                         AS `dsh`,
             2                                                  AS `t_type`
      from (`hnqzx`.`wm_score_package` left join (select `hnqzx`.`wm_task`.`score_package_level1_id` AS `score_package_id`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` > 0),
                                                                `hnqzx`.`wm_task`.`score`, 0))       AS `ytj`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 3),
                                                                `hnqzx`.`wm_task`.`score`, 0))       AS `ysh`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 2),
                                                                `hnqzx`.`wm_task`.`score`, 0))       AS `dsh`
                                                  from `hnqzx`.`wm_task`
                                                  where ((`hnqzx`.`wm_task`.`score_package_id` is not null) and
                                                         (`hnqzx`.`wm_task`.`real_flag` = '0'))
                                                  group by `hnqzx`.`wm_task`.`score_package_level1_id`) `bb`
            on ((`hnqzx`.`wm_score_package`.`id` = `bb`.`score_package_id`)))
      where ((`hnqzx`.`wm_score_package`.`del_flag` = '0') and (`hnqzx`.`wm_score_package`.`enable_flag` = '0') and
             (`hnqzx`.`wm_score_package`.`agent_type_id` = 2) and (`hnqzx`.`wm_score_package`.`typeid` = 2))
      union
      select `hnqzx`.`wm_score_package`.`id`                    AS `id`,
             `hnqzx`.`wm_score_package`.`invoice_category`      AS `invoice_category`,
             `hnqzx`.`wm_score_package`.`settle_status`         AS `settle_status`,
             `hnqzx`.`wm_score_package`.`settle_amount`         AS `settle_amount`,
             `hnqzx`.`wm_score_package`.`discount`              AS `discount`,
             `hnqzx`.`wm_score_package`.`task_rule_id`          AS `task_rule_id`,
             `hnqzx`.`wm_score_package`.`drug_ent_id`           AS `drug_ent_id`,
             `hnqzx`.`wm_score_package`.`score_id`              AS `score_id`,
             `hnqzx`.`wm_score_package`.`score_name`            AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                 AS `score`,
             `hnqzx`.`wm_score_package`.`agent_type_id`         AS `agent_type_id`,
             `hnqzx`.`wm_score_package`.`level1_id`             AS `level1_id`,
             `hnqzx`.`wm_score_package`.`level2_id`             AS `level2_id`,
             `hnqzx`.`wm_score_package`.`zb_id`                 AS `zb_id`,
             `hnqzx`.`wm_score_package`.`xxdb_id`               AS `xxdb_id`,
             `hnqzx`.`wm_score_package`.`typeid`                AS `typeid`,
             `hnqzx`.`wm_score_package`.`package_status`        AS `package_status`,
             `hnqzx`.`wm_score_package`.`package_finish_status` AS `package_finish_status`,
             `hnqzx`.`wm_score_package`.`package_audit_status`  AS `package_audit_status`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id`  AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`dept_id`               AS `dept_id`,
             `hnqzx`.`wm_score_package`.`del_flag`              AS `del_flag`,
             `hnqzx`.`wm_score_package`.`enable_flag`           AS `enable_flag`,
             `hnqzx`.`wm_score_package`.`tenant_id`             AS `tenant_id`,
             `hnqzx`.`wm_score_package`.`create_time`           AS `create_time`,
             `hnqzx`.`wm_score_package`.`create_user`           AS `create_user`,
             `hnqzx`.`wm_score_package`.`update_time`           AS `update_time`,
             `hnqzx`.`wm_score_package`.`update_user`           AS `update_user`,
             `hnqzx`.`wm_score_package`.`receive_date`          AS `receive_date`,
             `hnqzx`.`wm_score_package`.`is_conduct`            AS `is_conduct`,
             `bb`.`ytj`                                         AS `ytj`,
             `bb`.`ysh`                                         AS `ysh`,
             `bb`.`dsh`                                         AS `dsh`,
             3                                                  AS `t_type`
      from (`hnqzx`.`wm_score_package` left join (select `hnqzx`.`wm_task`.`score_package_drug_id` AS `score_package_id`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` > 0),
                                                                `hnqzx`.`wm_task`.`score`, 0))     AS `ytj`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 3),
                                                                `hnqzx`.`wm_task`.`score`, 0))     AS `ysh`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 2),
                                                                `hnqzx`.`wm_task`.`score`, 0))     AS `dsh`
                                                  from `hnqzx`.`wm_task`
                                                  where ((`hnqzx`.`wm_task`.`score_package_id` is not null) and
                                                         (`hnqzx`.`wm_task`.`real_flag` = '0'))
                                                  group by `hnqzx`.`wm_task`.`score_package_drug_id`) `bb`
            on ((`hnqzx`.`wm_score_package`.`id` = `bb`.`score_package_id`)))
      where ((`hnqzx`.`wm_score_package`.`del_flag` = '0') and (`hnqzx`.`wm_score_package`.`enable_flag` = '0') and
             (`hnqzx`.`wm_score_package`.`agent_type_id` = 1))) `ccc`
order by `ccc`.`agent_type_id`, `ccc`.`create_time` desc;

create definer = root@`%` view view_wm_socre_package_total_20210115 as
select `ccc`.`id`                    AS `id`,
       `ccc`.`invoice_category`      AS `invoice_category`,
       `ccc`.`settle_status`         AS `settle_status`,
       `ccc`.`settle_amount`         AS `settle_amount`,
       `ccc`.`discount`              AS `discount`,
       `ccc`.`task_rule_id`          AS `task_rule_id`,
       `ccc`.`drug_ent_id`           AS `drug_ent_id`,
       `ccc`.`score_id`              AS `score_id`,
       `ccc`.`score_name`            AS `score_name`,
       `ccc`.`score`                 AS `score`,
       `ccc`.`agent_type_id`         AS `agent_type_id`,
       `ccc`.`level1_id`             AS `level1_id`,
       `ccc`.`level2_id`             AS `level2_id`,
       `ccc`.`zb_id`                 AS `zb_id`,
       `ccc`.`xxdb_id`               AS `xxdb_id`,
       `ccc`.`typeid`                AS `typeid`,
       `ccc`.`package_status`        AS `package_status`,
       `ccc`.`package_finish_status` AS `package_finish_status`,
       `ccc`.`package_audit_status`  AS `package_audit_status`,
       `ccc`.`send_package_dept_id`  AS `send_package_dept_id`,
       `ccc`.`dept_id`               AS `dept_id`,
       `ccc`.`del_flag`              AS `del_flag`,
       `ccc`.`enable_flag`           AS `enable_flag`,
       `ccc`.`tenant_id`             AS `tenant_id`,
       `ccc`.`create_time`           AS `create_time`,
       `ccc`.`create_user`           AS `create_user`,
       `ccc`.`update_time`           AS `update_time`,
       `ccc`.`update_user`           AS `update_user`,
       `ccc`.`receive_date`          AS `receive_date`,
       `ccc`.`ytj`                   AS `ytj`,
       `ccc`.`ysh`                   AS `ysh`,
       `ccc`.`dsh`                   AS `dsh`,
       `ccc`.`t_type`                AS `t_type`
from (select `hnqzx`.`wm_score_package`.`id`                    AS `id`,
             `hnqzx`.`wm_score_package`.`invoice_category`      AS `invoice_category`,
             `hnqzx`.`wm_score_package`.`settle_status`         AS `settle_status`,
             `hnqzx`.`wm_score_package`.`settle_amount`         AS `settle_amount`,
             `hnqzx`.`wm_score_package`.`discount`              AS `discount`,
             `hnqzx`.`wm_score_package`.`task_rule_id`          AS `task_rule_id`,
             `hnqzx`.`wm_score_package`.`drug_ent_id`           AS `drug_ent_id`,
             `hnqzx`.`wm_score_package`.`score_id`              AS `score_id`,
             `hnqzx`.`wm_score_package`.`score_name`            AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                 AS `score`,
             `hnqzx`.`wm_score_package`.`agent_type_id`         AS `agent_type_id`,
             `hnqzx`.`wm_score_package`.`level1_id`             AS `level1_id`,
             `hnqzx`.`wm_score_package`.`level2_id`             AS `level2_id`,
             `hnqzx`.`wm_score_package`.`zb_id`                 AS `zb_id`,
             `hnqzx`.`wm_score_package`.`xxdb_id`               AS `xxdb_id`,
             `hnqzx`.`wm_score_package`.`typeid`                AS `typeid`,
             `hnqzx`.`wm_score_package`.`package_status`        AS `package_status`,
             `hnqzx`.`wm_score_package`.`package_finish_status` AS `package_finish_status`,
             `hnqzx`.`wm_score_package`.`package_audit_status`  AS `package_audit_status`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id`  AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`dept_id`               AS `dept_id`,
             `hnqzx`.`wm_score_package`.`del_flag`              AS `del_flag`,
             `hnqzx`.`wm_score_package`.`enable_flag`           AS `enable_flag`,
             `hnqzx`.`wm_score_package`.`tenant_id`             AS `tenant_id`,
             `hnqzx`.`wm_score_package`.`create_time`           AS `create_time`,
             `hnqzx`.`wm_score_package`.`create_user`           AS `create_user`,
             `hnqzx`.`wm_score_package`.`update_time`           AS `update_time`,
             `hnqzx`.`wm_score_package`.`update_user`           AS `update_user`,
             `hnqzx`.`wm_score_package`.`receive_date`          AS `receive_date`,
             `hnqzx`.`wm_score_package`.`is_conduct`            AS `is_conduct`,
             `bb`.`ytj`                                         AS `ytj`,
             `bb`.`ysh`                                         AS `ysh`,
             `bb`.`dsh`                                         AS `dsh`,
             1                                                  AS `t_type`
      from (`hnqzx`.`wm_score_package` left join (select `hnqzx`.`wm_task`.`score_package_id`  AS `score_package_id`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` > 0),
                                                                `hnqzx`.`wm_task`.`score`, 0)) AS `ytj`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 3),
                                                                `hnqzx`.`wm_task`.`score`, 0)) AS `ysh`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 2),
                                                                `hnqzx`.`wm_task`.`score`, 0)) AS `dsh`
                                                  from `hnqzx`.`wm_task`
                                                  where (`hnqzx`.`wm_task`.`score_package_id` is not null)
                                                  group by `hnqzx`.`wm_task`.`score_package_id`) `bb`
            on ((`hnqzx`.`wm_score_package`.`id` = `bb`.`score_package_id`)))
      where ((`hnqzx`.`wm_score_package`.`del_flag` = '0') and (`hnqzx`.`wm_score_package`.`enable_flag` = '0') and
             (`hnqzx`.`wm_score_package`.`agent_type_id` = 2) and (`hnqzx`.`wm_score_package`.`typeid` in (3, 4)))
      union
      select `hnqzx`.`wm_score_package`.`id`                    AS `id`,
             `hnqzx`.`wm_score_package`.`invoice_category`      AS `invoice_category`,
             `hnqzx`.`wm_score_package`.`settle_status`         AS `settle_status`,
             `hnqzx`.`wm_score_package`.`settle_amount`         AS `settle_amount`,
             `hnqzx`.`wm_score_package`.`discount`              AS `discount`,
             `hnqzx`.`wm_score_package`.`task_rule_id`          AS `task_rule_id`,
             `hnqzx`.`wm_score_package`.`drug_ent_id`           AS `drug_ent_id`,
             `hnqzx`.`wm_score_package`.`score_id`              AS `score_id`,
             `hnqzx`.`wm_score_package`.`score_name`            AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                 AS `score`,
             `hnqzx`.`wm_score_package`.`agent_type_id`         AS `agent_type_id`,
             `hnqzx`.`wm_score_package`.`level1_id`             AS `level1_id`,
             `hnqzx`.`wm_score_package`.`level2_id`             AS `level2_id`,
             `hnqzx`.`wm_score_package`.`zb_id`                 AS `zb_id`,
             `hnqzx`.`wm_score_package`.`xxdb_id`               AS `xxdb_id`,
             `hnqzx`.`wm_score_package`.`typeid`                AS `typeid`,
             `hnqzx`.`wm_score_package`.`package_status`        AS `package_status`,
             `hnqzx`.`wm_score_package`.`package_finish_status` AS `package_finish_status`,
             `hnqzx`.`wm_score_package`.`package_audit_status`  AS `package_audit_status`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id`  AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`dept_id`               AS `dept_id`,
             `hnqzx`.`wm_score_package`.`del_flag`              AS `del_flag`,
             `hnqzx`.`wm_score_package`.`enable_flag`           AS `enable_flag`,
             `hnqzx`.`wm_score_package`.`tenant_id`             AS `tenant_id`,
             `hnqzx`.`wm_score_package`.`create_time`           AS `create_time`,
             `hnqzx`.`wm_score_package`.`create_user`           AS `create_user`,
             `hnqzx`.`wm_score_package`.`update_time`           AS `update_time`,
             `hnqzx`.`wm_score_package`.`update_user`           AS `update_user`,
             `hnqzx`.`wm_score_package`.`receive_date`          AS `receive_date`,
             `hnqzx`.`wm_score_package`.`is_conduct`            AS `is_conduct`,
             `bb`.`ytj`                                         AS `ytj`,
             `bb`.`ysh`                                         AS `ysh`,
             `bb`.`dsh`                                         AS `dsh`,
             2                                                  AS `t_type`
      from (`hnqzx`.`wm_score_package` left join (select `hnqzx`.`wm_task`.`score_package_level1_id` AS `score_package_id`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` > 0),
                                                                `hnqzx`.`wm_task`.`score`, 0))       AS `ytj`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 3),
                                                                `hnqzx`.`wm_task`.`score`, 0))       AS `ysh`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 2),
                                                                `hnqzx`.`wm_task`.`score`, 0))       AS `dsh`
                                                  from `hnqzx`.`wm_task`
                                                  where (`hnqzx`.`wm_task`.`score_package_id` is not null)
                                                  group by `hnqzx`.`wm_task`.`score_package_level1_id`) `bb`
            on ((`hnqzx`.`wm_score_package`.`id` = `bb`.`score_package_id`)))
      where ((`hnqzx`.`wm_score_package`.`del_flag` = '0') and (`hnqzx`.`wm_score_package`.`enable_flag` = '0') and
             (`hnqzx`.`wm_score_package`.`agent_type_id` = 2) and (`hnqzx`.`wm_score_package`.`typeid` = 2))
      union
      select `hnqzx`.`wm_score_package`.`id`                    AS `id`,
             `hnqzx`.`wm_score_package`.`invoice_category`      AS `invoice_category`,
             `hnqzx`.`wm_score_package`.`settle_status`         AS `settle_status`,
             `hnqzx`.`wm_score_package`.`settle_amount`         AS `settle_amount`,
             `hnqzx`.`wm_score_package`.`discount`              AS `discount`,
             `hnqzx`.`wm_score_package`.`task_rule_id`          AS `task_rule_id`,
             `hnqzx`.`wm_score_package`.`drug_ent_id`           AS `drug_ent_id`,
             `hnqzx`.`wm_score_package`.`score_id`              AS `score_id`,
             `hnqzx`.`wm_score_package`.`score_name`            AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                 AS `score`,
             `hnqzx`.`wm_score_package`.`agent_type_id`         AS `agent_type_id`,
             `hnqzx`.`wm_score_package`.`level1_id`             AS `level1_id`,
             `hnqzx`.`wm_score_package`.`level2_id`             AS `level2_id`,
             `hnqzx`.`wm_score_package`.`zb_id`                 AS `zb_id`,
             `hnqzx`.`wm_score_package`.`xxdb_id`               AS `xxdb_id`,
             `hnqzx`.`wm_score_package`.`typeid`                AS `typeid`,
             `hnqzx`.`wm_score_package`.`package_status`        AS `package_status`,
             `hnqzx`.`wm_score_package`.`package_finish_status` AS `package_finish_status`,
             `hnqzx`.`wm_score_package`.`package_audit_status`  AS `package_audit_status`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id`  AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`dept_id`               AS `dept_id`,
             `hnqzx`.`wm_score_package`.`del_flag`              AS `del_flag`,
             `hnqzx`.`wm_score_package`.`enable_flag`           AS `enable_flag`,
             `hnqzx`.`wm_score_package`.`tenant_id`             AS `tenant_id`,
             `hnqzx`.`wm_score_package`.`create_time`           AS `create_time`,
             `hnqzx`.`wm_score_package`.`create_user`           AS `create_user`,
             `hnqzx`.`wm_score_package`.`update_time`           AS `update_time`,
             `hnqzx`.`wm_score_package`.`update_user`           AS `update_user`,
             `hnqzx`.`wm_score_package`.`receive_date`          AS `receive_date`,
             `hnqzx`.`wm_score_package`.`is_conduct`            AS `is_conduct`,
             `bb`.`ytj`                                         AS `ytj`,
             `bb`.`ysh`                                         AS `ysh`,
             `bb`.`dsh`                                         AS `dsh`,
             3                                                  AS `t_type`
      from (`hnqzx`.`wm_score_package` left join (select `hnqzx`.`wm_task`.`score_package_drug_id` AS `score_package_id`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` > 0),
                                                                `hnqzx`.`wm_task`.`score`, 0))     AS `ytj`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 3),
                                                                `hnqzx`.`wm_task`.`score`, 0))     AS `ysh`,
                                                         sum(if((`hnqzx`.`wm_task`.`task_status` = 2),
                                                                `hnqzx`.`wm_task`.`score`, 0))     AS `dsh`
                                                  from `hnqzx`.`wm_task`
                                                  where (`hnqzx`.`wm_task`.`score_package_id` is not null)
                                                  group by `hnqzx`.`wm_task`.`score_package_drug_id`) `bb`
            on ((`hnqzx`.`wm_score_package`.`id` = `bb`.`score_package_id`)))
      where ((`hnqzx`.`wm_score_package`.`del_flag` = '0') and (`hnqzx`.`wm_score_package`.`enable_flag` = '0') and
             (`hnqzx`.`wm_score_package`.`agent_type_id` = 1))) `ccc`
order by `ccc`.`agent_type_id`, `ccc`.`create_time` desc;

create definer = root@`%` view wm_zb_count as
select distinct `ccc`.`package_id`              AS `package_id`,
                `ccc`.`score_name`              AS `score_name`,
                `ccc`.`score_id`                AS `score_id`,
                `ccc`.`package_score`           AS `package_score`,
                `ccc`.`send_package_dept_id`    AS `send_package_dept_id`,
                `ccc`.`pcreate_time`            AS `pcreate_time`,
                `ccc`.`realname`                AS `realname`,
                `ccc`.`idcard`                  AS `idcard`,
                `ccc`.`phone`                   AS `phone`,
                `ccc`.`dept_name`               AS `dept_name`,
                `ccc`.`user_id`                 AS `user_id`,
                `ccc`.`task_type_name`          AS `task_type_name`,
                `ccc`.`base_id`                 AS `base_id`,
                `ccc`.`id`                      AS `id`,
                `ccc`.`task_rule_id`            AS `task_rule_id`,
                `ccc`.`score`                   AS `score`,
                `ccc`.`score_package_drug_id`   AS `score_package_drug_id`,
                `ccc`.`score_package_level1_id` AS `score_package_level1_id`,
                `ccc`.`score_package_id`        AS `score_package_id`,
                `ccc`.`task_type_id`            AS `task_type_id`,
                `ccc`.`lookinto_date`           AS `lookinto_date`,
                `ccc`.`province`                AS `province`,
                `ccc`.`city`                    AS `city`,
                `ccc`.`area`                    AS `area`,
                `ccc`.`address`                 AS `address`,
                `ccc`.`lookinto_type_id`        AS `lookinto_type_id`,
                `ccc`.`task_content_id`         AS `task_content_id`,
                `ccc`.`task_status`             AS `task_status`,
                `ccc`.`task_user_id`            AS `task_user_id`,
                `ccc`.`task_user_type`          AS `task_user_type`,
                `ccc`.`drug_ent_id`             AS `drug_ent_id`,
                `ccc`.`dept_id`                 AS `dept_id`,
                `ccc`.`del_flag`                AS `del_flag`,
                `ccc`.`enable_flag`             AS `enable_flag`,
                `ccc`.`tenant_id`               AS `tenant_id`,
                `ccc`.`lookinto_date`           AS `create_time`,
                `ccc`.`create_user`             AS `create_user`,
                `ccc`.`update_time`             AS `update_time`,
                `ccc`.`update_user`             AS `update_user`,
                `ccc`.`submit_status`           AS `submit_status`,
                `ccc`.`share_img_url`           AS `share_img_url`,
                `ccc`.`plat_audit_status`       AS `plat_audit_status`,
                `ccc`.`ext_ids`                 AS `ext_ids`,
                `ccc`.`task_info_img`           AS `task_info_img`,
                `ccc`.`t_type`                  AS `t_type`
from (select `hnqzx`.`wm_score_package`.`id`                   AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`id_card_number`               AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`real_flag`                     AS `real_flag`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             1                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_drug_id`         AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`id_card_number`               AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`real_flag`                     AS `real_flag`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             2                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_drug_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_level1_id`       AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`id_card_number`               AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`real_flag`                     AS `real_flag`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             3                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_level1_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))) `ccc`
where ((`ccc`.`package_id` is not null) and (`ccc`.`task_status` = 3) and (`ccc`.`enable_flag` = 0) and
       (`ccc`.`del_flag` = 0) and (`ccc`.`real_flag` = '0'))
order by `ccc`.`task_rule_id`, `ccc`.`task_user_id`, `ccc`.`lookinto_date`;

create definer = root@`%` view wm_zb_count_20210115 as
select distinct `ccc`.`package_id`              AS `package_id`,
                `ccc`.`score_name`              AS `score_name`,
                `ccc`.`score_id`                AS `score_id`,
                `ccc`.`package_score`           AS `package_score`,
                `ccc`.`send_package_dept_id`    AS `send_package_dept_id`,
                `ccc`.`pcreate_time`            AS `pcreate_time`,
                `ccc`.`realname`                AS `realname`,
                `ccc`.`idcard`                  AS `idcard`,
                `ccc`.`phone`                   AS `phone`,
                `ccc`.`dept_name`               AS `dept_name`,
                `ccc`.`user_id`                 AS `user_id`,
                `ccc`.`task_type_name`          AS `task_type_name`,
                `ccc`.`base_id`                 AS `base_id`,
                `ccc`.`id`                      AS `id`,
                `ccc`.`task_rule_id`            AS `task_rule_id`,
                `ccc`.`score`                   AS `score`,
                `ccc`.`score_package_drug_id`   AS `score_package_drug_id`,
                `ccc`.`score_package_level1_id` AS `score_package_level1_id`,
                `ccc`.`score_package_id`        AS `score_package_id`,
                `ccc`.`task_type_id`            AS `task_type_id`,
                `ccc`.`lookinto_date`           AS `lookinto_date`,
                `ccc`.`province`                AS `province`,
                `ccc`.`city`                    AS `city`,
                `ccc`.`area`                    AS `area`,
                `ccc`.`address`                 AS `address`,
                `ccc`.`lookinto_type_id`        AS `lookinto_type_id`,
                `ccc`.`task_content_id`         AS `task_content_id`,
                `ccc`.`task_status`             AS `task_status`,
                `ccc`.`task_user_id`            AS `task_user_id`,
                `ccc`.`task_user_type`          AS `task_user_type`,
                `ccc`.`drug_ent_id`             AS `drug_ent_id`,
                `ccc`.`dept_id`                 AS `dept_id`,
                `ccc`.`del_flag`                AS `del_flag`,
                `ccc`.`enable_flag`             AS `enable_flag`,
                `ccc`.`tenant_id`               AS `tenant_id`,
                `ccc`.`lookinto_date`           AS `create_time`,
                `ccc`.`create_user`             AS `create_user`,
                `ccc`.`update_time`             AS `update_time`,
                `ccc`.`update_user`             AS `update_user`,
                `ccc`.`submit_status`           AS `submit_status`,
                `ccc`.`share_img_url`           AS `share_img_url`,
                `ccc`.`plat_audit_status`       AS `plat_audit_status`,
                `ccc`.`ext_ids`                 AS `ext_ids`,
                `ccc`.`task_info_img`           AS `task_info_img`,
                `ccc`.`t_type`                  AS `t_type`
from (select `hnqzx`.`wm_score_package`.`id`                   AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             1                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_drug_id`         AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             2                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_drug_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_level1_id`       AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             3                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_level1_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))) `ccc`
where ((`ccc`.`package_id` is not null) and (`ccc`.`task_status` = 3) and (`ccc`.`enable_flag` = 0) and
       (`ccc`.`del_flag` = 0))
order by `ccc`.`task_rule_id`, `ccc`.`task_user_id`, `ccc`.`lookinto_date`;

create definer = root@`%` view wm_zb_count_copy as
select distinct `ccc`.`package_id`              AS `package_id`,
                `ccc`.`score_name`              AS `score_name`,
                `ccc`.`score_id`                AS `score_id`,
                `ccc`.`package_score`           AS `package_score`,
                `ccc`.`send_package_dept_id`    AS `send_package_dept_id`,
                `ccc`.`pcreate_time`            AS `pcreate_time`,
                `ccc`.`realname`                AS `realname`,
                `ccc`.`idcard`                  AS `idcard`,
                `ccc`.`phone`                   AS `phone`,
                `ccc`.`dept_name`               AS `dept_name`,
                `ccc`.`user_id`                 AS `user_id`,
                `ccc`.`task_type_name`          AS `task_type_name`,
                `ccc`.`base_id`                 AS `base_id`,
                `ccc`.`id`                      AS `id`,
                `ccc`.`task_rule_id`            AS `task_rule_id`,
                `ccc`.`score`                   AS `score`,
                `ccc`.`score_package_drug_id`   AS `score_package_drug_id`,
                `ccc`.`score_package_level1_id` AS `score_package_level1_id`,
                `ccc`.`score_package_id`        AS `score_package_id`,
                `ccc`.`task_type_id`            AS `task_type_id`,
                `ccc`.`lookinto_date`           AS `lookinto_date`,
                `ccc`.`province`                AS `province`,
                `ccc`.`city`                    AS `city`,
                `ccc`.`area`                    AS `area`,
                `ccc`.`address`                 AS `address`,
                `ccc`.`lookinto_type_id`        AS `lookinto_type_id`,
                `ccc`.`task_content_id`         AS `task_content_id`,
                `ccc`.`task_status`             AS `task_status`,
                `ccc`.`task_user_id`            AS `task_user_id`,
                `ccc`.`task_user_type`          AS `task_user_type`,
                `ccc`.`drug_ent_id`             AS `drug_ent_id`,
                `ccc`.`dept_id`                 AS `dept_id`,
                `ccc`.`del_flag`                AS `del_flag`,
                `ccc`.`enable_flag`             AS `enable_flag`,
                `ccc`.`tenant_id`               AS `tenant_id`,
                `ccc`.`lookinto_date`           AS `create_time`,
                `ccc`.`create_user`             AS `create_user`,
                `ccc`.`update_time`             AS `update_time`,
                `ccc`.`update_user`             AS `update_user`,
                `ccc`.`submit_status`           AS `submit_status`,
                `ccc`.`share_img_url`           AS `share_img_url`,
                `ccc`.`plat_audit_status`       AS `plat_audit_status`,
                `ccc`.`ext_ids`                 AS `ext_ids`,
                `ccc`.`task_info_img`           AS `task_info_img`,
                `ccc`.`t_type`                  AS `t_type`
from (select `hnqzx`.`wm_score_package`.`id`                   AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             1                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_drug_id`         AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             2                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_drug_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_level1_id`       AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`wm_score_package`.`create_time`          AS `pcreate_time`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             3                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_level1_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))) `ccc`
where ((`ccc`.`package_id` is not null) and (`ccc`.`task_status` = 3) and (`ccc`.`enable_flag` = 0) and
       (`ccc`.`del_flag` = 0))
order by `ccc`.`task_rule_id`, `ccc`.`task_user_id`, `ccc`.`lookinto_date`;

create definer = root@`%` view wm_zb_count_copy1 as
select distinct `ccc`.`package_id`              AS `package_id`,
                `ccc`.`score_name`              AS `score_name`,
                `ccc`.`score_id`                AS `score_id`,
                `ccc`.`package_score`           AS `package_score`,
                `ccc`.`send_package_dept_id`    AS `send_package_dept_id`,
                `ccc`.`realname`                AS `realname`,
                `ccc`.`idcard`                  AS `idcard`,
                `ccc`.`phone`                   AS `phone`,
                `ccc`.`dept_name`               AS `dept_name`,
                `ccc`.`user_id`                 AS `user_id`,
                `ccc`.`task_type_name`          AS `task_type_name`,
                `ccc`.`base_id`                 AS `base_id`,
                `ccc`.`id`                      AS `id`,
                `ccc`.`task_rule_id`            AS `task_rule_id`,
                `ccc`.`score`                   AS `score`,
                `ccc`.`score_package_drug_id`   AS `score_package_drug_id`,
                `ccc`.`score_package_level1_id` AS `score_package_level1_id`,
                `ccc`.`score_package_id`        AS `score_package_id`,
                `ccc`.`task_type_id`            AS `task_type_id`,
                `ccc`.`lookinto_date`           AS `lookinto_date`,
                `ccc`.`province`                AS `province`,
                `ccc`.`city`                    AS `city`,
                `ccc`.`area`                    AS `area`,
                `ccc`.`address`                 AS `address`,
                `ccc`.`lookinto_type_id`        AS `lookinto_type_id`,
                `ccc`.`task_content_id`         AS `task_content_id`,
                `ccc`.`task_status`             AS `task_status`,
                `ccc`.`task_user_id`            AS `task_user_id`,
                `ccc`.`task_user_type`          AS `task_user_type`,
                `ccc`.`drug_ent_id`             AS `drug_ent_id`,
                `ccc`.`dept_id`                 AS `dept_id`,
                `ccc`.`del_flag`                AS `del_flag`,
                `ccc`.`enable_flag`             AS `enable_flag`,
                `ccc`.`tenant_id`               AS `tenant_id`,
                `ccc`.`create_time`             AS `create_time`,
                `ccc`.`create_user`             AS `create_user`,
                `ccc`.`update_time`             AS `update_time`,
                `ccc`.`update_user`             AS `update_user`,
                `ccc`.`submit_status`           AS `submit_status`,
                `ccc`.`share_img_url`           AS `share_img_url`,
                `ccc`.`plat_audit_status`       AS `plat_audit_status`,
                `ccc`.`ext_ids`                 AS `ext_ids`,
                `ccc`.`task_info_img`           AS `task_info_img`,
                `ccc`.`t_type`                  AS `t_type`
from (select `hnqzx`.`wm_score_package`.`id`                   AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`create_time`                   AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             1                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_drug_id`         AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`create_time`                   AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             2                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_drug_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))
      union
      select `hnqzx`.`wm_task`.`score_package_level1_id`       AS `package_id`,
             `hnqzx`.`wm_score_package`.`score_name`           AS `score_name`,
             `hnqzx`.`wm_score_package`.`score`                AS `package_score`,
             `hnqzx`.`wm_score_package`.`send_package_dept_id` AS `send_package_dept_id`,
             `hnqzx`.`wm_score_package`.`score_id`             AS `score_id`,
             `hnqzx`.`sys_user`.`realname`                     AS `realname`,
             `hnqzx`.`sys_user`.`temp1`                        AS `idcard`,
             `hnqzx`.`sys_user`.`phone`                        AS `phone`,
             `hnqzx`.`sys_dept`.`name`                         AS `dept_name`,
             `hnqzx`.`sys_user`.`user_id`                      AS `user_id`,
             `hnqzx`.`wm_task_type`.`task_type_name`           AS `task_type_name`,
             `hnqzx`.`wm_task_type`.`base_id`                  AS `base_id`,
             `hnqzx`.`wm_task`.`id`                            AS `id`,
             `hnqzx`.`wm_task`.`task_rule_id`                  AS `task_rule_id`,
             `hnqzx`.`wm_task`.`score`                         AS `score`,
             `hnqzx`.`wm_task`.`score_package_drug_id`         AS `score_package_drug_id`,
             `hnqzx`.`wm_task`.`score_package_level1_id`       AS `score_package_level1_id`,
             `hnqzx`.`wm_task`.`score_package_id`              AS `score_package_id`,
             `hnqzx`.`wm_task`.`task_type_id`                  AS `task_type_id`,
             `hnqzx`.`wm_task`.`lookinto_date`                 AS `lookinto_date`,
             `hnqzx`.`wm_task`.`province`                      AS `province`,
             `hnqzx`.`wm_task`.`city`                          AS `city`,
             `hnqzx`.`wm_task`.`area`                          AS `area`,
             `hnqzx`.`wm_task`.`address`                       AS `address`,
             `hnqzx`.`wm_task`.`lookinto_type_id`              AS `lookinto_type_id`,
             `hnqzx`.`wm_task`.`task_content_id`               AS `task_content_id`,
             `hnqzx`.`wm_task`.`task_status`                   AS `task_status`,
             `hnqzx`.`wm_task`.`task_user_id`                  AS `task_user_id`,
             `hnqzx`.`wm_task`.`task_user_type`                AS `task_user_type`,
             `hnqzx`.`wm_task`.`drug_ent_id`                   AS `drug_ent_id`,
             `hnqzx`.`wm_task`.`dept_id`                       AS `dept_id`,
             `hnqzx`.`wm_task`.`del_flag`                      AS `del_flag`,
             `hnqzx`.`wm_task`.`enable_flag`                   AS `enable_flag`,
             `hnqzx`.`wm_task`.`tenant_id`                     AS `tenant_id`,
             `hnqzx`.`wm_task`.`create_time`                   AS `create_time`,
             `hnqzx`.`wm_task`.`create_user`                   AS `create_user`,
             `hnqzx`.`wm_task`.`update_time`                   AS `update_time`,
             `hnqzx`.`wm_task`.`update_user`                   AS `update_user`,
             `hnqzx`.`wm_task`.`submit_status`                 AS `submit_status`,
             `hnqzx`.`wm_task`.`share_img_url`                 AS `share_img_url`,
             `hnqzx`.`wm_task`.`plat_audit_status`             AS `plat_audit_status`,
             `hnqzx`.`wm_task`.`ext_ids`                       AS `ext_ids`,
             `hnqzx`.`wm_task`.`task_info_img`                 AS `task_info_img`,
             3                                                 AS `t_type`
      from ((((`hnqzx`.`wm_task` left join `hnqzx`.`wm_score_package` on ((`hnqzx`.`wm_task`.`score_package_level1_id` =
                                                                           `hnqzx`.`wm_score_package`.`id`))) join `hnqzx`.`wm_task_type`) join `hnqzx`.`sys_user`) join `hnqzx`.`sys_dept`)
      where ((`hnqzx`.`wm_task_type`.`id` = `hnqzx`.`wm_task`.`task_type_id`) and
             (`hnqzx`.`sys_user`.`user_id` = `hnqzx`.`wm_task`.`task_user_id`) and
             (`hnqzx`.`sys_user`.`dept_id` = `hnqzx`.`sys_dept`.`dept_id`))) `ccc`
where ((`ccc`.`package_id` is not null) and (`ccc`.`task_status` = 3) and (`ccc`.`enable_flag` = 0) and
       (`ccc`.`del_flag` = 0))
order by `ccc`.`create_time` desc;