/*
================================================================================
档案代号:wso_file
档案名称:ERP 服务与他系统间栏位对应关系单身档
档案目的:提供建立呼叫 erp 服务建立资料时, 他系统与 erp 栏位的对应关系
上游档案:
下游档案:
============.========================.==========================================
*/
create table wso_file
(
wso01       varchar2(80) NOT NULL,   /*服务代码                               */
wso02       varchar2(15) NOT NULL,   /*table 名称                             */
wso03       varchar2(15) NOT NULL,   /*他系统代码                             */
wso04       varchar2(20) NOT NULL,   /*erp 栏位名称                           */
wso05       varchar2(30) NOT NULL    /*他系统栏位名称                         */
);

create        index wso_02 on wso_file (wso01,wso02,wso05);
create        index wso_03 on wso_file (wso01,wso02,wso04);
create unique index wso_pk on wso_file (wso01,wso02,wso03,wso04);
alter table wso_file add  constraint wso_pk primary key  (wso01,wso02,wso03,wso04) enable validate;
grant select on wso_file to public;
grant index on wso_file to public;
grant update on wso_file to public;
grant delete on wso_file to public;
grant insert on wso_file to public;