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)

  • 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.