/* ================================================================================ 档案代号: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; |