/*
================================================================================
档案代号:vmd_file
档案名称:aps 资源维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmd_file
(
vmd01       varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/
vmd02       varchar2(60),            /*周行事历                               */
vmd03       varchar2(60),            /*日行事历                               */
vmd04       number(1),               /*产能型态                               */
vmd07       number(1)                /*连批条件检查码                         */
);

create unique index vmd_pk on vmd_file (vmd01);
alter table vmd_file add  constraint vmd_pk primary key  (vmd01) enable validate;
grant select on vmd_file to public;
grant index on vmd_file to public;
grant update on vmd_file to public;
grant delete on vmd_file to public;
grant insert on vmd_file to public;