/* ================================================================================ 档案代号:mpu_file 档案名称:工单日期调整档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table mpu_file ( mpu_v varchar2(10) NOT NULL, /*模拟版本 */ mpu01 varchar2(16) NOT NULL, /*工单编号 */ mpu02 date, /*开工日期 */ mpu03 date, /*完工日期 */ mpuacti varchar2(1), /*资料有效码 */ mpuuser varchar2(10), /*资料所有者 */ mpugrup varchar2(10), /*资料所有群 */ mpumodu varchar2(10), /*资料更改者 */ mpudate date /*最近修改日 */ ); create unique index mpu_pk on mpu_file (mpu_v,mpu01); alter table mpu_file add constraint mpu_pk primary key (mpu_v,mpu01) enable validate; grant select on mpu_file to public; grant index on mpu_file to public; grant update on mpu_file to public; grant delete on mpu_file to public; grant insert on mpu_file to public; |