/* ================================================================================ 档案代号:ppd_file 档案名称:供应商自定义项目评分档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ppd_file ( ppd01 varchar2(6) NOT NULL, /*评核年月 */ ppd02 varchar2(10) NOT NULL, /*厂商代码 */ ppd03 varchar2(10) NOT NULL, /*评核项目代码 */ ppd04 number(8,4) /*分数 */ ); create unique index ppd_pk on ppd_file (ppd01,ppd02,ppd03); alter table ppd_file add constraint ppd_pk primary key (ppd01,ppd02,ppd03) enable validate; grant select on ppd_file to public; grant index on ppd_file to public; grant update on ppd_file to public; grant delete on ppd_file to public; grant insert on ppd_file to public; |