/*
================================================================================
档案代号:vma_file
档案名称:aps 工作模式维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vma_file
(
vma01       varchar2(60) DEFAULT '' NOT NULL, /*工作模式编号*/
vma02       number(9) DEFAULT '0' NOT NULL, /*开始时间(整数)*/
vma03       number(9) DEFAULT '0' NOT NULL, /*结束时间(整数)*/
vma04       number(1),               /*工作型态                               */
vma05       varchar2(60),            /*工作模式名称                           */
vma06       varchar2(60)             /*工作模式描述                           */
);

create unique index vma_pk on vma_file (vma01,vma02);
alter table vma_file add  constraint vma_pk primary key  (vma01,vma02) enable validate;
grant select on vma_file to public;
grant index on vma_file to public;
grant update on vma_file to public;
grant delete on vma_file to public;
grant insert on vma_file to public;