/*
================================================================================
档案代号:vmn_file
档案名称:aps 途程制程维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmn_file
(
vmn01       varchar2(40) DEFAULT '' NOT NULL, /*料号*/
vmn02       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
vmn03       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
vmn04       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
vmn08       varchar2(60),            /*资源群组编号(机器)                     */
vmn081      varchar2(60),            /*资源群组编号(工作站)                   */
vmn09       number(1),               /*批次作业                               */
vmn12       number(9),               /*移转批量大小                           */
vmn13       number(9),               /*基准数量                               */
vmn15       number(9),               /*替代作业的优先次序                     */
vmn16       number(9),               /*批次加工上限                           */
vmn17       number(9)                /*批次加工下限                           */
);

create unique index vmn_pk on vmn_file (vmn01,vmn02,vmn03,vmn04);
alter table vmn_file add  constraint vmn_pk primary key  (vmn01,vmn02,vmn03,vmn04) enable validate;
grant select on vmn_file to public;
grant index on vmn_file to public;
grant update on vmn_file to public;
grant delete on vmn_file to public;
grant insert on vmn_file to public;