/* ================================================================================ 档案代号:msw_file 档案名称:多营运中心mrp版本档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table msw_file ( msw000 varchar2(10) NOT NULL, /*汇总版本号 */ msw02 number(5), /*pr/po 允许交期提前 (reschedule) */ msw03 date, /*执行日期 */ msw04 varchar2(5), /*起始时间 */ msw05 varchar2(5), /*结束时间 */ msw06 number(10), /*no use */ msw07 varchar2(10), /*产生人员 */ msw08 varchar2(10) NOT NULL, /*分营运中心代号 */ msw09 varchar2(2), /*no use */ msw10 varchar2(20) /*分营运中心mrp版本号 */ ); create unique index msw_pk on msw_file (msw000,msw08); alter table msw_file add constraint msw_pk primary key (msw000,msw08) enable validate; grant select on msw_file to public; grant index on msw_file to public; grant update on msw_file to public; grant delete on msw_file to public; grant insert on msw_file to public; |