/*
================================================================================
档案代号:vmj_file
档案名称:aps工作站维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmj_file
(
vmj01       varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/
vmj02       varchar2(60),            /*周行事历                               */
vmj03       varchar2(60),            /*日行事历                               */
vmj04       number(1),               /*产能型态                               */
vmj07       number(1)                /*连批条件检查码                         */
);

create unique index vmj_pk on vmj_file (vmj01);
alter table vmj_file add  constraint vmj_pk primary key  (vmj01) enable validate;
grant select on vmj_file to public;
grant index on vmj_file to public;
grant update on vmj_file to public;
grant delete on vmj_file to public;
grant insert on vmj_file to public;