Design database diagram (ERD) for c2c website
Budget: $10 – $30 CAD
1. The site would have users who can list the advertisement (sellers) as well as contact other users for their ads (buyers). These user profiles would have name, address, contact info, username, password etc.
2. There are major advertisement categories and sub-categories. There will be 100s of sub-categories for the major categories (no nesting in the sub-categories further)
3. All the ads will have common attributes - description, images, address/location.
4. All the ads will also have their category specific attributes -
Example: An ad under "Bikes" category would have different detail attributes (Brand, condition etc.) than an ad under "Cars" (Odometer, Year, make, model etc.) That means when a seller is trying to list a new product, the web form would present only fields related to selected subcategory. When another user opens this product listing, they would see a generic "Description" section as well as "Details" section showing category specific attributes for that ad.
5. The ads can also be filtered/grouped by the address (State, City, Area, etc.) based on where user has listed it to show.
6. This will be modeled using pure Django, so please provide the design based on its feasibility with Django ORM and explanation for the same.
2. There are major advertisement categories and sub-categories. There will be 100s of sub-categories for the major categories (no nesting in the sub-categories further)
3. All the ads will have common attributes - description, images, address/location.
4. All the ads will also have their category specific attributes -
Example: An ad under "Bikes" category would have different detail attributes (Brand, condition etc.) than an ad under "Cars" (Odometer, Year, make, model etc.) That means when a seller is trying to list a new product, the web form would present only fields related to selected subcategory. When another user opens this product listing, they would see a generic "Description" section as well as "Details" section showing category specific attributes for that ad.
5. The ads can also be filtered/grouped by the address (State, City, Area, etc.) based on where user has listed it to show.
6. This will be modeled using pure Django, so please provide the design based on its feasibility with Django ORM and explanation for the same.