From: Steffen N. <sne...@ip...> - 2009-05-21 22:45:42
|
Hi, to enforce some referential integrity I have added metware:references attributes to the sqlfields in the metware.skos. This allows to create a better reverse-engineered schema. I didn't succeed to get nice diagrams from either mysql-workbench (ex-DBDesigner) or pgdesigner, but I got a nice example using postgresql autodoc: http://msbi.ipb-halle.de/~sneumann/metware/postgresschema.pdf This should be a start to find all those "loose ends", tables which currently have no serious link to another table. Yours, Steffen |