Entity Relationship Diagrams for WebDB

<img src="http://samwilson.id.au/wp-content/uploads/2013/08/twyne_dev_erd-500x332.png" alt="twyne_dev_erd" width="500" height="332" class="aligncenter size-medium wp-image-1691" srcset="http://localhost/~sam/wp-samwilson.id.au/wp-content/uploads/2013/08/twyne_dev_erd-500x332.png 500w, http://localhost/~sam/wp-samwilson.id.au/wp-content/uploads/2013/08/twyne_dev_erd-150x99.png 150w, http://localhost/~sam/wp-samwilson.id.au/wp-content/uploads/2013/08/twyne_dev_erd.png 680w" sizes="(max-width: 500px) 100vw, 500px" />

I have added a ERD module to WebDB, for producing simple little relationship diagrams like the one above. As with WebDB generally, it’s not about displaying the actual database schema but rather just a simple way to display the semantics of the schema (often, to users who don’t want to see even a single underscore!).

Initially, it selects all tables that are linked to at least one other table (either inwards or outwards), and then gives the user the option of hiding or showing each table.

I’m moving WebDB towards a modular structure, and one that can be installed with Packagist. Not there yet though.


Retrieved from ‘https://samwilson.id.au/index.php?title=Entity_Relationship_Diagrams_for_WebDB&oldid=156