Skip to main content

232 docs tagged with "persistence"

View all tags

Appraisal Storage

Source-backed persistence mapping and child ownership for the appraisal aggregate.

Asset Compatibility Backfill

Source-backed account of the transitional ETL that copies monolith asset records into the Asset Service while preserving compatibility identity.

Asset Concurrency

Source-backed statement of the Asset Service's concurrency posture — no concurrency token or locking, only lifecycle re-checks, callback idempotency, and unique indexes, which reduce but do not guarantee safety.

Asset Data Integrity

Source-backed map of Asset integrity controls across domain invariants, application checks, database constraints, and unenforced expectations, with a classification matrix.

Asset Database Limitations

Consolidated source-backed persistence limitations and areas requiring confirmation for Asset Management.

Asset Database Overview

Source-backed overview of asset persistence technology, ownership, and verified model totals.

Asset Database Testing Guide

Source-backed inventory of existing asset persistence test evidence and a separated catalog of recommended future database coverage.

Asset DbContext and Object Sets

Source-backed description of AssetDbContext and a verified inventory of its seven object sets, their CLR types, persistence purpose, classification, tenant scope, and keys.

Asset Development Seeding

Source-backed account of the Development-only asset seeder: its trigger, environment restriction, idempotency marker, and seeded categories.

Asset Entity Mappings

Source-backed EF Core mappings for every persisted Asset entity — tables, keys, required properties, enum conversions, owned values, indexes, generated values, jsonb columns, and ignored members.

Asset Indexes and Constraints

Source-backed inventory of every Asset non-primary-key index and database constraint, with uniqueness, composition, tenant participation, and missing expected constraints.

Asset Keys and Relationships

Source-backed inventory of Asset primary keys, unique keys, enforced foreign-key relationships, and identifier-only cross-service references that are not database relationships.

Asset Migrations and Snapshot

Source-backed account of the Asset Service migration history, model snapshot, rollback method, and startup migration behavior.

Asset Ownership and Boundaries

Source-backed data-ownership map for the Asset bounded context: what the Asset Service owns outright versus what it only references across service boundaries.

Asset Persistence Architecture

Source-backed flow of how Asset write and read operations reach PostgreSQL: endpoints, commands, repository and unit of work, DbContext, aggregate, evidence writers, outbox staging, and external calls kept outside the transaction.

Asset Query Patterns

Source-backed inventory of Asset EF Core read patterns — tenant filtering, includes, ordering, capped reads, in-memory processing, and the indexing and pagination gaps they expose.

Asset Retention and Cleanup

Source-backed account of deletion, retention, and cleanup behavior across every Asset Service persisted object.

Asset Storage

Source-backed persistence of the canonical Asset aggregate, its columns, owned values, lifecycle state, and integrity gaps.

Asset Tenant Isolation

Source-backed tenant isolation for Asset persistence — EF global query filters, explicit backfill predicates, header/claim trust, and the absence of database-enforced isolation.

Asset Transactions and Save Boundaries

Source-backed description of the Asset single-transaction save model, what commits together, where external HTTP calls sit relative to the transaction, and failure behavior.

Asset Value-Object Conversions

Source-backed inventory of the four persisted Asset value objects — their scalar columns, validation, equality semantics, query and index implications, and the non-persisted computed members.

Assignment History Storage

Source-backed persistence of the append-only asset assignment-history child rows, their key, columns, indexes, and immutability.

Attendance Database

Source-backed guide to Attendance Service data ownership, persistence, tenancy, migrations, integrity, and testing.

Attendance Outbox Storage

Transactional outbox persistence, relay state, and delivery boundary for Attendance integration events.

Audit and Timeline Storage

Source-backed persistence of the asset audit-log and timeline evidence tables, their columns, tenant filtering, and save-boundary participation.

Compatibility Identity Storage

Source-backed behavior of the CompatId compatibility identity on the Asset aggregate — runtime identity generation, backfill verbatim insertion, uniqueness, and lookup.

Concurrency

Verified duplicate protection, missing concurrency tokens, overlap races, and failure modes.

Data Integrity

Source-backed data integrity for HR Suit onboarding and offboarding.

Database Limitations

Verified Workforce Scheduling database limitations grouped by required review area.

Database Overview

Source-backed database overview for HR Suit onboarding and offboarding.

Database Overview

Persistence ownership, bounded contexts, systems of record, and maturity.

Database Source Map

Traceability map from Workforce Scheduling database topics to verified source files.

Database Testing

Verified migration, mapping, repository, backfill, parity, and missing database test coverage.

DbContext Inventory

