Overview
The Data Model page provides a visual graph of all objects in your auction and the associations (relationships) between them. Use it to understand how your data connects and to create new associations that enable cross-object queries in the Query Builder.Visual Graph
See all objects and their connections at a glance
Association Builder
Create relationships between any two objects
Standard Objects
Built-in objects like Check-In Records and CR Inspections
Custom Objects
Your auction-specific objects (Dealerships, Fleets, etc.)
Permission Requirements
| Action | Owner | Admin | Team Member |
|---|---|---|---|
| View Data Model | Yes | Yes | No |
| Create Associations | Yes | Yes | No |
| Edit Associations | Yes | Yes | No |
| Delete Associations | Yes | Yes | No |
System associations (pre-configured relationships between standard objects) are read-only and cannot be modified or deleted.
Accessing the Data Model
Understanding the Graph
The data model graph displays objects as nodes and associations as connecting edges.Node Types
| Node | Icon | Description |
|---|---|---|
| Standard Objects | Table icon | Built-in objects (Check-In Records, CR Inspections, Lot Submissions, etc.) |
| Custom Objects | Shapes icon | Your auction-specific objects created in Custom Objects |
Edge Types
| Edge Style | Meaning |
|---|---|
| Solid line with lock | System association (read-only, pre-configured) |
| Solid line | Auction-specific association (editable) |
Standard Objects
These are the built-in queryable objects available in every auction:| Object | Table | Description |
|---|---|---|
| Check-In Records | check_in_records | Vehicle arrival data |
| CR Inspections | cr_inspections | Condition report data |
| Lot Submissions | lot_submissions | Parking lot count submissions |
| Quality Inspections | quality_inspections | Vehicle quality inspections |
| Problem Reports | problem_reports | A3 rock reports |
| Locations | locations | Parking lot/facility locations |
| Users | users | Team members |
| Channels | channels | Chat channels |
Creating an Association
Connect two objects with a labeled relationship.Choose Relationship Type
Select the type of relationship:
| Type | Meaning | Example |
|---|---|---|
| One to Many | One source record relates to many targets | One dealership has many check-ins |
| Many to Many | Records on both sides can have multiple links | Vehicles can belong to multiple fleets |
Each association must have a unique combination of from-object, to-object, and label within your auction. You can create multiple associations between the same two objects with different labels.
Association Examples
| From | To | Label | Use Case |
|---|---|---|---|
| Check-In Records | Dealerships | Primary Dealership | Track which dealership each vehicle came from |
| CR Inspections | Vendors | Assigned Vendor | Link inspections to third-party service providers |
| Fleets | Dealerships | Fleet Partner | Associate fleet companies with their dealer network |
Editing an Association
Modify the label or relationship type of an existing auction-specific association.Deleting an Association
Remove an auction-specific association.Cross-Object Queries
Associations power the cross-object join capability in the Query Builder. When you create an association between two objects, you can query across both in a single natural language question.How It Works
- You create an association between “Check-In Records” and “Dealerships”
- In the Query Builder, select “Check-In Records” as your primary data source
- The “Join with other objects” section shows “Dealerships” as an available join
- Select it, and fields from both objects become available for your query
- Ask a question like “Show check-in counts by dealership region”
Join Types
When joining objects in the Query Builder:| Join Type | Behavior |
|---|---|
| LEFT JOIN (default) | Include all records from the primary object, even if no match exists in the joined object |
| INNER JOIN | Only include records that have a match in both objects |
Best Practices
Use Descriptive Labels
Use Descriptive Labels
Association labels appear in the Query Builder’s join selector. Use clear, descriptive labels like “Primary Dealership” rather than generic ones like “Link 1”.
Start with Key Relationships
Start with Key Relationships
Focus on the relationships that will be most useful for analytics. You don’t need to associate every object with every other object.
Leverage System Associations
Leverage System Associations
System associations between standard objects (e.g., Check-In Records ↔ CR Inspections via VIN) are already configured. Build on these with custom associations to extend your data model.