|
|
|
|
|
|
by icebraining
2969 days ago
|
|
|
A CRM+POS+ERP is pretty complex by itself, and being more configurable means more stuff is in the database vs the code. I work with a platform that also does CRM/POS/ERP (plus a bunch more), and the products alone have over 10 tables for describing them: the base products, their variants, a list of generic variant attributes, a table detailing which variants have which attributes, a table for specifying the values that those variants have of those attributes, the product categories, two tables for configuring the taxes applied to each product (on purchases and sales), the product images, the list of suppliers. We're already on 10 and we haven't even used those products for anything (stocking, selling, invoicing, purchasing, etc, etc). |
|
|