/*
================================================================================
档案代号:aznn_file
档案名称:帐别会计期间明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aznn_file
(
aznn00      varchar2(5) NOT NULL,    /*帐别                                   */
aznn01      date NOT NULL,           /*日期                                   */
aznn02      number(5),               /*年度                                   */
                                     /*1-12期,2-13期                          */
aznn03      number(5),               /*季别                                   */
aznn04      number(5),               /*期别                                   */
aznn05      number(5)                /*周别                                   */
);

create        index aznn_02 on aznn_file (aznn02,aznn04);
create unique index aznn_pk on aznn_file (aznn00,aznn01);
alter table aznn_file add  constraint aznn_pk primary key  (aznn00,aznn01) enable validate;
grant select on aznn_file to public;
grant index on aznn_file to public;
grant update on aznn_file to public;
grant delete on aznn_file to public;
grant insert on aznn_file to public;