# Database design help

**URL:** <https://forum.kirupa.com/t/database-design-help/309776>\
**Category:** programming\
**Created:** [May 24, 2010, 7:09pm UTC](https://forum.kirupa.com/t/database-design-help/309776 "2010-05-24T19:09:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![glitterbaby](https://avatars.discourse-cdn.com/v4/letter/g/bbce88/32.png) [@glitterbaby](https://forum.kirupa.com/u/glitterbaby)\
**Post date:** [May 24, 2010, 7:09pm UTC](https://forum.kirupa.com/t/database-design-help/309776/1 "2010-05-24T19:09:55Z")

</div>

Hi! I’m trying to create a database for my portfolio but I’m kind of stuck. 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?

Also, I was wondering, 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?

Anyone know what the heck I’m trying to say? Lol.