/* ================================================================================ 档案代号:axx_file 档案名称:合并报表关系人递延项摊销明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table axx_file ( axx01 varchar2(5), /*年度 */ axx02 varchar2(5), /*期别 */ axx03 varchar2(10), /*族群代号 */ axx04 varchar2(5), /*项次 */ axx05 number(5), /*摊销年度 */ axx06 number(5), /*摊销期别 */ axx07 number(20,6), /*本期摊销金额 */ axx08 number(20,6), /*本期摊销合并币别金额 */ axx031 varchar2(10) /*上层公司 */ ); create unique index axx_pk on axx_file (axx01,axx02,axx03,axx031,axx04,axx05,axx06); grant select on axx_file to public; grant index on axx_file to public; grant update on axx_file to public; grant delete on axx_file to public; grant insert on axx_file to public; |