/*
================================================================================
档案代号:pmp_file
档案名称:请购/采购单重要备忘档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmp_file
(
pmp01       varchar2(16) NOT NULL,   /*请购/采购单编号                        */
                                     /*Special Note Code                      */
pmp02       varchar2(1) NOT NULL,    /*资料性质                               */
                                     /*Data Type                              */
                                     /*0:请购单                               */
                                     /*1:采购单                               */
pmp03       date NOT NULL,           /*记录日期                               */
                                     /*Date                                   */
pmp04       number(5) NOT NULL,      /*行序                                   */
                                     /*Line Sequence                          */
pmp05       varchar2(255)            /*说明                                   */
                                     /*Description                            */
);

create unique index pmp_pk on pmp_file (pmp01,pmp03,pmp02,pmp04);
alter table pmp_file add  constraint pmp_pk primary key  (pmp01,pmp03,pmp02,pmp04) enable validate;
grant select on pmp_file to public;
grant index on pmp_file to public;
grant update on pmp_file to public;
grant delete on pmp_file to public;
grant insert on pmp_file to public;