On Mar 26, 2011, at 8:33 AM, Jacques Le Roux wrote: > I don't see any problems but one question inline > BTW, I think BJ would have loved that :o) > > Jacques > > David E Jones wrote: >> I'm writing this to start a thread to discuss: >> >> If you could change ANYTHING in the OFBiz data model, what would it be? >> >> To kick this off here are some ideas I've compiled that have come up over >> the years (many based on feedback from people on this >> mailing list), or that I thought of recently will working on this topic. You >> can see them below... >> >> -David >> >> ======================================================== >> >> - Rename *Role entities to *Party >> - Remove *Attribute and *TypeAttr entities (not generally a good practice to >> use) >> - Remove all status history (*Status) and just using audit on the statusId >> field >> - ProductPrice add quantity breaks, change PK to single field sequenced >> - Get rid of QuantityBreak and use the two simple fields instead in each >> place used >> - Get rid of ProdCatalog*, rework it to ProductStoreCategory, ie directly >> associate to the store > > Rename ProdCatalog* to ProductStoreCategory (only 1 entity?) and add field > for an association with store?
It wasn't "Rename ..." it was get rid of all of the ProdCatalog* entities and use a single ProductStoreCategory entity instead. The concept of "catalogs" always seems to have been confusing for people, and serves little purpose. There are also issues with the cart when switching catalogs, etc. The new ProductStoreCategory entity would be based on the ProdCatalogCategory entity, but associate various categories directly with the store instead of going through a catalog. -David
