/* ================================================================================ 档案代号:axr_file 档案名称:合并报表历史汇率档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table axr_file ( axr01 varchar2(10) NOT NULL, /*族群代码 */ axr02 varchar2(10) NOT NULL, /*公司编号 */ axr03 varchar2(24) NOT NULL, /*科目编号 */ axr04 varchar2(4), /*记帐币别 */ axr05 number(20,6), /*记帐币别金额 */ axr06 date, /*No Use */ axr07 varchar2(24) NOT NULL, /*来源科目 */ axr08 number(5) NOT NULL, /*历史年度 */ axr09 number(5) NOT NULL, /*历史期别 */ axr10 number(5) NOT NULL, /*异动年度 */ axr11 number(5) NOT NULL /*异动期别 */ ); create unique index axr_pk on axr_file (axr01,axr02,axr03,axr07,axr08,axr09,axr10,axr11); alter table axr_file add constraint axr_pk primary key (axr01,axr02,axr03,axr07,axr08,axr09,axr10,axr11) enable validate; grant select on axr_file to public; grant index on axr_file to public; grant update on axr_file to public; grant delete on axr_file to public; grant insert on axr_file to public; |