Is this database layout correct?
Posted: Thu May 22, 2008 12:38 pm
Hi everyone,
I am developing a classifieds website using php and mysql and this is my first major project... I designed a layout for the database and the image is attached to this question, just have a look....
This is how the db works...I am telling this so that people will have an easier time understanding the layout:
1.'Listing Table' is the main table. This is the table I am going to depend upon to display and/or categorize my listings...
2. Using Listing ID, I'll be able to track the user info of the person who posted the listing, and the 'Type' of customer he is (Premium, Silver or Free)
3. I'll also be able to track which sub-category it belongs to, and to which category *that* sub category belongs to.
4. Also will be tracked the price range of the property (this is a real estate classifieds), and the 'Class' (Buying,selling or renting are classes).
5. Is this the right way to do it? Are there flaws in my layout? Please do answer these questions for me, as I dont have a know-it-all boss to guide me thru...I am pretty much on my own, and of course I gratefully depend upon angelic souls like you to help me out....
Please do have a look and tell me what you think about it....thanx...
I am developing a classifieds website using php and mysql and this is my first major project... I designed a layout for the database and the image is attached to this question, just have a look....
This is how the db works...I am telling this so that people will have an easier time understanding the layout:
1.'Listing Table' is the main table. This is the table I am going to depend upon to display and/or categorize my listings...
2. Using Listing ID, I'll be able to track the user info of the person who posted the listing, and the 'Type' of customer he is (Premium, Silver or Free)
3. I'll also be able to track which sub-category it belongs to, and to which category *that* sub category belongs to.
4. Also will be tracked the price range of the property (this is a real estate classifieds), and the 'Class' (Buying,selling or renting are classes).
5. Is this the right way to do it? Are there flaws in my layout? Please do answer these questions for me, as I dont have a know-it-all boss to guide me thru...I am pretty much on my own, and of course I gratefully depend upon angelic souls like you to help me out....
Please do have a look and tell me what you think about it....thanx...