create table oa_supplier
(
    id                 varchar(100)   not null comment '主键'
        primary key,
    supplier_name      varchar(255)   null comment '供应商名称',
    supplier_code      varchar(255)   null comment '统一社会信用代码',
    enterprise_type    varchar(255)   null comment '企业类型（字典enterprise_type）',
    is_head            varchar(10)    null comment '是否总部（0是1否）',
    is_in_out          varchar(10)    null comment '是否进出口（0是1否）',
    is_foreign         varchar(10)    null comment '是否外资',
    supplier_industry  varchar(255)   null comment '行业分类（字典Industry）',
    dept_id            varchar(100)   null comment '涉及部门id',
    supplier_file      text           null comment '供应商附件',
    registered_capital decimal(18, 6) null comment '注册资金',
    registered_time    datetime       null comment '注册时间',
    business_scope     text           null comment '产品/服务内容（经营范围）',
    contact_user       varchar(255)   null comment '联系人',
    contact_mobile     varchar(255)   null comment '手机号',
    contact_phone      varchar(255)   null comment '固定电话',
    contact_fax        varchar(255)   null comment '传真号',
    contact_email      varchar(255)   null comment '邮箱',
    contact_wechat     varchar(255)   null comment '微信号',
    supplier_address   varchar(255)   null comment '供应商地址',
    supplier_status   varchar(10)   null comment '供应商状态（0启用1禁用）',
    create_user        varchar(100)   null comment '创建人',
    create_time        datetime       null comment '创建时间',
    update_user        varchar(100)   null comment '更新人',
    update_time        datetime       null comment '更新时间',
    group_id           varchar(100)   null comment '集团id'
)
    comment '供应商信息';

INSERT INTO sys_dict (id, dict_name, dict_code, dict_value, sys_id) VALUES ('1090634412787236864', '供应商-行业分类', 'Industry', '[{"id":1680069075886,"label":"代理服务","value":"1","isSearch":false},{"id":1680069087792,"label":"软件产品","value":"2","isSearch":false},{"id":1680069088032,"label":"硬件产品","value":"3","isSearch":false}]', 'BIZ_OA');
INSERT INTO sys_dict (id, dict_name, dict_code, dict_value, sys_id) VALUES ('1090636203318837248', '供应商-企业类型', 'enterprise_type', '[{"id":1680069382528,"label":"国有企业","value":"1","isSearch":false},{"id":1680069407357,"label":"集体所有制企业","value":"2","isSearch":false},{"id":1680069407513,"label":"私营企业","value":"3","isSearch":false},{"id":1680069407668,"label":"股份制企业","value":"4","isSearch":false},{"id":1680069407819,"label":"有限合伙企业","value":"5","isSearch":false},{"id":1680069407943,"label":"联营企业","value":"6","isSearch":false},{"id":1680069470831,"label":"外商投资企业","value":"7","isSearch":false},{"id":1680069471004,"label":"个人独资企业","value":"8","isSearch":false},{"id":1680069471176,"label":"涉外企业(港澳台)","value":"9","isSearch":false},{"id":1680069497070,"label":"股份合作企业","value":"10","isSearch":false}]', 'BIZ_OA');

alter table out_order_main add supplier_id varchar(100) null comment '供应商id';

alter table oa_budget_making add template_id varchar(100) null comment '预算模板id';