/* ================================================================================ 档案代号:aax_file 档案名称:帐别部门管制档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aax_file ( aax01 varchar2(5) NOT NULL, /*帐别 */ aax02 varchar2(10) NOT NULL, /*部门代码 */ aax03 varchar2(1) /*no use */ ); create unique index aax_pk on aax_file (aax01,aax02); alter table aax_file add constraint aax_pk primary key (aax01,aax02) enable validate; grant select on aax_file to public; grant index on aax_file to public; grant update on aax_file to public; grant delete on aax_file to public; grant insert on aax_file to public; |