# 🗄️ Database

**Database Overview**







**Database Schema Overview**







**TypeORM Migrations**







**TypeORM Setup**







**MikroORM Setup**







**Query Builder Patterns**







**Database Indexing Strategy**







**Knex Setup**







**Connection Pooling**







**Migrations**







**Database Seeding**







**Soft Delete Patterns**







**Database Seeding**







**Multi-ORM Entities**







**Tenant Filtering**







**Transaction Management**







**Multi-Schema Tenancy**







**MikroORM Migrations**







**Data Archival**







**Read Replicas**







**Database Views**







**entity-reference**

- [Entity Reference Overview](https://sourcey-gauzy.pages.dev/database/entity-reference/overview/index.md)
- [Core Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/core-entities/index.md)
- [Employee Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/employee-entities/index.md)
- [Time Tracking Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/time-tracking-entities/index.md)
- [Task & Project Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/task-project-entities/index.md)
- [Invoice & Payment Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/invoice-payment-entities/index.md)
- [Product & Inventory Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/product-inventory-entities/index.md)
- [CRM Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/crm-entities/index.md)
- [Candidate Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/candidate-entities/index.md)
- [Integration Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/integration-entities/index.md)
- [Expense & Income Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/expense-income-entities/index.md)
- [Goal & KPI Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/goal-entities/index.md)
- [Collaboration Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/collaboration-entities/index.md)
- [Email & Notification Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/email-notification-entities/index.md)
- [System Entities](https://sourcey-gauzy.pages.dev/database/entity-reference/system-entities/index.md)