I’ve searched for if there was a good solution for database driven application which uses tags. Finally i found a blog entry discussing tags and database schemas.
In that entry “Toxi Solution” is the best solution. Simply the schema is like this :
I liked this schema and using it for 4 months in my projects. I’m not only using this for tags on my projects that most of table “references” are done like this. This is an old and good system for referencing tables.
For future references you can download a copy from Focus on Code : Tags_ Database schemas.mht (204KB)
Tags: database, programming, schema, sql, tags
Entries (RSS)