/*
================================================================================
档案代号:pmg_file
档案名称:供应厂商重要备注资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmg_file
(
pmg01       varchar2(10) NOT NULL,   /*供应厂商编号                           */
pmg02       number(5) NOT NULL,      /*行序号                                 */
pmg03       varchar2(255)            /*重要备注                               */
);

create unique index pmg_pk on pmg_file (pmg01,pmg02);
alter table pmg_file add  constraint pmg_pk primary key  (pmg01,pmg02) enable validate;
grant select on pmg_file to public;
grant index on pmg_file to public;
grant update on pmg_file to public;
grant delete on pmg_file to public;
grant insert on pmg_file to public;