/* ================================================================================ 档案代号:vbd_file 档案名称:aps(锁定制程时间) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vbd_file ( vbd01 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ vbd02 varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/ vbd03 varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/ vbd04 varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/ vbd05 varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/ vbd06 number(1), /*锁定码 */ vbd07 date, /*开始时间 to_date('2006-07-03 00:00:0 */ vbd08 date, /*结束时间 to_date('2006-07-03 00:00:0 */ vbd09 number(1), /*排程 */ vbd10 number(1) /*平行机台任务 */ ); create unique index vbd_pk on vbd_file (vbd01,vbd02,vbd03,vbd04,vbd05); alter table vbd_file add constraint vbd_pk primary key (vbd01,vbd02,vbd03,vbd04,vbd05) enable validate; grant select on vbd_file to public; grant index on vbd_file to public; grant update on vbd_file to public; grant delete on vbd_file to public; grant insert on vbd_file to public; |