/* ================================================================================ 档案代号:vap_file 档案名称:aps(投料点) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vap_file ( vap01 varchar2(40) DEFAULT '' NOT NULL, /*主件品号*/ vap02 varchar2(40) DEFAULT '' NOT NULL, /*元件品号*/ vap03 varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/ vap04 varchar2(60), /*加工序号 */ vap05 varchar2(6) /*作业编号 */ ); create unique index vap_pk on vap_file (vap01,vap02,vap03); alter table vap_file add constraint vap_pk primary key (vap01,vap02,vap03) enable validate; grant select on vap_file to public; grant index on vap_file to public; grant update on vap_file to public; grant delete on vap_file to public; grant insert on vap_file to public; |