Zoho CRM's underlying data model is a relational, multi-tenant cloud database where records, fields, modules, and their relationships are exposed visually through the Data Model feature (Zoho CRM Data Model documentation).
Data Model Feature
Accessible via Developer Hub → Data Model, this is a visual, interactive schema map of the entire CRM organization's data structure. Key capabilities:
- Entity Types Shown: Modules, custom modules, subforms, linking modules (many-to-many join tables), and picklist history.
- Relationship Visualization: Single-line = one-to-one (lookup); multi-line = many-to-one (multi-select lookup).
- Developer Mode: Exposes API names for modules and fields, and the data type of every field—without needing to query the API manually.
- Filter by Field Type: Administrators can filter the data model display by any of 23 supported field types.
- Automatic Updates: When modules are added, removed, or modified, the data model auto-regenerates. A "Generation in Progress" message appears during refresh.
- Mini-map and full-screen mode for navigating large schemas.
- Module Configuration shortcut: Hover over any entity at ≥75% zoom and click to open that module's layout editor directly.
The Data Model is primarily a read-and-navigate tool; changes are made via Module and Fields editor rather than from the diagram itself (Zoho CRM Data Model documentation).
Structural Entities
- Records: Individual data rows within a module (e.g., a single Lead or Deal).
- Modules: Analogous to database tables; each module has fields (columns) and records (rows).
- Fields: Typed attributes of a module; support 23+ distinct field types.
- Subforms: Embedded tables within a record; represent a one-to-many relationship owned by the parent module (e.g., line items on a Quote).
- Linking Modules: Auto-created join tables enabling many-to-many associations between two modules.
- Picklist History: Tracked as a first-class entity in the data model; enables reporting on how picklist values evolve over time.