/* ================================================================================ 档案代号:aeg_file 档案名称:专案别分类帐档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aeg_file ( aeg00 varchar2(5), /*帐别 */ aeg01 varchar2(24), /*科目编号 */ aeg02 date, /*传票日期 */ aeg03 varchar2(16), /*传票编号 */ aeg04 number(5), /*项次 */ aeg05 varchar2(10) /*专案编号 */ ); create index aeg_01 on aeg_file (aeg01,aeg05,aeg02); create index aeg_02 on aeg_file (aeg05,aeg01,aeg02); create index aeg_03 on aeg_file (aeg03,aeg04); grant select on aeg_file to public; grant index on aeg_file to public; grant update on aeg_file to public; grant delete on aeg_file to public; grant insert on aeg_file to public; |