Title: Database table relationship
Last modified: August 21, 2016

---

# Database table relationship

 *  [wrip](https://wordpress.org/support/users/wrip/)
 * (@wrip)
 * [12 years ago](https://wordpress.org/support/topic/database-table-relationship/)
 * I’ve looked at phpMyAdmin for database relationship but in the Designer tab, 
   the tables are listed but no relationship is shown between the tables. Was that
   intentionally left out? I tried other CMS and none of them are showing table 
   relationships.
 * Is there something I must activate in phpMyAdmin to see the table relationships
   or are the relationships are maintained in the code itself instead of in the 
   database design?

Viewing 1 replies (of 1 total)

 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [12 years ago](https://wordpress.org/support/topic/database-table-relationship/#post-4768129)
 * That’s intentional. The reason behind it is that MySQL has several table types,
   and only some support relationships and foreign keys. Because of this most PHP/
   MySQL systems like WordPress are coded to allow for the “lowest common denominator”
   which in this case are MyISAM tables which are normally used by default. These
   don’t support relationships, so trying to add them results in errors.

Viewing 1 replies (of 1 total)

The topic ‘Database table relationship’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/database-table-relationship/#post-4768129)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics