/*
================================================================================
档案代号:pnd_file
档案名称:采购变更单备注档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pnd_file
(
pnd01       varchar2(16) NOT NULL,   /*采购单号                               */
pnd02       number(5) NOT NULL,      /*变更序号                               */
pnd03       number(5) NOT NULL,      /*行序                                   */
pnd04       varchar2(255)            /*备注说明                               */
);

create unique index pnd_pk on pnd_file (pnd01,pnd02,pnd03);
alter table pnd_file add  constraint pnd_pk primary key  (pnd01,pnd02,pnd03) enable validate;
grant select on pnd_file to public;
grant index on pnd_file to public;
grant update on pnd_file to public;
grant delete on pnd_file to public;
grant insert on pnd_file to public;