added indices to showings foreign keys