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