/*
================================================================================
档案代号:pnp_file
档案名称:关系人可冲销之客户编号
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pnp_file
(
pnp01       varchar2(10) NOT NULL,   /*厂商号码                               */
pnp02       varchar2(10) NOT NULL,   /*营运中心编号                           */
pnp03       varchar2(10) NOT NULL,   /*客户编号                               */
pnp04       varchar2(1),             /*No Use                                 */
pnp05       varchar2(1),             /*No Use                                 */
pnpacti     varchar2(1),             /*资料有效码                             */
pnpuser     varchar2(10),            /*资料所有者                             */
pnpgrup     varchar2(10),            /*资料所有部门                           */
pnpmodu     varchar2(10),            /*资料修改者                             */
pnpdate     date                     /*最近修改日                             */
);

create unique index pnp_pk on pnp_file (pnp01,pnp02,pnp03);
alter table pnp_file add  constraint pnp_pk primary key  (pnp01,pnp02,pnp03) enable validate;
grant select on pnp_file to public;
grant index on pnp_file to public;
grant update on pnp_file to public;
grant delete on pnp_file to public;
grant insert on pnp_file to public;