/*
================================================================================
档案代号:van_file
档案名称:aps途程制程
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table van_file
(
van01       varchar2(40) DEFAULT '' NOT NULL, /*料号*/
van02       varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/
van03       varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/
van04       varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/
van05       date,                    /*生效日                                 */
van06       date,                    /*失效日                                 */
van07       varchar2(10),            /*资源编号                               */
van08       varchar2(60),            /*资源群组编号                           */
van09       number(1),               /*批次作业                               */
van10       number(15,3),            /*整备时间                               */
van11       number(15,3),            /*加工时间                               */
van12       number(9),               /*移转批量大小                           */
van13       number(9),               /*基准数量                               */
van14       number(1),               /*外包作业                               */
van15       number(9),               /*替代作业的优先次序                     */
van16       number(9),               /*批次加工上限                           */
van17       number(9)                /*批次加工下限                           */
);

create unique index van_pk on van_file (van01,van02,van03,van04);
alter table van_file add  constraint van_pk primary key  (van01,van02,van03,van04) enable validate;
grant select on van_file to public;
grant index on van_file to public;
grant update on van_file to public;
grant delete on van_file to public;
grant insert on van_file to public;