CRM ER Diagram for Contacts, Companies, Deals, Activities, and Pipelines

This ER diagram is used to design a CRM database that links Contacts and Companies via CompanyContact, tracks Deals within a Pipeline and PipelineStage, and ties Deals to people and accounts through DealContact and DealCompany. It helps teams enforce clear relationships, support reporting like deal value by stage, and keep activities organized using Activity with flexible ActivityAssociation links. Product builders, database designers, and CRM admins would use it to implement and maintain the schema.