Yeah I can get the key constraints from information_schema.table_constraints, I'm assuming all the relationships are defined by key constraints, thanks.
A data dictionary would be really handy, if it exists. Ideally just an explanation of each field and it's intended use.