/* ================================================================================ 档案代号: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; |