So what should the new name be? WordPress Database Description? WordPress Database Outline? Lorelle 23:50, 13 May 2005 (UTC)
Database Schema? Boneill 22:33, 30 May 2005 (UTC)
Does anyone know what tool was used used to create the visual database schema? It would be great if we could also host a copy of that file here so that contributors can plan custom WordPress build outs and update as the WP core changes (2.9 is the current build, but currently the chart shows v2.5).
DBDesigner 4 by FABforce (http://www.fabforce.net/dbdesigner4/) is a free and open source visual database design tool which is very easy to use. I haven't had the time yet to enter the WordPress database schema into it, but it would be a whole lot easier if someone already the file from the version currently displayed.
Thanks!
Does WordPress 3.0+ in fact use foreign keys as is described here? The thread at http://wordpress.org/support/topic/foreign-keys-referencing-wp_usersid?replies=5 says it doesn't.
There were so many errors in this page, and causing unnecessary discussion. I fixed everything.
- Fixed data type, attribute, Index, and Default values based on scheme and my environment.
ref. https://core.trac.wordpress.org/browser/tags/4.1/src/wp-admin/includes/schema.php
- Deleted Cardinality-column. These values are meaningless.
ref. http://wordpress.stackexchange.com/questions/160941/codex-database-description-meaning-of-cardinality
- Deleted Foreign Keys.
ref. above discussion
- Deleted wp_sitecategories.
ref. https://wordpress.org/support/topic/the-creation-of-wp_sitecategories?replies=3
Remaining
- Super Admin links in multisite overview are out of date.
- Table class of Indexes are dummy to narrow the width, or make difference with Table definition.
Regards, Atachibana