/*
================================================================================
档案代号:wss_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wss_file
(
wss01       varchar2(40) DEFAULT '' NOT NULL, /*服务代码*/
wss02       varchar2(1) DEFAULT '' NOT NULL, /*存取模式*/
wss03       varchar2(20) DEFAULT '' NOT NULL, /*他系统代码*/
wss04       varchar2(20) DEFAULT '' NOT NULL, /*erp 栏位名称*/
wss05       varchar2(30),            /*栏位预设值                             */
wss06       varchar2(30)             /*他系统栏位名称                         */
);

create        index wss_02 on wss_file (wss01,wss02,wss03,wss06);
create unique index wss_pk on wss_file (wss01,wss02,wss03,wss04);
alter table wss_file add  constraint wss_pk primary key  (wss01,wss02,wss03,wss04) enable validate;
grant select on wss_file to public;
grant index on wss_file to public;
grant update on wss_file to public;
grant delete on wss_file to public;
grant insert on wss_file to public;