/* ================================================================================ 档案代号:gch_file 档案名称:V-Point Express 资料库详细设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gch_file ( gch01 varchar2(10) NOT NULL, /*TIPTOP 营运中心 */ gch02 varchar2(1) NOT NULL, /*Express 站台设定 */ gch03 varchar2(15) NOT NULL, /*Express 站台 IP 位址 */ gch04 varchar2(10) NOT NULL, /*Express 站台名称 */ gch05 varchar2(1) NOT NULL, /*Express 资料库 */ gch06 varchar2(15) NOT NULL, /*V-Point Express 站台资料库 */ gch07 varchar2(6) NOT NULL, /*V-Point Express 资料库 IP */ gch08 varchar2(10) NOT NULL, /*V-Point Express 资料库 Port */ gch09 varchar2(20) NOT NULL, /*V-Point Express 资料库名称/SID */ gch10 varchar2(20) NOT NULL, /*V-Point Express 资料库密码 */ gch11 varchar2(255), /*Express SOAP Services 连接网址 */ gch12 varchar2(20), /*Express 系统帐号 */ gch13 varchar2(20) /*Express 系统密码 */ ); create unique index gch_pk on gch_file (gch01,gch02,gch03,gch04,gch05,gch06,gch07,gch08,gch09,gch10); alter table gch_file add constraint gch_pk primary key (gch01,gch02,gch03,gch04,gch05,gch06,gch07,gch08,gch09,gch10) enable validate; grant select on gch_file to public; grant index on gch_file to public; grant update on gch_file to public; grant delete on gch_file to public; grant insert on gch_file to public; |