/*
================================================================================
档案代号:vnc_file
档案名称:aps 加班资讯维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vnc_file
(
vnc01       varchar2(10) DEFAULT '' NOT NULL, /*资源类别(0:机器 1:工作站)*/
vnc02       date DEFAULT sysdate NOT NULL, /*资源编号*/
vnc03       number(9) DEFAULT '0' NOT NULL, /*日期*/
vnc04       number(9),               /*开始时间                               */
vnc05       number(1)                /*结束时间                               */
);

create unique index vnc_pk on vnc_file (vnc01,vnc02,vnc03);
alter table vnc_file add  constraint vnc_pk primary key  (vnc01,vnc02,vnc03) enable validate;
grant select on vnc_file to public;
grant index on vnc_file to public;
grant update on vnc_file to public;
grant delete on vnc_file to public;
grant insert on vnc_file to public;