Title: Database ERD
Last modified: June 14, 2020

---

# Database ERD

 *  [tdiaz](https://wordpress.org/support/users/tdiaz/)
 * (@tdiaz)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/database-erd/)
 * On the current page for the Database Description it does not have any notes about
   the foreign keys / relationships between the tables
 * [https://codex.wordpress.org/Database_Description](https://codex.wordpress.org/Database_Description)
 * But it does on older ones:
 * [https://codex.wordpress.org/Database_Description/3.3](https://codex.wordpress.org/Database_Description/3.3)
 * From what I have read otherwise, it sounds to me that there are no actual relationships
   in the database, but that it’s all done with php? (in that you are in charge 
   of making sure the associated records are created when needed, deleted, etc.)
 * What I’m trying to do is simulate the WP database in FileMaker so I can get to
   see whats where when what … for ODBC. I’d like to make a front end like client
   eventually, for doing admin with Gravity Forms, WooCommerce orders/items and 
   posts…
    -  This topic was modified 5 years, 9 months ago by [tobifjellner (Tor-Bjorn “Tobi” Fjellner)](https://wordpress.org/support/users/tobifjellner/).
    -  This topic was modified 5 years, 9 months ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).
      Reason: Moved to Fixing WordPress, this is not an Developing with WordPress
      topic
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-erd%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [5 years, 9 months ago](https://wordpress.org/support/topic/database-erd/#post-12983411)
 * You’re correct. Foreign key relationships are managed in code, not in the database.
   I’m not sure why, but that’s how it works.
 *  [Akira Tachibana](https://wordpress.org/support/users/atachibana/)
 * (@atachibana)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/database-erd/#post-12988360)
 * [@tdiaz](https://wordpress.org/support/users/tdiaz/)
    Your mentioned 3.3 documents
   were filled with wrong information and I fixed it at 5 years ago. Refer below
   document for these changes: [https://codex.wordpress.org/Talk:Database_Description](https://codex.wordpress.org/Talk:Database_Description)

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database ERD’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [Akira Tachibana](https://wordpress.org/support/users/atachibana/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/database-erd/#post-12988360)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics