How to relate 3 wordpress components with each other (Create database relationships)

Before you get to relating things in WordPress, you should decide what things are.

In a very nutshell there are:

  1. Posts of post types (native ones being pages and blog posts)
  2. Terms of taxonomies (native ones being tags and categories)

There are some things that WordPress does smoothly out of the box. Such as post being assigned a term or term having a parent term.

Others are completely missing, notably post being directly related to another post.

From your description my educated guess would be:

  1. Gallery post type
  2. Artist taxonomy
  3. Place taxonomy

But depending on specifics of data involved there might be nuances to push it in different direction entirely. While defining taxonomies and custom post types is quite easy in WordPress, effectively making use of them takes a bit of practice.

Related Posts:

  1. Get the last post ID
  2. Problem of encoding characters (apostrophes) in my posts publications
  3. Making my plugin create a page?
  4. Posts are deleted everyday at night
  5. Insert data in custom table during new post creation
  6. Shortcode returning specific content of a post
  7. How to run Two WordPress blogs with different themes and with single database and same content
  8. Disallow a user to post in certain categories
  9. Create custom column in post table in wordpress
  10. Article source link for posts
  11. Add agenda items and notifications
  12. Custom Post Type causes Page Not Found
  13. Taking WordPress table prefixes into account
  14. Changing BIGINT to INT
  15. WordPress register_activation_hook table creation not working
  16. How to add Edit | Delete button on rows?
  17. The plugin generated x characters of unexpected output, $wpdb not defined
  18. clean wp_options table unused rows
  19. Get total number of comment of the posts written by an author
  20. How to write one comment and publish on every post using database or plugin?
  21. Output HTML only on individual post view
  22. Saving Custom Post types and fields to a custom table
  23. Portfolio + Blog: multisite or plugin?
  24. When to use action hooks and plugins
  25. How to create custom tables in WordPress using my own plugin?
  26. How to enable qTranslate languages tabs in custom plugin page
  27. Calendar Solution: Handling upcoming Dates with Posts?
  28. get_post_type on post.php
  29. How to hide some section in WordPress under Post
  30. how to oauth1 Wp plug-in revoke/reset.?
  31. WordPress comments not appearing in blog posts, likely because of Redux template. Could I fix this with a plugin that adds a comment form as a block? [closed]
  32. How can I perform high-level database merging for WordPress within continues delivery?
  33. posts comments goes to trash
  34. WordPress Backend HA (Automatic failover)
  35. Migrating to WordPress Recipe Plugin and Some SQL Issues
  36. Multiple instance of data in plugin custom database table on plugin activation
  37. WordPress plugin creating database in localhost but not on real host
  38. Is it possible to send blog posts via email to subscribers?
  39. Custom setup of wordpress comments that are displayed
  40. Is there any plugin which can paste a common content to my every post?
  41. How do i edit the plugin files in DataBase via phpMyAdmin?
  42. How to insert and call new data in wordpress website database through a plugin
  43. WPDB: Update table
  44. Import Instagram post to WordPress blog post
  45. How to keep variable `$post` to using in another file
  46. How to get all posts belongs to a user between a certain date
  47. Add some fileds to the wp_posts table
  48. How can I automatically download all images from all imported posts, place them on my new host, and replace all the links
  49. Always get creating a new table with foreign key
  50. What is the WordPress approach to custom data?
  51. check uncategorized category by default
  52. Article content navigator in wordpress like mbaskool website
  53. Getting a list of the published posts
  54. Creating a search form and displaying results
  55. How to access the WordPress DB from a plugin file
  56. What hook can I use to modify custom post data before it is displayed on the page?
  57. get current page number with wp_link_pages()
  58. problem with register_activation_hook in plugin
  59. Delete data from custom table when deleting a post
  60. Plugin is creating posts twice
  61. How to write a new file when new post has been published in WordPress
  62. How to Get Recent 5 post in My Title bar?
  63. Plugin for visitors to edit content without logging in? [closed]
  64. WP Insert Post If user refreshes override new post
  65. Summary and Comments on Main landing Page
  66. Method/Plugin/Hack to Start a Post with an Writing Outline?
  67. What snippet do I need to type to show my ACF field show up on my theme?
  68. Oops! That page can’t be found
  69. page duplication on wordpress that wont stop
  70. Bulk Edit Media Library alt, caption, image names
  71. WordPress is redirecting me to homepage
  72. Adding custom post category to categories widget
  73. Cant create table on plugin activation
  74. Moving a few select DB tables to a new WP instance
  75. How to wrap image tag into div for post only?
  76. Is it a good practice to use wordpress database to store pages contents which loading to page dynamically?
  77. Where do the section input fields values are stored in database
  78. My own metabox checkbox plugin only saves the last value I’ve checked
  79. How to prevent authors from editing their post count?
  80. How to save information related to post in database?
  81. RSS Feed has no Items (Possible Plugins Conflict)
  82. How to use shortcode of any plugin to show it visually where i want?
  83. A plugin is giving me “You do not have sufficient permissions to access this page.” error
  84. WordPress not updating post or disable plugin instead a white page appear
  85. Ger posts from similar tags and categories
  86. Internationalization of Blog Posts
  87. Issues with Post 2 Post Plugin
  88. single.php fires more than once after clicking on any post to view with different post id each time
  89. Twitter List Tweets and Delicious Links as Posts
  90. Creating fields in the database
  91. Allow users to enter and edit data in one-to-many configuration
  92. How to make only selected posts appear on a selected wordpress page
  93. Updating WordPress [closed]
  94. How to block external download link access if visitor not referred from WP?
  95. Notifications Bar on home page only
  96. Distribute post content through several divs [closed]
  97. Does anyone have the Custom Post Permalinks plugin from John P. Bloch? [closed]
  98. How to get an error message if a form is empty (plugin: Post for site) [closed]
  99. Text Wrapping in WPDataTables
  100. Getting 400 Error in wordpress website
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedueduseduedusedueduedusedusedu