/*
================================================================================
档案代号:cxg_file
档案名称:单别成会分类设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cxg_file
(
cxg01       varchar2(5) NOT NULL,    /*单别                                   */
cxg02       varchar2(1) NOT NULL,    /*科目种类                               */
cxg03       varchar2(1) NOT NULL,    /*种类来源                               */
cxg04       varchar2(10) NOT NULL,   /*种类编号                               */
cxg05       varchar2(24),            /*科目编号                               */
cxg051      varchar2(24)             /*科目代号二                             */
);

create unique index cxg_pk on cxg_file (cxg01,cxg02,cxg03,cxg04);
alter table cxg_file add  constraint cxg_pk primary key  (cxg01,cxg02,cxg03,cxg04) enable validate;
grant select on cxg_file to public;
grant index on cxg_file to public;
grant update on cxg_file to public;
grant delete on cxg_file to public;
grant insert on cxg_file to public;