/*
================================================================================
档案代号:wst_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wst_file
(
wst01       varchar2(40) DEFAULT '' NOT NULL, /*服务代码*/
wst02       varchar2(1) DEFAULT '' NOT NULL, /*存取模式*/
wst03       varchar2(20) DEFAULT '' NOT NULL, /*他系统代码*/
wst04       varchar2(20) DEFAULT '' NOT NULL, /*erp 栏位名称*/
wst05       varchar2(30) DEFAULT '' NOT NULL, /*erp 栏位内容*/
wst06       varchar2(30) DEFAULT '' NOT NULL /*他系统转换值*/
);

create unique index wst_pk on wst_file (wst01,wst02,wst03,wst04,wst05);
alter table wst_file add  constraint wst_pk primary key  (wst01,wst02,wst03,wst04,wst05) enable validate;
grant select on wst_file to public;
grant index on wst_file to public;
grant update on wst_file to public;
grant delete on wst_file to public;
grant insert on wst_file to public;