/* ================================================================================ 档案代号: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; |