Build a Simple CRM Data Model

Quoted on this wiki

Every place a page here uses this source, in the order the words come in it.

1. Note: The many-to-many relationship has to be modeled as two many-to-one relationships, as demonstrated in the following diagram. For instance, the relationship between the prospects and employees is a many-to-many relationship. The same rule also applies to the customer-employee relationship. “A prospect is linked to more than one employee, and one employee is related to multiple prospects or leads.” Lastly, the relationship between the Prospect and Customer is a one-to-one relationship.

   In Prospect list schema

Quotes are verbatim and belong to their publishers. Where a quote has been translated, the original wording is kept below it.