added additional tables to support LRMI and fix relationships