I've come face to face with quite possibly the ugliest database schema in recorded history.
Searching