/*
================================================================================
档案代号:pjdb_file
档案名称:专案活动预计费用档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjdb_file
(
pjdb01      varchar2(10) NOT NULL,   /*网络代号                               */
pjdb02      varchar2(4) NOT NULL,    /*活动代号                               */
pjdb03      varchar2(10) NOT NULL,   /*费用代号                               */
pjdb04      varchar2(24),            /*科目一                                 */
pjdb05      varchar2(24),            /*科目二                                 */
pjdb06      number(20,6),            /*预估金额                               */
pjdbacti    varchar2(1),             /*资料有效码                             */
pjdbdate    date,                    /*最近修改日                             */
pjdbgrup    varchar2(10),            /*资料所有部门                           */
pjdbmodu    varchar2(10),            /*资料修改者                             */
pjdbuser    varchar2(10)             /*资料所有者                             */
);

create unique index pjdb_pk on pjdb_file (pjdb01,pjdb02,pjdb03);
alter table pjdb_file add  constraint pjdb_pk primary key  (pjdb01,pjdb02,pjdb03) enable validate;
grant select on pjdb_file to public;
grant index on pjdb_file to public;
grant update on pjdb_file to public;
grant delete on pjdb_file to public;
grant insert on pjdb_file to public;