/* ================================================================================ 档案代号:apx_file 档案名称:还款记录明细档 档案目的: 储存还款记录档 上游档案: 下游档案: ============.========================.========================================== */ create table apx_file ( apx01 varchar2(16) NOT NULL, /*帐款编号 */ apx02 number(5) NOT NULL, /*项次 */ apx03 varchar2(16), /*借款待抵 */ apx04f number(20,6) NOT NULL, /*原币还款金额 */ apx04 number(20,6) NOT NULL /*本币还款金额 */ ); create index apx_02 on apx_file (apx03); create unique index apx_pk on apx_file (apx01,apx02); alter table apx_file add constraint apx_pk primary key (apx01,apx02) enable validate; grant select on apx_file to public; grant index on apx_file to public; grant update on apx_file to public; grant delete on apx_file to public; grant insert on apx_file to public; |