/*
================================================================================
档案代号:wsu_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wsu_file
(
wsu01       varchar2(20) DEFAULT '' NOT NULL, /*他系统代码*/
wsu02       varchar2(10) DEFAULT '' NOT NULL, /*对应营运中心代号*/
wsu03       varchar2(20) DEFAULT '' NOT NULL, /*他系统站台 ip 位址*/
wsu04       varchar2(255) DEFAULT '' NOT NULL, /*他系统 soap services 连接网址*/
wsu05       varchar2(20) DEFAULT '' NOT NULL /*他系统站台名称*/
);

create unique index wsu_pk on wsu_file (wsu01,wsu02);
alter table wsu_file add  constraint wsu_pk primary key  (wsu01,wsu02) enable validate;
grant select on wsu_file to public;
grant index on wsu_file to public;
grant update on wsu_file to public;
grant delete on wsu_file to public;
grant insert on wsu_file to public;