/* ================================================================================ 档案代号:pnni_file 档案名称:采购分配底稿档 档案目的:采购分配底稿档(行业别架构) 上游档案: 下游档案: ============.========================.========================================== */ create table pnni_file ( pnni01 varchar2(16) DEFAULT '' NOT NULL, /*请购单号*/ pnni02 number(10) DEFAULT '0' NOT NULL, /*请购项次*/ pnni03 varchar2(40) DEFAULT '' NOT NULL, /*料件编号*/ pnni05 varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/ pnni06 varchar2(4) DEFAULT '' NOT NULL, /*币别*/ pnnislk01 varchar2(16) /*制单号 */ ); create unique index pnni_pk on pnni_file (pnni01,pnni02,pnni03,pnni05,pnni06); alter table pnni_file add constraint pnni_pk primary key (pnni01,pnni02,pnni03,pnni05,pnni06) enable validate; grant select on pnni_file to public; grant index on pnni_file to public; grant update on pnni_file to public; grant delete on pnni_file to public; grant insert on pnni_file to public; |