ChartCraft
Open studio
ER Diagram Updated 4/16/2026

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.

ER DiagramCRM databaseSales pipelineDeal trackingData modeling
10 nodes 10 connections

Related diagrams

More examples with overlapping tags

ER Diagram 4/18/2026

University Course Enrollment ER Diagram

An ER Diagram for a university enrollment system, mapping how students with email and status enroll in courses identified by code and credit hours, while professors teach those courses and enrollments store semester and grade. It is used to design and validate the academic database, helping teams manage student registration, teaching assignments, and grade tracking. Typical users include database designers, developers, registrars, and academic operations staff.

ER DiagramUniversityStudent RecordsCourse EnrollmentAcademic Database
ER Diagram 4/17/2026

Banking System ER Diagram for Customers, Accounts, Transactions, Loans & Branches

This ER diagram is used to design and validate a banking database by mapping how customers relate to accounts through CustomerAccount (supporting joint ownership and roles), how branches hold many accounts and issue loans, and how accounts post transactions. It helps teams enforce referential integrity, model loan servicing via LoanPayment tied to both Loan and Transaction, and plan reporting across customers, branches, balances, and repayments. It’s used by database architects, backend engineers, and analysts.

ER diagrambanking systemdatabase schematransactionsloan management
ER Diagram 4/16/2026

University ER Diagram for Students, Courses, Enrollments, Professors, and Grades

This ER diagram is used to design a university database that connects students to courses through enrollments, links each course to the professor who teaches it, and records detailed grade items per enrollment. It helps ensure correct keys and relationships for tracking rosters by term, enrollment status, and grading outcomes (scores and letters). Database designers, campus IT teams, and registrar or academic operations staff would use it to build and validate student information and reporting systems.

ER DiagramUniversity databaseCourse enrollmentStudent recordsGrades