/* ================================================================================ 档案代号:pmu_file 档案名称:一般料号收货替代原则档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmu_file ( pmu01 varchar2(40) DEFAULT '' NOT NULL, /*料号*/ pmu02 varchar2(10) DEFAULT '' NOT NULL, /*供应商,*号代表不区分供应商, */ pmu03 number(5) DEFAULT '0' NOT NULL, /*起始码*/ pmu04 number(5) DEFAULT '0' NOT NULL, /*截至码*/ pmu05 varchar2(10) DEFAULT '' NOT NULL, /*原值*/ pmu06 varchar2(10) DEFAULT '' NOT NULL, /*替代值*/ pmu07 date DEFAULT sysdate NOT NULL, /*生效日期*/ pmu08 date /*失效日期 */ ); create unique index pmu_pk on pmu_file (pmu01,pmu02,pmu03,pmu04,pmu05,pmu06,pmu07); alter table pmu_file add constraint pmu_pk primary key (pmu01,pmu02,pmu03,pmu04,pmu05,pmu06,pmu07) enable validate; grant select on pmu_file to public; grant index on pmu_file to public; grant update on pmu_file to public; grant delete on pmu_file to public; grant insert on pmu_file to public; |