/*
================================================================================
档案代号:vaa_file
档案名称:aps 工作模式
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vaa_file
(
vaa01       varchar2(60) DEFAULT '' NOT NULL, /*工作模式编号*/
vaa02       number(9) DEFAULT '0' NOT NULL, /*开始时间(整数)*/
vaa03       number(9) DEFAULT '0' NOT NULL, /*结束时间(整数)*/
vaa04       number(1),               /*工作型态                               */
vaa05       varchar2(80),            /*工作模式名称                           */
vaa06       varchar2(80)             /*工作模式描述                           */
);

create unique index vaa_pk on vaa_file (vaa01,vaa02);
alter table vaa_file add  constraint vaa_pk primary key  (vaa01,vaa02) enable validate;
grant select on vaa_file to public;
grant index on vaa_file to public;
grant update on vaa_file to public;
grant delete on vaa_file to public;
grant insert on vaa_file to public;