How to review Database schema?
All the information you need is in the catalog, have a look at the tables:

information_schema.table_constraints
information_schema.key_column_usage
information_schema.constraint_column_usage


However, if you want something more visual have a look at:

http://schemaspy.sourceforge.net/


It will reverse engineer your schema and produce html output