This sub-thread is fascinating. On the pet service business, it sounds like there might be more tables due to some kind of object polymorphism on a per customer basis? Are there any other "per-whatever" expansion factors that are multiplying your table count?
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).
Yup. When I used RPG400 we'd use the first 4 columns for revision numbers as they were originally reserved on the punched cards but not used on the editor...
Nope. Sorry, but lots of cities have very expensive housing in the center where rich people live. I will start with NYC, San Francisco, LA, London, Sydney, Boston, Melbourne, Hong Kong, Toronto, Paris, Barcelona, Madrid, Prague, Munich, Berlin, Rome, Amsterdam, Copenhagen...
Similar situation here. Separating the concept of humans from food providers has been very beneficial in our household. We still give the cats a lot of attention.
Had similar problems with our cat who was able to retrieve food from every automatic feeder we tried, apart from the perfect pet feeder [1] which was the only model that defeated him.
