Skip to main content

382 docs tagged with "database"

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 Aggregate Storage

Source-confirmed storage model for the Employee root, employment values, assignments, profile collections, notes, documents, and timeline.

Employee Database

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

Employee Database Schema Reference

Verified inventory of Employee contexts, persisted objects, relationships, indexes, tenant rules, migrations, transaction participants, and Legacy persistence.

Employee Outbox Storage

Transactional outbox persistence, processing state, and delivery boundaries for Employee domain changes.

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.

Helpdesk Database Limitations

Verified persistence limitations grouped by persistence, concurrency, tenancy, transactions, compatibility, testing, governance and retention.

Helpdesk DbContexts

Authoritative inventory of runtime and design-time Helpdesk context behavior.

Holiday Storage

Verified tenant Holiday persistence and calculation relationship.

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.

LMS Course Storage

Draft source-backed lms course storage for HR Suit Learning Management System.

LMS Outbox Storage

Draft source-backed lms outbox storage for HR Suit Learning Management System.

LMS Session Storage

Draft source-backed lms session storage for HR Suit Learning Management System.

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 Broker Topology

Source-backed broker topology for Notification — exchange, queue, bindings, prefetch, connection resilience and the unwired dead-letter names.

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 Consolidated Reference

Consolidated source-backed reference of Notification routes, operational endpoints, configuration sections, logs, diagnostics and supporting scripts.

Notification Consumed Events

Authoritative source-backed inventory of all 42 integration event types the Notification Service consumes, with template keys, channels and recipients.

Notification Consumers

Source-backed description of the single hosted consumer — its lifecycle, scoping, acknowledgement behavior and failure handling.

Notification Data Retention

Verified absence of retention, cleanup and archival in Notification persistence, and the unbounded growth characteristics that follow.

Notification Database Documentation

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

Notification Database Limitations

Verified Notification database limitations grouped by persistence, concurrency, tenant isolation, transactions, retry, testing, governance, retention and schema evolution.

Notification Database Overview

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

Notification Database Tenant Isolation

Source-backed tenant isolation in Notification persistence — the absent global filter in the extracted service versus the query filters in the monolith.

Notification Database Testing

Source-backed database test coverage for Notification — smoke-script persistence assertions only, with no mapping, migration or repository tests.

Notification DbContexts

Verified inventory of every persistence context that maps Notification data, its DbSets, filtering and save behavior.

Notification Delivery Storage

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

Notification Development Seeding

Source-backed seeding behavior for Notification — the idempotent global default-template seeder, its coverage and its configuration toggle.

Notification Diagnostics

Source-backed diagnostic surfaces for Notification — audit trail, attempts, idempotency lookup, statistics and the test hooks.

Notification Domain Events

Verified absence of a domain-event model in the Notification Service and the direct-mutation approach used instead.

Notification Entity Mappings

Source-backed fluent mapping configuration for Notification entities — table names, lengths, required flags, column types and what is deliberately not configured.

Notification Entity Relationships

Verified absence of declared relationships in the Notification model and the logical associations that identifier columns imply instead.

Notification Event Architecture

Source-backed event-driven architecture of Notification — publisher and consumer responsibilities, broker participation and delivery flow.

Notification Event Compatibility

Source-backed compatibility posture of the Notification event surface — contract coupling models, orphan templates and the legacy path that bypasses events entirely.

Notification Event Correlation

Source-backed correlation identifier flow through Notification event processing, including activity propagation and the effective-correlation gap.

Notification Event Envelope

Source-backed structure of the NotificationEventEnvelope, how it is built from AMQP properties and headers, and which fields are unused.

Notification Event Handlers

Source-backed description of the single resolver that maps consumed events to notification intents, and the dispatcher that executes them.

Notification Event Idempotency

Source-backed duplicate detection in Notification — the processed-event ledger, the staleness guard and the verified failure windows.

Notification Event Limitations

Verified Notification event limitations grouped by publishing, consumption, broker, retry, dead-letter, ordering, idempotency, versioning and testing.

Notification Event Source Map

Verified traceability from every Notification event documentation topic to the backend source files that evidence it.

Notification Event Testing

Source-backed event test coverage for Notification — direct and broker smoke modes and the forced-failure hook — separated from recommended coverage.

Notification Event Versioning

Source-backed event schema versioning in Notification — the version field is carried end to end but never branched on.

Notification Events Overview

Source-backed overview of the Notification event surface — consumption-only participation, counts and current maturity.

Notification FAQ

Source-backed answers to common Notification questions covering delivery, channels, templates, preferences, retry and operations.

Notification Health Reference

Source-backed health surface for Notification — the health endpoint with no registered checks, and what it does and does not prove.

Notification Idempotency Storage

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

Notification Inbox

Source-backed behavior of the employee notification inbox screen and the header bell widget — filters, actions, polling and categorisation.

Notification Message Ordering

Verified absence of ordering guarantees in Notification event consumption and the factors that break sequential processing.

Notification Message Storage

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

Notification Migrations

Source-backed migration inventory for Notification — one migration, one snapshot, a design-time factory and automatic startup migration.

Notification Monitoring

Source-backed monitoring surface for Notification — what can be observed today, and the verified absence of metrics and alerting.

Notification Operational Runbooks

Source-backed operational procedures for Notification — verifying consumption, re-driving failures, changing templates and channels, and recovering from a broker outage.

Notification Preference Storage

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

Notification Preferences

Verified absence of any notification preferences user interface, and the enforcement-only preference model that exists behind it.

Notification Published Events

Verified absence of published business events in the Notification Service and the single test-only publish path that exists instead.

Notification Publishers

Source-backed description of the shared event-bus publisher available to Notification and the single test-only path that uses it.

Notification Query Patterns

Source-backed catalog of every Notification persistence query — tracking behavior, predicates, ordering and result limits.

Notification Recipient Storage

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

Notification Retry and Redelivery

Source-backed distinction between in-process delivery retry and broker-level redelivery in Notification, and the unbounded requeue behavior.

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 Schema Reference

Authoritative source-backed schema reference for Notification — every verified table, its columns, constraints and indexes, each appearing exactly once.

Notification Template Storage

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

Notification Troubleshooting

Source-backed troubleshooting for Notification covering missing notifications, delivery failures, broker connectivity, template, health, startup and configuration issues.

Notification UI Overview

Source-backed overview of every Notification screen, route, navigation entry and the portal each belongs to.

Notification User Experience

Source-backed employee journey through notifications — discovery, reading, acting and the verified gaps in feedback.

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.