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