/*
================================================================================
档案代号:poe_file
档案名称:客户产品接单流程档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table poe_file
(
poe01       varchar2(10) NOT NULL,   /*客户编号                               */
poe02       varchar2(10) NOT NULL,   /*产品分类码                             */
poe03       varchar2(40) NOT NULL,   /*产品编号                               */
poe04       varchar2(8),             /*内部流程代码                           */
poe05       varchar2(5),             /*预设采购单单别                         */
poeacti     varchar2(1),             /*资料有效码                             */
poeuser     varchar2(10),            /*资料所有者                             */
poegrup     varchar2(10),            /*资料所有群                             */
poemodu     varchar2(10),            /*资料更改者                             */
poedate     date                     /*最近修改日                             */
);

create unique index poe_pk on poe_file (poe01,poe02,poe03);
alter table poe_file add  constraint poe_pk primary key  (poe01,poe02,poe03) enable validate;
grant select on poe_file to public;
grant index on poe_file to public;
grant update on poe_file to public;
grant delete on poe_file to public;
grant insert on poe_file to public;