/*
================================================================================
档案代号:pmr_file
档案名称:核价单-分量计价资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmr_file
(
pmr01       varchar2(16) NOT NULL,   /*核价单号                               */
pmr02       number(5) NOT NULL,      /*项次                                   */
pmr03       number(15,3) NOT NULL,   /*启始数量                               */
pmr04       number(15,3) NOT NULL,   /*截止数量                               */
pmr05       number(20,6),            /*未税单价                               */
                                     /*单价                                   */
pmr05t      number(20,6)             /*含税单价                               */
);

create unique index pmr_pk on pmr_file (pmr01,pmr02,pmr03,pmr04);
alter table pmr_file add  constraint pmr_pk primary key  (pmr01,pmr02,pmr03,pmr04) enable validate;
grant select on pmr_file to public;
grant index on pmr_file to public;
grant update on pmr_file to public;
grant delete on pmr_file to public;
grant insert on pmr_file to public;