/* ================================================================================ 档案代号:ecbb_file 档案名称:制程资料说明档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ecbb_file ( ecbb01 varchar2(40) NOT NULL, /*料件编号 */ ecbb02 varchar2(10) NOT NULL, /*制程编号 */ ecbb03 number(5) NOT NULL, /*制程序号 */ /*料件被制作程序过程中的生产活动顺序编号 */ ecbb09 number(5) NOT NULL, /*行序 */ ecbb10 varchar2(80) /*说明 */ ); create unique index ecbb_pk on ecbb_file (ecbb01,ecbb02,ecbb03,ecbb09); alter table ecbb_file add constraint ecbb_pk primary key (ecbb01,ecbb02,ecbb03,ecbb09) enable validate; grant select on ecbb_file to public; grant index on ecbb_file to public; grant update on ecbb_file to public; grant delete on ecbb_file to public; grant insert on ecbb_file to public; |