/* ================================================================================ 档案代号:vng_file 档案名称:aps 制程外包维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vng_file ( vng01 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ vng02 varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/ vng03 varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/ vng04 varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/ vng06 number(1), /*外包类型 */ vng07 date, /*开始时间(日期) */ vng08 date, /*结束时间(日期) */ vng10 number(1), /*排程 */ vng11 number(9) /*外包商序号 */ ); create unique index vng_pk on vng_file (vng01,vng02,vng03,vng04); alter table vng_file add constraint vng_pk primary key (vng01,vng02,vng03,vng04) enable validate; grant select on vng_file to public; grant index on vng_file to public; grant update on vng_file to public; grant delete on vng_file to public; grant insert on vng_file to public; |