/*
================================================================================
档案代号:poni_file
档案名称:无交期性采购单(行业别架构)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table poni_file
(
poni01      varchar2(16) DEFAULT '' NOT NULL, /*采购单号 pmm01*/
poni02      number(10) DEFAULT '0' NOT NULL, /*项次,采购单所含盖的项目编号*/
ponislk01   varchar2(16)             /*制单号                                 */
);

create unique index poni_pk on poni_file (poni01,poni02);
alter table poni_file add  constraint poni_pk primary key  (poni01,poni02) enable validate;
grant select on poni_file to public;
grant index on poni_file to public;
grant update on poni_file to public;
grant delete on poni_file to public;
grant insert on poni_file to public;