/* ================================================================================ 档案代号:pnc_file 档案名称:收货替代群组档 档案目的:收货替代群组档 假双档 上游档案: 下游档案: ============.========================.========================================== */ create table pnc_file ( pnc01 varchar2(40) DEFAULT '' NOT NULL, /*料号,放单头*/ pnc02 varchar2(10) DEFAULT '' NOT NULL, /*供应商,*号代表不区分供应商, */ pnc03 varchar2(40) DEFAULT '' NOT NULL, /*可替代料号,放单身*/ pnc04 date DEFAULT sysdate NOT NULL, /*生效日期,放单身*/ pnc05 date /*失效日期,放单身 */ ); create unique index pnc_pk on pnc_file (pnc01,pnc02,pnc03,pnc04); alter table pnc_file add constraint pnc_pk primary key (pnc01,pnc02,pnc03,pnc04) enable validate; grant select on pnc_file to public; grant index on pnc_file to public; grant update on pnc_file to public; grant delete on pnc_file to public; grant insert on pnc_file to public; |