/* ================================================================================ 档案代号:msh_file 档案名称:不纳入MRP计算工单别资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table msh_file ( msh01 varchar2(5) NOT NULL, /*工单单别 */ msh02 varchar2(1), /*No Use */ msh03 varchar2(1), /*No Use */ mshacti varchar2(1), /*资料有效码 */ mshuser varchar2(10), /*资料所有者 */ mshgrup varchar2(10), /*资料所有部门 */ mshmodu varchar2(10), /*资料修改者 */ mshdate date /*最近修改日 */ ); create unique index msh_pk on msh_file (msh01); alter table msh_file add constraint msh_pk primary key (msh01) enable validate; grant select on msh_file to public; grant index on msh_file to public; grant update on msh_file to public; grant delete on msh_file to public; grant insert on msh_file to public; |