/*
================================================================================
档案代号:pjp_file
档案名称:专案多阶段收付款明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjp_file
(
pjp01       varchar2(10) NOT NULL,   /*专案代号                               */
pjp02       varchar2(1) NOT NULL,    /*收/付款                                */
pjp03       varchar2(4) NOT NULL,    /*阶段代号                               */
pjp04       varchar2(1),             /*收/付款方式                            */
pjp05       date,                    /*预估收付款日                           */
pjp06       varchar2(4),             /*里程碑代号                             */
pjp07       varchar2(1),             /*账款方式                               */
pjp08       number(20,6),            /*比例/金额                              */
pjp09       varchar2(255)            /*备注                                   */
);

create unique index pjp_pk on pjp_file (pjp01,pjp02,pjp03);
alter table pjp_file add  constraint pjp_pk primary key  (pjp01,pjp02,pjp03) enable validate;
grant select on pjp_file to public;
grant index on pjp_file to public;
grant update on pjp_file to public;
grant delete on pjp_file to public;
grant insert on pjp_file to public;