/* ================================================================================ 档案代号:ppc_file 档案名称:供应商类别设定评价权数档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ppc_file ( ppc01 varchar2(10) NOT NULL, /*厂商类别 */ ppc02 varchar2(10) NOT NULL, /*评核项目代码 */ ppc03 number(15,3) /*权数 */ ); create unique index ppc_pk on ppc_file (ppc01,ppc02); alter table ppc_file add constraint ppc_pk primary key (ppc01,ppc02) enable validate; grant select on ppc_file to public; grant index on ppc_file to public; grant update on ppc_file to public; grant delete on ppc_file to public; grant insert on ppc_file to public; |