Movie database

[ Moderator note: moved to Fixing WordPress. Please do not use Developing With WordPress for these topics. ]

Hi!

Me and my coleague working on a new wordpress project: A movies database from my country. We have already selected a theme, which comes with custom post types for movies, this comes handy. We still need more meta boxes that the ones that come with the theme, and for that purpose we are using CMB2.

However, a question arose a couple days ago. All the data is going to be saved on wp_postmeta table. We think it would be a priority to save all the data related to the movies in a separate table. It is a serious project, and we need to have the data in a clean, neat, separated table.

In fact, it would be great to have more than one table, since we also need a ‘persons’ custom meta post, that would save data related to the directors, actors etc… and it would be appropriate to have that data in a separate table:

MOVIES_TABLE
PERSONS_TABLE
COUNTRIES
LANGUAGES

etc…

This is the first time we are facing this ‘programming’ obstacle.
We have no idea what is the best way to achieve this, by using the already created custom post types and custom metaboxes that the theme has incorporated, and that we definitelly want to make use of.

In short: We want custom post types with custom metaboxes data to be saved and get from custom tables that we create.

• This topic was modified 7 years, 6 months ago by brsastre.
• This topic was modified 7 years, 6 months ago by Jan Dembowski.