/*
================================================================================
档案代号:pnbi_file
档案名称:采购单变更单
档案目的:采购单变更单(行业别架构)
上游档案:
下游档案:
============.========================.==========================================
*/
create table pnbi_file
(
pnbi01      varchar2(16) DEFAULT '' NOT NULL, /*采购单号*/
pnbi02      number(5) DEFAULT '0' NOT NULL, /*变更序号*/
pnbi03      number(10) DEFAULT '0' NOT NULL, /*采购单项次*/
pnbislk01   varchar2(16)             /*制单号                                 */
);

create unique index pnbi_pk on pnbi_file (pnbi01,pnbi02,pnbi03);
alter table pnbi_file add  constraint pnbi_pk primary key  (pnbi01,pnbi02,pnbi03) enable validate;
grant select on pnbi_file to public;
grant index on pnbi_file to public;
grant update on pnbi_file to public;
grant delete on pnbi_file to public;
grant insert on pnbi_file to public;