CrmPicklistItem
Unified admin-editable CRM picklist entry (deal stages, lead sources, activity types — see com.motorph.payroll.constants.CrmPicklistKinds).
| Table | crm_picklist_item |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 11 |
| Relationships | 0 |
| Source | backend/src/main/java/com/motorph/payroll/model/CrmPicklistItem.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
itemId | Integer | item_id | — | primary key, generated |
kind | String | kind | — | — |
name | String | name | — | — |
color | String | color | Yes | — |
sortOrder | Integer | sort_order | — | — |
isActive | Boolean | is_active | — | — |
defaultProbability | Integer | default_probability | Yes | — |
isWon | Boolean | is_won | — | — |
isLost | Boolean | is_lost | — | — |
createdAt | LocalDateTime | created_at | — | — |
updatedAt | LocalDateTime | updated_at | Yes | — |
Plus tenant_id, inherited from TenantOwned. Hibernate stamps it on insert and adds where tenant_id = ? to every query, so it is never written or read by application code.
Repository
CrmPicklistItemRepository
Declared over CrmPicklistItem with id type Integer, with JpaSpecificationExecutor for dynamic filtering. Source: backend/src/main/java/com/motorph/payroll/repository/CrmPicklistItemRepository.java
| Method | Returns | Notes |
|---|---|---|
findAllByKindOrderBySortOrderAscNameAsc(String kind) | List<CrmPicklistItem> | derived |
findAllByKindAndIsActiveTrueOrderBySortOrderAscNameAsc(String kind) | List<CrmPicklistItem> | derived |
existsByKindAndName(String kind, String name) | boolean | derived |
countByKindAndIsActiveTrue(String kind) | long | derived |
Reached by
These controllers hold — directly or through a service they depend on — a repository over CrmPicklistItem.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| CrmActivityController | /api/crm/activities | 5 | CRM |
| CrmDealController | /api/crm/deals | 11 | CRM |
| CrmLeadController | /api/crm/leads | 7 | CRM |
| CrmPicklistController | /api/crm/picklists | 4 | CRM |
| CrmSettingsController | /api/crm/settings | 3 | CRM |
| PublicSignupController | /api/public/signup | 2 | Billing & Platform |
| TenantAdminController | /api/admin/tenants | 7 | Billing & Platform |
This page is rebuilt from the source on every docs build by docs-site/scripts/gen-code-wiki.mjs. Editing it has no effect — change the code, or, if what you want to say is prose, write it in docs/.