/*
================================================================================
档案代号:vab_file
档案名称:aps 日行事历
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vab_file
(
vab01       varchar2(60) DEFAULT '' NOT NULL, /*日行事历编号*/
vab02       date DEFAULT sysdate NOT NULL, /*日期*/
vab03       varchar2(60)             /*工作模式                               */
);

create unique index vab_pk on vab_file (vab01,vab02);
alter table vab_file add  constraint vab_pk primary key  (vab01,vab02) enable validate;
grant select on vab_file to public;
grant index on vab_file to public;
grant update on vab_file to public;
grant delete on vab_file to public;
grant insert on vab_file to public;