• I am adding more functionality/features to an open source project.
  • The project is about a forum where each post can be given a specific list of tags.
  • The tags are homogeneous. I.e they are of similar type. Ex: Subject
  • I am required to add multiple homogeneous tags. For ex: Subject, Course, College, Experience. All of them should have the same features as current tag
  • Currently each post can have multiple tags of same type. The requirement is to multiple types where each type allows multiple tags
  • Below is a snippet of a already existing datamodel

A snippet of already existing database.

  • How do I make changes to the already existing Database? (Please don't discard the question as opinion based since I saw many of them having similar doubts)
  • Do I need to add a separate table for each type of tags and redo whatever the original tag did?
  • Or should I create a level above tags which is a type of tags and they all inherit the basic tag functionality.
  • Sorry, I don't quite follow. Do you mean that right now each post can only have one tag, and you want to be able to have multiple tags on a single post? – Jon Seigel Oct 7 '13 at 17:12
  • I have editted the question. Please see the 5th point. A post can have multiple tags of the same type. I need to create multiple types – Nikhil Oct 7 '13 at 17:17
  • Okay, could you please post a database diagram that shows the tables that are related to this problem? I only see a single table of interest (the one you highlighted) in the diagram right now. – Jon Seigel Oct 7 '13 at 17:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.