/* ================================================================================ 档案代号:aaf_file 档案名称:帐别名称档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aaf_file ( aaf01 varchar2(5) NOT NULL, /*帐别编号 */ aaf02 varchar2(1) NOT NULL, /*语言别 */ aaf03 varchar2(80) /*名称 */ ); create unique index aaf_pk on aaf_file (aaf01,aaf02); alter table aaf_file add constraint aaf_pk primary key (aaf01,aaf02) enable validate; grant select on aaf_file to public; grant index on aaf_file to public; grant update on aaf_file to public; grant delete on aaf_file to public; grant insert on aaf_file to public; |