/* ================================================================================ 档案代号:pnbi_file 档案名称:采购单变更单 档案目的:采购单变更单(行业别架构) 上游档案: 下游档案: ============.========================.========================================== */ create table pnbi_file ( pnbi01 varchar2(16) DEFAULT '' NOT NULL, /*采购单号*/ pnbi02 number(5) DEFAULT '0' NOT NULL, /*变更序号*/ pnbi03 number(10) DEFAULT '0' NOT NULL, /*采购单项次*/ pnbislk01 varchar2(16) /*制单号 */ ); create unique index pnbi_pk on pnbi_file (pnbi01,pnbi02,pnbi03); alter table pnbi_file add constraint pnbi_pk primary key (pnbi01,pnbi02,pnbi03) enable validate; grant select on pnbi_file to public; grant index on pnbi_file to public; grant update on pnbi_file to public; grant delete on pnbi_file to public; grant insert on pnbi_file to public; |