/* ================================================================================ 档案代号:msf_file 档案名称:MRP 工单模拟资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table msf_file ( msf01 varchar2(10) NOT NULL, /*工单模拟编号 */ msf02 varchar2(16) NOT NULL /*工单单号 */ ); create unique index msf_pk on msf_file (msf01,msf02); alter table msf_file add constraint msf_pk primary key (msf01,msf02) enable validate; grant select on msf_file to public; grant index on msf_file to public; grant update on msf_file to public; grant delete on msf_file to public; grant insert on msf_file to public; |