/* ================================================================================ 档案代号:ppe_file 档案名称:成本交期品质评价分数档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ppe_file ( ppe01 varchar2(6) NOT NULL, /*年月 */ ppe02 varchar2(10) NOT NULL, /*厂商编号 */ ppe03 varchar2(10) NOT NULL, /*评核项目 */ ppe04 number(8,4), /*分数 */ ppe05 number(15,3), /*加权 */ ppe06 number(15,3), /*加权后分数 */ ppe07 number(15,3), /*修正后分数 */ ppedate date, /*最近修改日 */ ppegrup varchar2(10), /*资料所有部门 */ ppemodu varchar2(10), /*资料修改者 */ ppeuser varchar2(10) /*资料所有者 */ ); create unique index ppe_pk on ppe_file (ppe01,ppe02,ppe03); alter table ppe_file add constraint ppe_pk primary key (ppe01,ppe02,ppe03) enable validate; grant select on ppe_file to public; grant index on ppe_file to public; grant update on ppe_file to public; grant delete on ppe_file to public; grant insert on ppe_file to public; |