/* ================================================================================ 档案代号:vop_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vop_file ( vop00 varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/ vop01 varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/ vop02 varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/ vop03 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ vop04 varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/ vop05 varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/ vop06 varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/ vop07 varchar2(10), /*外包商编号 */ vop08 number(1), /*外包类型 */ vop09 date, /*开始时间(日期) */ vop10 date, /*结束时间(日期) */ vop11 number(9), /*作业时间 */ vop12 number(1), /*排程 */ vop13 number(5), /*外包商序号 */ vop14 number(15,3) /*外包数量 */ ); create unique index vop_pk on vop_file (vop00,vop01,vop02,vop03,vop04,vop05,vop06); alter table vop_file add constraint vop_pk primary key (vop00,vop01,vop02,vop03,vop04,vop05,vop06) enable validate; grant select on vop_file to public; grant index on vop_file to public; grant update on vop_file to public; grant delete on vop_file to public; grant insert on vop_file to public; |