Where to store custom tagging data associated with a custom post type

Avoid serialized whenever you can. It is slow to read and you cannot really search for it.

Use custom tables – more than one:

  1. One for the relationship between users, tags and images: user_id, tag_id and image_id.
  2. One for tag meta data, your attributes, if I understand that right: tag_id, meta_1, meta_2 …

Now you can look up for each attachment ID if there is an entry for the user, and then look up the meta data from the meta table.

Related Posts:

  1. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  2. Where are wordpress custom types stored?
  3. Delete all posts of a custom post type—efficiently
  4. List all the tags from a custom post type
  5. tag.php doesn’t work with tags on a custom post type post?
  6. Load custom posts with same tag as page
  7. Custom Post Type with Input fields to seperate table on database.
  8. Adding post tags to custom post types
  9. show tags of custom post type ONLY
  10. Get posts with tag all post types
  11. Custom post type or just use custom fields
  12. Show certain terms from custom taxonomy but exclude ‘parent’ terms?
  13. Adding An Author Tag To Posts Automatically
  14. How do I write this SQL statement for Posts written in last 24 hours?
  15. Save or update data when custom post published
  16. Using posts and postmeta table to store custom Address Book Plugin data
  17. How to use custom post type APIs, but use a different db table
  18. associate custom post type with tags with specific pages
  19. Developing WordPress on Kubernetes
  20. Custom Taxonomy – Tags Metabox is showing instead of Categories
  21. How to make a custom taxonomy selectable in post publish area?
  22. Add Tags to custom post type
  23. WordPress post count not showing for custom post type author
  24. Can custom taxonomies items have attached properties?
  25. Why does querying on post_tags (which has been applied to custom post types) only return posts?
  26. How to display Custom Post Type Post based on Tag with Shortcode Parameter?
  27. Group posts by custom post type
  28. Tag page with Custom Post Types not returning any posts
  29. Sorting custom post type columns with external data and without meta values
  30. Custom post type getting wrong categories and tags
  31. Custom Tag Description unable to display just below and outside of the Loop
  32. Database to page routing API?
  33. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  34. How to display “Category and Post_tag” component in a CPT Gutenberg edit screen?
  35. How to change wp prefix for custom post type only?
  36. How to import a custom MySQL DB table into a WordPress custom post type
  37. How to get all tags of a custom post type by id
  38. WP_Query orderby and tax_query
  39. How to organise this data within WordPress
  40. Save custom post type to external database
  41. data-type=”” … needed post tags stripped of characters
  42. Dynamically output a class to an anchor tag depending on what tag is chosen
  43. Replace dynamically content in a custom database table when a custom post is created
  44. How to display custom post type tags?
  45. Save and user submitted data from a form and display them in the wp backend
  46. Dump custom post type database
  47. Tags not working in my custom post type
  48. How to list tags from custom post type attachments?
  49. Strip Characters From Tag Name
  50. Designing a custom post type with a minimum number of meta fields
  51. Why does my taxonomy have a category style div id?
  52. How can I create an automatic drop down menu with my tags?
  53. WordPress hook which triggers on post import
  54. Update all published posts at once
  55. Print all the tags from a custom post type
  56. 404 Page Not Found on /Page/2/ on Tag Page
  57. Default post_tag for custom post type
  58. Custom posts – tag pagination
  59. Ideas to connect external database table to wordpress posts as custom field source
  60. Database alteration: users who voted
  61. How to Display the tag content of Custom Post?
  62. Using custom post types WordPress network
  63. Custom post type tags not showing in search
  64. Issue with Custom Post Type Tags
  65. custom post type: own database table structure and custom “new-post” interface
  66. One post auto attached to many another items
  67. Navigate by Tags inside a custom Post Type
  68. How do you make relational post types in WordPress? [duplicate]
  69. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  70. Search CPT by tag ids
  71. Does this archive template part look like its making too many calls to the db?
  72. when looping through custom post data not appearing
  73. How to set “section categories”?
  74. How select query is generated in a Custom Post Type?
  75. Exporting Post type from one theme and importing it to another theme
  76. custom data model – link and populate from admin backend
  77. Confused about where to store my data
  78. Automatically / dynamically populating tags in custom post type
  79. Event Manager: Events Deleted are still in DB as published but hidden in admin
  80. Rewrite url post_tag for custom post type
  81. Populate custom post type/custom fields from an external database
  82. Automatically convert standard posts with custom fields to custom post types
  83. Custom Post Type tag taxonomy “Page Not Found”
  84. CPT or Custom Table for Repository of Serial Numbers
  85. How can I include custom post types on a tag page?
  86. Filter custom post type by tags
  87. Loop multiple taxonomy in custom post
  88. Custom Post Type – Admin Columns
  89. Generating List of Tags from Custom Post Type
  90. Archive.php is not displaying tags
  91. Custom Post Type Tags Showing Under Regular Post Tags
  92. custom post type for custom talbe
  93. Return all wordpress custom posts in specific multidimensional array
  94. custom post type tags
  95. WordPress and Unity high scores table
  96. Tags and Taxonomy links not working for Custom Post Types
  97. Checking for published posts in a certain post type
  98. how insert how many post type in this function?
  99. WordPress Admin Page Slow. Customer Post Type is the slowest
  100. What would be the optimal CPT / Taxonomy design for the following entities structure
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduedueduedusedusedueduedusedu