/*
================================================================================
档案代号:vbf_file
档案名称:aps(制令外包)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vbf_file
(
vbf01       varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/
vbf02       varchar2(10),            /*外包商编号                             */
vbf03       number(1),               /*外包类型                               */
vbf04       date,                    /*开始时间(日期)                         */
vbf05       date,                    /*结束时间(日期)                         */
vbf06       number(9),               /*作业时间                               */
vbf07       number(1)                /*是否已排程                             */
);

create unique index vbf_pk on vbf_file (vbf01);
alter table vbf_file add  constraint vbf_pk primary key  (vbf01) enable validate;
grant select on vbf_file to public;
grant index on vbf_file to public;
grant update on vbf_file to public;
grant delete on vbf_file to public;
grant insert on vbf_file to public;