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