/*
================================================================================
档案代号:tna_file
档案名称:历年主会计帐别档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tna_file
(
tna00       varchar2(1) NOT NULL,    /*类别                                   */
                                     /*0.财务帐 1.管理帐                      */
tna01       number(5) NOT NULL,      /*年度                                   */
tna02       varchar2(5)              /*帐别                                   */
);

create unique index tna_pk on tna_file (tna00,tna01);
alter table tna_file add  constraint tna_pk primary key  (tna00,tna01) enable validate;
grant select on tna_file to public;
grant index on tna_file to public;
grant update on tna_file to public;
grant delete on tna_file to public;
grant insert on tna_file to public;