/*
================================================================================
档案代号:pmd_file
档案名称:供应厂商联络资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmd_file
(
pmd01       varchar2(10) NOT NULL,   /*供应厂商编号                           */
pmd02       varchar2(30) NOT NULL,   /*联络人                                 */
pmd03       varchar2(40),            /*联络电话                               */
pmd04       varchar2(255),           /*备注                                   */
pmd05       varchar2(1),             /*是否为主要联络人                       */
                                     /*若是, 则本联络人将列印于采购跟催表上   */
                                     /*一个供应厂商仅可有一个主要联络人       */
pmd06       varchar2(4) NOT NULL,    /*类别                                   */
                                     /*此类别于列印供应厂商名条时可为挑选的条件*/
pmd07       varchar2(80)             /*E-Mail address                         */
);

create unique index pmd_pk on pmd_file (pmd01,pmd02,pmd06);
alter table pmd_file add  constraint pmd_pk primary key  (pmd01,pmd02,pmd06) enable validate;
grant select on pmd_file to public;
grant index on pmd_file to public;
grant update on pmd_file to public;
grant delete on pmd_file to public;
grant insert on pmd_file to public;