/* ================================================================================ 档案代号:mea_file 档案名称:BOM 替代料资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table mea_file ( mea01 number(5) NOT NULL, /*流用代号 */ mea02 varchar2(40) NOT NULL, /*料件编号 */ mea03 date, /*生效日期范围 */ mea04 date, /*失效日期范围 */ mea05 varchar2(20), /*核准文号范围 */ mea06 date /*核准日期范围 */ ); create unique index mea_02 on mea_file (mea02); create unique index mea_pk on mea_file (mea01,mea02); alter table mea_file add constraint mea_pk primary key (mea01,mea02) enable validate; grant select on mea_file to public; grant index on mea_file to public; grant update on mea_file to public; grant delete on mea_file to public; grant insert on mea_file to public; |