/* ================================================================================ 档案代号:bmk_file 档案名称:料件机种维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bmk_file ( bmk01 varchar2(40) NOT NULL, /*料件编号 */ bmk02 number(5) NOT NULL, /*行序 */ bmk03 varchar2(5) /*机种代号 */ ); create unique index bmk_pk on bmk_file (bmk01,bmk02); alter table bmk_file add constraint bmk_pk primary key (bmk01,bmk02) enable validate; grant select on bmk_file to public; grant index on bmk_file to public; grant update on bmk_file to public; grant delete on bmk_file to public; grant insert on bmk_file to public; |