Where to put the imagedata in CMS?

[Perttu Pulkkinen]

I am doing a news-oriented multiuser cms, where authors can design
html-pages or plaintext-pages and then editor(s) accept them. Also they can
load images, at least five - maybe. But I don't know yet where should I
place tha imagedata. Options are at least:

1) To same table with the pagematerial, which naturally connects images with
pages but on the other hand limit the number of images/pages. Also I am
afraid, will this cause speed problems or is just indexing the text-fields
enough to prevent to speed problems.

2) To own table called images and then have author_id connected to every
image. In this way authors could only use their own images, but use the same
image easily without new file uploads. Maybe during the file upload there
could be option "allow use for all" and then author_id would be null. Those
images would be general image store for all auhors. In this moment this
alternative sounds best.

3) To own table called images and then have page_id connected to every
image. This is also quite natural consept but more restrictive than prevous
one.

4) To own table called images and then have couple of image_id fields in
pages-table. This violates database integrity but "good side" is that all
queries in public side can be done without inspecting images-table.