If I am understanding right, you’re suggesting creating separate database tables both for your post type and taxonomies. You don’t really need to do that at all. Just create a custom post type which WordPress will store in the {prefix}_posts table, and create a custom taxonomy for that post type which WordPress will also handle in its native tables. It’s all built in already, no need for custom tables, and that’s how taxonomy terms are meant to be assigned – when you’re in a CPT you can assign it some terms, but in the terms themselves you don’t assign to a CPT.
Related Posts:
- Importing posts from old website to new conflicting post ID’s?
- Extend the wp_users table
- Check if column exists for one table in DB
- How can I query the db to access current post information?
- Get id from database
- Using class id from array for query
- Create hundreds of users with just ID in phpMyAdmin
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Oracle SQL query for Date format
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Can I have multiple primary keys in a single table?
- Using wpdb to connect to a separate database
- Database connection close
- How to create bulk page and content? [closed]
- Exporting revisions
- WP_Options ID high
- Best way to move live site local
- The revisions table in my database is at 70% capacity and growing. What should I do?
- WordPress for a very large website
- How to use multiple database in wordpress?
- WP_list_table bulk_action get edit and delete
- How to display data from custom table in wordpress database?
- Is removing orphaned wp_postmeta records safe?
- stdObject stored in database. How does one convert it to usable format?
- I have a table I created, how do I make a form for a user to filter the data?
- What ALL can cause “Another update is currently in progress.”? [closed]
- Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Trigger Plugin database update after git pull
- Does WordPress ever need multiple databases?
- Why are no posts showing despite my apparently correct DB restoration?
- How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
- Cannot update custom database table row
- SQL Error wp_commentmeta – incorrect table definition
- Change WordPress prefix for only one table?
- Two websites one database, administrator not working on second website
- Select two sums with single get_var statement
- How to get the SQL of the changes made to the database from an update or upgrade?
- How can i add custom fields into the contact form 7 [closed]
- Make an Items attribute searchable (taxonomy using existing attribute)
- Store partial database to an archive database time to time
- Move out of sync posts from one database to another
- Migration: Copying database content to a different server
- Remove empty rows from the database
- Check if post id exist in table than only update instead of inserting new row
- Detail explanation of wordpress database fields and metatag list [closed]
- CreateOrUpdate in WordPress
- $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
- How to convert srcset links from https to http?
- How to get a list of WordPress default database tables?
- Can local WordPress installs share /wp-content/ folder and database?
- Backing up WordPress database and files
- Safely store code(html/js..) into database
- Creating and Using Tables in the WordPress Database
- Connect a membership plugin to an external database
- Compare User meta_value with Product meta_value
- Storing user’s data on external database on other server
- is it right choose to connect database in template page directly in WordPress site?
- How to insert a value to decimal type field using wpdb->prepare?
- Sql query to get all metadata for a post
- Two separate wordpress installations at one domain
- Is there a way to edit the WP content database in an admin panel or external page?
- Where do I put my create_new_table function()?
- SQL database import #1046 error
- Get all top categories, then only 3 posts for each
- Having all “non-PHP” files on a different server
- syntax error for changing user role from database
- Finding a page holding a specific string/URL that is used in the content
- “wordpress error in establishing database connection” and missing tables
- get_option() does unserialize and don’t remove \
- next comment id number wordpress
- Adding last value from Database as text in WordPress Page
- Want to update value in database. But it says update() on null
- Merging development site with live site
- Backup Restore turns carriage returns to literal strings
- I have a WordPress 4.6 database dump – how do I use it in a new install?
- Local Content different from Remote Content
- Check if a database is well installed
- Checking if the data already exsis in the wp database – custom plugin
- live site do not update after importing sql database
- Transforming an wp_options database array into a javascript obect?
- WordPress + Postgresql
- How can I retrieve data from alternate database using wpdb class?
- Database connection close
- Author ID mismatch from database
- WordPress Database Charset/Collate
- MySQL Database User: Which Privileges are needed?
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- Automatic add record after refreshing page
- User accounts for saving form data?
- Trying to edit a WP site locally using MAMP
- SQL query : Select a thumbnail for a media
- WordPress API standard compliance and specification for external database [closed]
- Log IP of users who click a button? [closed]
- DROP TABLE IF EXISTS `wp_options` error?
- Problem with form database connectivity
- Server database problem
- Best way to search and replace within serialized database strings?
- Is it possible to have a form page for logged-out users where values are stored persistently?
- #1067 – Invalid default value for ‘post_date’ when trying to create a new column