Re: Data modeling for a multi-company product
Date: 24 Jan 2007 07:17:23 -0800
Message-ID: <1169651843.114323.253620_at_v33g2000cwv.googlegroups.com>
Or....
Customer A could consider using a database modeled after customer A's business and customer B could consider using a database modeled after customer B's business.
On Jan 23, 3:38 pm, "dawn" <dawnwolth..._at_gmail.com> wrote:
> One feature of some ERP and other software application systems is the
> ability for the customer site to indicate in the setup which attributes
> are required and which are not related to the various data entry
> "screens." So, customer A might consider birthdate to be a required
> "field" when a user is entering data into the XYZ screen/form while
> customer B does not.
>
> When I was reading about designing for the elimination of NULLs, it
> struck me that I was not sure how to prepare an elegant logical data
> design if the exact same software is to be deployed to multiple
> customer sites with the customer having this option. This means that
> other than "primary keys" (those used to create new or lookup existing
> information) almost all attributes are optional.
>
> How do SQL-based ERP solutions and other software to be deployed to
> multiple companies model the data for this feature? Do any ERP or
> other multi-company software solutions come close to doing this
> "properly" with no nullable attributes? Do they then have a separate
> table for each attribute where it is possible for a site to configure
> it as not being required? Maybe I'm confusing some issues here, so any
> clues would be appreciated.
>
> Thanks. --dawn
Received on Wed Jan 24 2007 - 16:17:23 CET