/*
================================================================================
档案代号:pjda_file
档案名称:wbs本阶预计费用档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjda_file
(
pjda01      varchar2(30) NOT NULL,   /*本阶wbs编码                            */
pjda02      varchar2(10) NOT NULL,   /*费用代号                               */
pjda03      varchar2(24),            /*科目一                                 */
pjda04      varchar2(24),            /*科目二                                 */
pjda05      number(20,6),            /*预估金额(专案币别)                     */
pjdaacti    varchar2(1),             /*资料有效码                             */
pjdadate    date,                    /*最近修改日                             */
pjdagrup    varchar2(10),            /*资料所有部门                           */
pjdamodu    varchar2(10),            /*资料修改者                             */
pjdauser    varchar2(10)             /*资料所有者                             */
);

create unique index pjda_pk on pjda_file (pjda01,pjda02);
alter table pjda_file add  constraint pjda_pk primary key  (pjda01,pjda02) enable validate;
grant select on pjda_file to public;
grant index on pjda_file to public;
grant update on pjda_file to public;
grant delete on pjda_file to public;
grant insert on pjda_file to public;