/* ================================================================================ 档案代号:pjma_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjma_file ( pjma01 varchar2(30) NOT NULL, /*本阶wbs编码 */ pjma02 number(5) NOT NULL, /*项次 */ pjma03 varchar2(10), /*设备类型 */ pjma04 number(10), /*台数 */ pjma05 number(15,3), /*需求量(使用时间) */ pjmaacti varchar2(1), /*资料有效码 */ pjmadate date, /*最近修改日 */ pjmagrup varchar2(10), /*资料所有部门 */ pjmamodu varchar2(10), /*资料修改者 */ pjmauser varchar2(10) /*资料所有者 */ ); create unique index pjma_pk on pjma_file (pjma01,pjma02); alter table pjma_file add constraint pjma_pk primary key (pjma01,pjma02) enable validate; grant select on pjma_file to public; grant index on pjma_file to public; grant update on pjma_file to public; grant delete on pjma_file to public; grant insert on pjma_file to public; |