| 1234567891011121314151617181920212223242526272829303132333435363738 |
- 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';
|
