It is a production server. There are 3 different schemas within the database itself. The developers were restricted to a "temp" schema to try and cut down updates to vital tables. Instead, there are several junk tables that have been created from the main tables.