Make WordPress Core

Opened 16 months ago

#58826 new enhancement

Please add a default post relations table

Reported by: jcc5018's profile jcc5018 Owned by:
Milestone: Awaiting Review Priority: normal
Severity: critical Version:
Component: Database Keywords:
Focuses: Cc:

Description

As I am sure you know, people have bee using wordpress for a lot of things other than a simple blogging platform. And while your structure allows for basic functionality and relationships, There is a lot of room for improvement. As people continue to add more and more custom post types and related meta, the default posts/post meta tables will quickly become filled and make web queries slow.

In addition, the taxonomy system is very limiting, as that is not the only way one would want to group like items. The most common way, would be POST relationships. If a Class has many students, and students have many classes, Displaying an intermediary page between the two is very difficult with the current set up. Therefore, I'd like to request an extension to the database structure as described below in the link below. At minimum the 1st option should be considered as an alternative to archive pages with taxonomies.

https://imgur.com/a/L9q4bAf

If I type domain.exp/articles/for/baseball where baseball is a sports custom post type and arcticles is just one of several custom post types, I expect a query select * from articles where hobby_slug = 'baseball'

Currently everyone expects me to make the sport CPT a taxonomy, but if the sport has its own custom fields, and taxonomies already attached, that does not work. This system would be usable in a thousand different use cases and would make your platform more versatile. USERS, comments, posts and custom post types are all Models. Make it easier to establish any relation between them please.

Change History (0)

Note: See TracTickets for help on using tickets.