/*
================================================================================
档案代号:pmf_file
档案名称:供应厂商往来银行资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmf_file
(
pmf01       varchar2(10) NOT NULL,   /*供应厂商编号                           */
pmf02       varchar2(11) NOT NULL,   /*银行代号                               */
pmf03       varchar2(30) NOT NULL,   /*银行帐号                               */
pmfacti     varchar2(1),             /*资料有效码                             */
pmf04       varchar2(80),            /*帐号名称                               */
pmf05       varchar2(1)              /*是否主要帐号                           */
);

create unique index pmf_pk on pmf_file (pmf01,pmf02,pmf03);
alter table pmf_file add  constraint pmf_pk primary key  (pmf01,pmf02,pmf03) enable validate;
grant select on pmf_file to public;
grant index on pmf_file to public;
grant update on pmf_file to public;
grant delete on pmf_file to public;
grant insert on pmf_file to public;