/*
================================================================================
档案代号:pjg_file
档案名称:费用代号名称档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjg_file
(
pjg01       varchar2(10) NOT NULL,   /*费用代号                               */
pjg02       varchar2(80),            /*费用名称                               */
pjg03       varchar2(24),            /*预设会计科目一                         */
pjg04       varchar2(24),            /*预设会计科目二                         */
pjg05       varchar2(1),             /*费用性质                               */
pjgacti     varchar2(1),             /*资料有效码                             */
pjgdate     date,                    /*最近修改日                             */
pjggrup     varchar2(10),            /*资料所有部门                           */
pjgmodu     varchar2(10),            /*资料修改者                             */
pjguser     varchar2(10)             /*资料所有者                             */
);

create unique index pjg_pk on pjg_file (pjg01);
alter table pjg_file add  constraint pjg_pk primary key  (pjg01) enable validate;
grant select on pjg_file to public;
grant index on pjg_file to public;
grant update on pjg_file to public;
grant delete on pjg_file to public;
grant insert on pjg_file to public;