Authoritative inventory of every verified DbContext relevant to Workforce Scheduling.

Document Reference Storage

Source-backed persistence of asset document-reference child rows that point at externally-owned Document Service content without storing bytes.

Employee Database

Source-confirmed Employee Service persistence ownership, schema, tenancy, migrations, integrity, and compatibility boundaries.

Employee Infrastructure Layer

Source-confirmed persistence, repositories, search, tenant context, audit, outbox, and background-processing behavior.

Entity Mappings

Source-backed entity mappings for HR Suit onboarding and offboarding.

Entity Mappings

Verified fluent mappings for scheduling and calendar entities.

Goal Storage

Source-backed appraisalgoal child persistence, ownership, indexing, and integrity boundaries.

Helpdesk Database Documentation

Source-backed Helpdesk persistence, mappings, tenant isolation, migrations, transactions, concurrency, seeding and database testing documentation.

Holiday Storage

Verified Leave and legacy holiday persistence and absence from canonical scheduling.

Indexing and Query Patterns

Source-backed verified indexes and source-confirmed read, report, history, compatibility, and outbox access patterns.

Leave Database

Source-backed guide to Leave Service persistence, tenancy, migrations, integrity, and testing.

Migrations

Verified migration counts, model snapshots, design-time factories, and startup behavior.

Migrations and Seeding

Source-backed migration sequence, model snapshot, design-time support, and development-only seed behavior.

Notification Audit Storage

Source-backed persistence of the NotificationAuditLog table — the append-only stage trail, its 13 stages and its unbounded growth.

Notification Concurrency Control

Verified absence of concurrency control in Notification persistence and the specific race windows the unique indexes do and do not close.

Notification Database Documentation

Source-backed Notification persistence documentation covering the NotificationDb schema, entities, mappings, indexes, query patterns, transactions, migrations and seeding.

Notification Database Overview

Source-backed overview of Notification persistence: the owned database, schema, table count, index count and current maturity.

Notification Delivery Storage

Source-backed persistence of the NotificationDeliveryAttempts table — the append-only per-attempt record and its truncation behavior.

Notification Idempotency Storage

Source-backed persistence of the ProcessedIntegrationEvents table — the idempotency ledger, its unique constraint and its check-then-write race window.

Notification Message Storage

Source-backed persistence of the NotificationMessages table — columns, indexes, lifecycle and the absence of referential constraints.

Notification Preference Storage

Source-backed persistence of the NotificationPreferences table — the opt-out model, wildcard rows and the absence of any write path.

Notification Recipient Storage

Source-backed persistence of the NotificationRecipients table — the upsert-merge directory keyed by tenant, type and external reference.

Notification Retry Persistence

Source-backed persistence of retry state in Notification — attempt counters, attempt rows and the absence of a retry queue or dead-letter table.

Notification Template Storage

Source-backed persistence of the NotificationTemplates table — versioning, the global-default convention and the uniqueness constraint.

Offer Storage

Source-backed offer storage for HR Suit onboarding and offboarding.

Outbox Storage

Source-backed persistence of the transactional outbox table, its columns, save-boundary participation, and the polling relay that drains it.

Outbox Storage

Source-backed transactional outbox persistence, polling, uniqueness, and relay boundary.

Payslip Storage

Source-backed payslip storage for the HR Suit Payroll Service.

Processed Event Storage

Source-backed persistence of the processed-event idempotency ledger, modeled for future inbound consumption but unused at runtime today.

Processed Event Storage

Source-backed processedintegrationevent ledger mapping and current absence of a local consumer.

Query Patterns

Source-backed query patterns for HR Suit onboarding and offboarding.

Query Patterns

Verified repository and resolver query patterns for scheduling persistence.

Review Cycle Storage

Source-backed persistence mapping for the reviewcycle aggregate and its logical appraisal association.

Review Storage

Source-backed appraisalreview child persistence and stage-history behavior.

Shift Storage

Confirmed Shift persistence, compatibility identity, lifecycle, and assignment relationship.

Shift Storage

Canonical and legacy shift persistence, lifecycle, indexes, and audit behavior.

Tenant Isolation

Source-backed tenant isolation for HR Suit onboarding and offboarding.

Time Office Storage

Relationship model for shifts, weekly offs, policies, rules, and employee shift assignments.

Value Conversions

Verified enum, numeric, temporal, JSON, and compatibility value handling.

Weekly Off Storage

Tenant weekly-off representation, uniqueness, lifecycle, and relationship boundaries.

Workflow Reference Storage

Source-backed persistence of the workflow-instance reference on the Asset aggregate and the identifier-only boundary with the Workflow Service.