/* ================================================================================ 档案代号: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; |