Hi! I'm trying to create a database for my portfolio but I'm kind of stuck. I have 3 questions that I hope people here can help me with...
1) I know that I will need a table which stores the projects' information (name, date, description, etc.). What I'm not sure about, is how to store the links to the project files. Some projects have only 1 file, while others have several (a video file, a documentation, etc.). Do I have to create another table for the files, and for each file, store the project id that the file belongs to? Or is there a way for me to do this without even having to store the file links?
2) If I want to display images in my description, do I simply use html img tags? I thought it was bad to store html inside the database? Which made me wonder, how do people store their blog entries? Blog entries can have links, images, etc., right? So is the blog entry field just a simple TEXT field?
3) How can I store tags for my projects? I read somewhere that you can simply do this by creating a TEXT field for the tags and use the MySQL fulltext search functions. Is that how people do it or.. are there other ways?
Um.. hopefully my questions aren't too confusing. Any answers will be much appreciated!