/*
================================================================================
档案代号:rqr_file
档案名称:粗略产能规划参数档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rqr_file
(
rqr_v       varchar2(10) NOT NULL,   /*模拟版本                               */
rqr01       date,                    /*执行日期                               */
rqr02       varchar2(5),             /*起始时间                               */
rqr03       varchar2(5),             /*结束时间                               */
rqr04       number(5),               /*产生笔数                               */
rqr05       varchar2(10),            /*产生人员                               */
incl_wo     varchar2(1),             /*是否纳入工单资料                       */
incl_mps    varchar2(1),             /*是否纳入MPS 资料                       */
incl_plm    varchar2(1)              /*是否纳入PLM 资料                       */
);

create unique index rqr_pk on rqr_file (rqr_v);
alter table rqr_file add  constraint rqr_pk primary key  (rqr_v) enable validate;
grant select on rqr_file to public;
grant index on rqr_file to public;
grant update on rqr_file to public;
grant delete on rqr_file to public;
grant insert on rqr_file to public;