/*
================================================================================
档案代号:pje_file
档案名称:工作项目名称档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pje_file
(
pje01       varchar2(10) NOT NULL,   /*工作项目                               */
pje02       varchar2(80),            /*工作名称                               */
pjeacti     varchar2(1),             /*资料有效码                             */
pjeuser     varchar2(10),            /*资料所有者                             */
pjegrup     varchar2(10),            /*资料所有部门                           */
pjemodu     varchar2(10),            /*资料修改者                             */
pjedate     date                     /*最近修改日                             */
);

create unique index pje_pk on pje_file (pje01);
alter table pje_file add  constraint pje_pk primary key  (pje01) enable validate;
grant select on pje_file to public;
grant index on pje_file to public;
grant update on pje_file to public;
grant delete on pje_file to public;
grant insert on pje_file to public;