/*
================================================================================
档案代号: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;