/* ================================================================================ 档案代号:wge_file 档案名称:GPM整合站台设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table wge_file ( wge01 varchar2(1) NOT NULL, /*站台分类 */ wge02 varchar2(15) NOT NULL, /*gpm站台ip位址 */ wge03 varchar2(255) NOT NULL, /*gpm soap网址 */ wge04 varchar2(20) NOT NULL, /*gpm站台名称(资料库名称) */ wge05 varchar2(20) NOT NULL, /*对应程式代号, 标准站台以'*' */ wge06 varchar2(10) NOT NULL, /*对应营运中心代号 */ wge07 varchar2(5) NOT NULL, /*对应单别代号 */ wge08 varchar2(255) NOT NULL, /*gpm www网址 */ wge09 varchar2(10), /*no use */ wge10 varchar2(10) /*no use */ ); create unique index wge_pk on wge_file (wge01,wge05,wge06,wge07); alter table wge_file add constraint wge_pk primary key (wge01,wge05,wge06,wge07) enable validate; grant select on wge_file to public; grant index on wge_file to public; grant update on wge_file to public; grant delete on wge_file to public; grant insert on wge_file to public; |