continued work on normalizing the schemas; added admin_seat table