Data Blueprints
CRUD, storage, versioning, and data management blueprints.
| Blueprint | Description | Version |
|---|---|---|
| Bank Reconciliation | Bank reconciliation with statement import, auto/manual matching, reconciliation models, partial/full tracking, and write-off management. | 1.0.0 |
| Comments Annotations | Threaded comments on any entity (polymorphic) with rich text, @mentions, reactions, edit windows, and rate limiting | 1.0.0 |
| Content Articles | Blog and news article system for advisors and portfolio managers to publish market insights, product updates, and investment articles to clients | 1.0.0 |
| Content Tree | Hierarchical content tree with zone-based storage, tree walking, flattening, indexed lookups, and schema migration | 1.0.0 |
| Customer Supplier Management | Customer and supplier master data management with credit limits, territory and group hierarchies, portal access, lead conversion, internal parties, and supplier hold/block controls. | 1.0.0 |
| Data Import Export | Bulk data import and export supporting CSV, Excel, and JSON formats with column mapping, row validation, background processing, and configurable error handling | 1.0.0 |
| Data Retention Policies | Hierarchical message and file deletion policies that automatically remove content older than configured retention periods, with granular overrides per workspace or channel. | 1.0.0 |
| Device Status Tracking | Continuously monitor whether GPS devices are actively reporting, and automatically transition them between online, offline, and unknown states based on configurable inactivity thresholds, emitting … | 1.0.0 |
| Document Management | Store, retrieve, manage, and generate documents with metadata, permissions, version control, and dynamic PDF generation | 1.0.0 |
| Driver Identification | Identify the driver operating a vehicle by matching hardware-reported credentials (RFID tag or iButton key) against a registry of named drivers, and emit an event whenever the driver assignment cha… | 1.0.0 |
| Editor State | Centralized state management with sliced architecture, action dispatching, computed selections, and public API | 1.0.0 |
| Encrypted Attachment Storage | Issue signed upload descriptors so authenticated clients can upload client-side encrypted attachments directly to cloud object storage, with server-enforced size limits and dual rate limiting | 1.0.0 |
| Engine Hours Tracking | Accumulate the total time a vehicle engine has been running by measuring the duration between consecutive positions while the ignition is on, providing accurate engine-hours data for maintenance sc… | 1.0.0 |
| Eta Calculation | Calculate estimated time of arrival and driving distance between two geographic points, supporting both preliminary (straight-line) and precise (routing-based) calculations. | 1.0.0 |
| Expense Approval | Submit and approve employee expense reports with receipt validation | 1.0.0 |
| Field Transforms | Per-field-type transformation pipeline with read-only path resolution, async tracking, and trigger-based caching | 1.0.0 |
| File Storage | Cloud storage abstraction with signed URLs, virus scanning, content type validation, checksum deduplication, and multi-provider support | 1.0.0 |
| Fuel Level Reporting | Read fuel sensor data transmitted by GPS hardware, detect significant fuel drops (theft or fast consumption) and unexpected increases (refuelling), and provide fuel consumption summaries across tri… | 1.0.0 |
| Gdpr Data Export | Complete workspace data export for GDPR right-to-portability, compliance archival, and migration purposes, producing a JSONL stream with optional ZIP packaging of all messages, files, users,… | 1.0.0 |
| General Ledger | Manage hierarchical chart of accounts and post double-entry general ledger entries with period controls, cost center tracking, and party-level accounting | 1.0.0 |
| Geofence Management | Define named geographic boundary zones as circles (centre point + radius) or polygons (closed coordinate ring), optionally with altitude constraints and calendar-based activation schedules, and eva… | 1.0.0 |
| Geofencing Regions | Define named circular regions by centre coordinates and radius; automatically detect when a tracked device enters or leaves each region and emit transition events. | 1.0.0 |
| Gps Device Registration | Register and identify GPS tracking devices by unique hardware ID (IMEI or custom identifier), with per-device metadata, grouping, and lifecycle management. | 1.0.0 |
| Gps Position History | Query, replay, and export the historical sequence of GPS positions recorded for one or more devices over a user-specified time range, supporting route visualisation, speed analysis, and multi-forma… | 1.0.0 |
| Ignition Detection | Detect transitions in vehicle ignition state by comparing the ignition attribute between consecutive position records, and emit ignition-on and ignition-off events to drive engine hours calculation… | 1.0.0 |
| Legal Hold | Preservation order that suspends automated deletion of specific communications, files, and user data pending litigation, regulatory investigation, or legal request, overriding any data retention… | 1.0.0 |
| List Queue Operations | Ordered collection with efficient head/tail insertion, removal, and range queries; supports blocking operations and atomic moves between lists | 1.0.0 |
| Location History Storage | Store device location records in append-only monthly logs, maintain a last-known-position snapshot per device, and serve time-range queries in multiple output formats without an external database. | 1.0.0 |
| Media Repository | Upload, store, retrieve, and auto-thumbnail media files. Cache remote media locally, enforce size limits, support multiple storage backends, and run retention cleanup tasks. | 1.0.0 |
| Odometer Tracking | Track cumulative vehicle mileage either by reading the hardware odometer transmitted by the GPS device or by calculating distance from GPS coordinates, with per-position incremental distances and a… | 1.0.0 |
| Openclaw Session Management | Persistent conversation storage with automatic disk budgeting, transcript rotation, and session lifecycle tracking across messaging channels | 1.0.0 |
| Pagination | Cursor-based and offset-based pagination with configurable page sizes, stable sorting, and Link header support for REST APIs | 1.0.0 |
| Payload Collections | Full CRUD operations for document collections with pagination, filtering, hooks, bulk operations, and field selection | 1.0.0 |
| Payload Document Locking | Automatic document locking to prevent concurrent editing with configurable lock duration and override capability | 1.0.0 |
| Payload Globals | Singleton document management for site-wide settings, navigation, headers, and footers with versioning and access control | 1.0.0 |
| Payload Preferences | Per-user preferences storage for admin UI state including collapsed fields, tab positions, column visibility, sort order, and list view settings | 1.0.0 |
| Payload Uploads | File upload system with image resizing, focal-point cropping, MIME validation, cloud storage adapters, and range request support | 1.0.0 |
| Payload Versions | Document versioning with draft/publish workflow, autosave, version history, restore, scheduled publishing, and locale-specific status | 1.0.0 |
| Popia Compliance | South African POPIA (Act 4 of 2013) reference — eight conditions for lawful processing, data subject rights, breach notification, direct marketing, automated decisions, transborder transfers. | 1.0.0 |
| Portfolio Management | Retrieve, manage, and report on investment portfolio holdings, positions, valuations, and transaction history | 1.0.0 |
| Prisma Crud | Execute type-safe database CRUD operations with Prisma Client query builder | 1.0.0 |
| Prisma Migrations | Manage database schema versioning and evolution with safe migrations | 1.0.0 |
| Prisma Schema | Define application data models with fields, types, relationships, and validation rules in Prisma schema | 1.0.0 |
| Product Configurator | Product configuration with attributes, variant generation, exclusion rules, dynamic pricing, visual pickers, custom inputs, and matrix bulk ordering. | 1.0.0 |
| Proof Of Delivery | Capture proof of pickup or drop-off for an order or specific waypoint/entity, supporting digital signature, photo upload, and QR code scan as verification methods. | 1.0.0 |
| Proposals Quotations | Creation, management, and approval workflow for investment proposals and quotations delivered to clients | 1.0.0 |
| Search And Filtering | Full-text search with faceted filters, sorting, relevance scoring, fuzzy matching, and saved searches | 1.0.0 |
| Service Zones | Define geographic service areas and subdivide them into operational zones, used to scope fleet operations, restrict order pickup and drop-off, and assign drivers to specific areas. | 1.0.0 |
| Set Operations | Unordered collection of unique elements with set algebra operations (union, intersection, difference) and cardinality counting | 1.0.0 |
| Shared Location Friends | Allow devices to receive the last-known positions and profile cards of a curated friend list when polling for location updates, enabling shared-location without direct device-to-device communication. | 1.0.0 |
| Soft Delete | Trash/archive/restore pattern with soft deletion, configurable retention periods, automatic purging, and cascade rules for related records | 1.0.0 |
| Sorted Set And Hash Operations | Sorted collections with ranking and scoring; nested key-value maps with field-level operations and optional TTL per field | 1.0.0 |
| Stream Event Log | Append-only event log with monotonically increasing IDs, consumer groups for distributed processing, and automatic acknowledgment tracking | 1.0.0 |
| String Key Value | Store and retrieve arbitrary-length string values with atomic increment, decrement, append, and range operations | 1.0.0 |
| Tagging Categorization | Tags, labels, and hierarchical categories for organizing entities with tag groups, colors, slug auto-generation, and category depth limits | 1.0.0 |
| Tax Engine | Tax engine with percentage, fixed, division, group, and formula-based tax types, repartition, cash-basis accounting, and fiscal position mapping. | 1.0.0 |
| Trip History | Persistent history of completed and past trips per rider and per driver, including tracking numbers, activity timelines, and position trails for audit and replay. | 1.0.0 |
| Undo Redo | Linear history stack with debounced recording, forward-branch destruction, and keyboard shortcut navigation | 1.0.0 |
| Visited Places Detection | Automatically clusters stationary GPS points into candidate visit records, merges adjacent stays at the same location, and surfaces them for user confirmation or dismissal. | 1.0.0 |