Manchonoch
asked on
real estate table in MS SQL server
I am trying to design a table to hold pictures of properties rented for a company. Each row will be a diiferent property. The rows will have foreign keys to owners table and renters table. This will allow which properties are currently available or occupied. I currently use a folder system. It works but is not optimal. I am just looking for suggestions on the layout for the property table. Maybe someone has done this before, as I am unhappy with what I have come up with. Thank you.
ASKER
Each unit(property) will have an outside vies of unit then numerous interior pictures. Should I name the rows according to bedroom 1, 2, 3, LR, DR, bath1 bath2 or just name the rows image1, image2, etc. THe issue is each unit will have a different combination of rooms. If i name each column i'll have more control with the sql rather than just pulling all the images and not knowing what each is.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
but storing the image file within the file system while the properties table will have
the full path to the image.
The problem is how you define a property i.e. can a property have multiple renters?
If a property is an aggregate of several units, you would have to handle that.
have you looked/considered http://www.open-realty.org?
property <=> property units.
single family residence or multi-family residence.
When you are talking about images what do you mean a single external photo of the property. A more detailed picture of the inside layout? etc.