469,112 Members | 2,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,112 developers. It's quick & easy.

When to use an array column?

I am building a photo album webpage and am not sure exactly how I
should organize the database. Here's where Im at so far...

I have one table called 'images' which contains the columns
'id','albumID', 'url', 'title', and 'description'.

Then another table called 'albums' which contains the columns 'id' and
'name'.

The part where I am having the trouble is the 'images.albumID' column.
Some photos can be apart of mutliple albums, so should the 'albumID'
column be an array type?

Does anyone have any experience with something like this or know of a
better way to do this??? -Nick
Jul 19 '05 #1
0 1434

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Tom | last post: by
5 posts views Thread by Stephen3776 | last post: by
3 posts views Thread by rudra | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.