/* ================================================================================ 档案代号:wsp_file 档案名称:ERP 参考栏位设定档 档案目的:提供呼叫erp服务取得参考栏位资料 上游档案: 下游档案: ============.========================.========================================== */ create table wsp_file ( wsp01 varchar2(80) NOT NULL, /*服务代码 */ wsp02 varchar2(15) NOT NULL, /*table名称 */ wsp03 varchar2(15) NOT NULL, /*他系统代码 */ wsp04 varchar2(20) NOT NULL, /*erp栏位名称 */ wsp05 varchar2(255) NOT NULL /*参考栏位sql指令 */ ); create unique index wsp_pk on wsp_file (wsp01,wsp02,wsp03,wsp04); alter table wsp_file add constraint wsp_pk primary key (wsp01,wsp02,wsp03,wsp04) enable validate; grant select on wsp_file to public; grant index on wsp_file to public; grant update on wsp_file to public; grant delete on wsp_file to public; grant insert on wsp_file to public; |