Re: complete newbie asks: - does my table structure look ok?

[Simon]

Thanks Thomas,

With regards to ENUM - is this still the way to go If I wanted to be able to add "items" to the list in the future? That's why I thought, maybe, if the values were stored in another table then updating the available "values" would be easier.

Another question I have is regarding the field "Images". I would like to store multiple images per record - so should this field hold "links" to the actual images? In which case have I got the field type and attributes correct? Do I need a new table for images - especially as I would like a small description to go with each image, ie. "kitchen", "bathroom", "view from rear of house" or things like this.

Also, does the rest of the table look ok?

thanks again for any advice