/*
================================================================================
档案代号:tag_file
档案名称:新旧会计科目对应关系档案
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tag_file
(
tag01       number(5) NOT NULL,      /*年度                                   */
tag02       varchar2(5) NOT NULL,    /*旧帐别                                 */
tag03       varchar2(24) NOT NULL,   /*旧会计科目                             */
tag04       varchar2(5),             /*新帐别                                 */
tag05       varchar2(24)             /*新会计科目                             */
);

create unique index tag_pk on tag_file (tag01,tag02,tag03);
alter table tag_file add  constraint tag_pk primary key  (tag01,tag02,tag03) enable validate;
grant select on tag_file to public;
grant index on tag_file to public;
grant update on tag_file to public;
grant delete on tag_file to public;
grant insert on tag_file to public;