/*
================================================================================
档案代号:pjd_file
档案名称:wbs累计预计费用档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjd_file
(
pjd01       varchar2(30) NOT NULL,   /*wbs编码                                */
pjd02       varchar2(10) NOT NULL,   /*费用代号                               */
pjd03       varchar2(24) NOT NULL,   /*科目一                                 */
pjd04       varchar2(24) NOT NULL,   /*科目二                                 */
pjd05       number(20,6)             /*预估金额                               */
);

create unique index pjd_pk on pjd_file (pjd01,pjd02,pjd03,pjd04);
alter table pjd_file add  constraint pjd_pk primary key  (pjd01,pjd02,pjd03,pjd04) enable validate;
grant select on pjd_file to public;
grant index on pjd_file to public;
grant update on pjd_file to public;
grant delete on pjd_file to public;
grant insert on pjd_file to public;