/* ================================================================================ 档案代号:azk_file 档案名称:币别每日汇率档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table azk_file ( azk01 varchar2(4) NOT NULL, /*币别代码 */ azk02 date NOT NULL, /*日期 */ /*日期 (当日期='99/12/31'时,表示最近汇率)*/ azk03 number(20,10), /*银行买入汇率 */ azk04 number(20,10), /*银行卖出汇率 */ azk041 number(20,10), /*银行中价汇率 */ azk05 number(20,10), /*海关旬 汇率 */ azk051 number(20,10), /*海关买入汇率 */ azk052 number(20,10) /*海关卖出汇率 */ ); create unique index azk_pk on azk_file (azk02,azk01); alter table azk_file add constraint azk_pk primary key (azk02,azk01) enable validate; grant select on azk_file to public; grant index on azk_file to public; grant update on azk_file to public; grant delete on azk_file to public; grant insert on azk_file to public; |