2006OCT241505
So here we have the data stored in the Entry table. I've left the tags field de-normalised which I will extract and process and insert into a one to many relationship between Entry and Tag tables.
The advantage of this is .... (thinks) .... probably flexability and a bit of laziness. I want to be able to add tag fields quickly without writing more code. But I also want to do a query to extract all tags by post for instance.
Note the crappy display on the mysql tools.that mash the icons on the data titles & data lines.
next >>>
2006OCT241505
So here we have the data stored in the Entry table. I've left the tags field de-normalised which I will extract and process and insert into a one to many relationship between Entry and Tag tables.
The advantage of this is .... (thinks) .... probably flexability and a bit of laziness. I want to be able to add tag fields quickly without writing more code. But I also want to do a query to extract all tags by post for instance.
Note the crappy display on the mysql tools.that mash the icons on the data titles & data lines.
next >>>