/* ================================================================================ 档案代号:pjq_file 档案名称:专案分类档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjq_file ( pjq01 varchar2(4) NOT NULL, /*分类编号 */ pjq02 varchar2(80), /*分类名称 */ pjqacti varchar2(1), /*资料有效码 */ pjqdate date, /*最近修改日 */ pjqgrup varchar2(10), /*资料所有部门 */ pjqmodu varchar2(10), /*资料修改者 */ pjquser varchar2(10) /*资料所有者 */ ); create unique index pjq_pk on pjq_file (pjq01); alter table pjq_file add constraint pjq_pk primary key (pjq01) enable validate; grant select on pjq_file to public; grant index on pjq_file to public; grant update on pjq_file to public; grant delete on pjq_file to public; grant insert on pjq_file to public; |