/*
================================================================================
档案代号:pjo_file
档案名称:专案多阶段收付款主档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjo_file
(
pjo01       varchar2(10) NOT NULL,   /*专案代号                               */
pjo02       varchar2(1) NOT NULL,    /*收/付款                                */
pjoacti     varchar2(1),             /*资料有效码                             */
pjoconf     varchar2(1),             /*确认码                                 */
pjodate     date,                    /*最近修改日                             */
pjogrup     varchar2(10),            /*资料所有部门                           */
pjomodu     varchar2(10),            /*资料修改者                             */
pjouser     varchar2(10)             /*资料所有者                             */
);

create unique index pjo_pk on pjo_file (pjo01,pjo02);
alter table pjo_file add  constraint pjo_pk primary key  (pjo01,pjo02) enable validate;
grant select on pjo_file to public;
grant index on pjo_file to public;
grant update on pjo_file to public;
grant delete on pjo_file to public;
grant insert on pjo_file to public;