Is there any utility to check the data model available in the instance. We need to check what all links are there in schema's in that complete data model.
Change the strOutputFile value to add the destination directory where you would like to create the Open Office document.
click here for more details How to generate a Data Model or Data Dictionary
And please find the similar thread Adobe Campaign Classic System tables data dictionary
The data model generator will only show fields, similar to psql's \d.
Links is either a manual process of picking through the tables and noting their connections, or something automated via simple scripting.
ERD discovery tools can't be used since relationships are managed by Campaign, not the db, i.e. no foreign keys to read.