0

I am trying to design a database to post free ads. Eg http://www.gumtree.com.au/p-post-ad.html

Scenario: Every ad will have different categories and some categories will have further sub categories. SO the table AD will have different fields depending on its category. For example, an ad for used car will have MAKE, MANUFACTURER etc but an ad for books will have Book title field, Author field etc.

SO how do I design the table for ads?

I can possibly think of two solutions. One, to create subtypes for categories in table ad. Two, to create individual table for each categories of ad (this does not sound like a good design).

Deeyo
  • 27
  • 3
  • 9
  • possible duplicate of [product with multiple category type database schema](http://stackoverflow.com/questions/32011621/product-with-multiple-category-type-database-schema) – Walter Mitty Aug 28 '15 at 10:45
  • See http://stackoverflow.com/questions/21010251/inventory-management-with-stock-options/21113170#21113170 – Mohsen Heydari Sep 01 '15 at 12:07

0 Answers0