/*
================================================================================
档案代号:vbc_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vbc_file
(
vbc01       varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/
vbc02       date DEFAULT sysdate NOT NULL, /*日期*/
vbc03       number(9) DEFAULT '0' NOT NULL, /*开始时间(整数)*/
vbc04       number(9),               /*结束时间(整数)                         */
vbc05       number(1)                /*是否排程                               */
);

create unique index vbc_pk on vbc_file (vbc01,vbc02,vbc03);
alter table vbc_file add  constraint vbc_pk primary key  (vbc01,vbc02,vbc03) enable validate;
grant select on vbc_file to public;
grant index on vbc_file to public;
grant update on vbc_file to public;
grant delete on vbc_file to public;
grant insert on vbc_file to public;