/*
================================================================================
档案代号:azn_file
档案名称:会计期间明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table azn_file
(
azn01       date NOT NULL,           /*日期                                   */
azn02       number(5),               /*年度                                   */
azn03       number(5),               /*季别                                   */
azn04       number(5),               /*期别                                   */
azn05       number(5)                /*周别                                   */
);

create        index azn_02 on azn_file (azn02,azn04);
create unique index azn_pk on azn_file (azn01);
alter table azn_file add  constraint azn_pk primary key  (azn01) enable validate;
grant select on azn_file to public;
grant index on azn_file to public;
grant update on azn_file to public;
grant delete on azn_file to public;
grant insert on azn_file to public;