# Database Schema Overview {#database-schema-overview}


Comprehensive overview of the Ever Gauzy database schema.


## Core Entity Groups {#core-entity-groups}






```mermaid
graph TB
    subgraph "Multi-Tenancy"
        T[Tenant] --> O[Organization]
        T --> U[User]
    end

    subgraph "HR"
        O --> E[Employee]
        E --> TL[TimeLog]
        E --> TS[Timesheet]
        E --> EX[Expense]
    end

    subgraph "Project Management"
        O --> P[Project]
        P --> TK[Task]
        TK --> TL
    end

    subgraph "CRM"
        O --> C[Contact]
        O --> PL[Pipeline]
        PL --> D[Deal]
    end

    subgraph "Accounting"
        O --> I[Invoice]
        O --> PM[Payment]
        O --> EX
    end
```






## Key Tables {#key-tables}



### Multi-Tenancy {#multi-tenancy}


| Table             | Description               | Relations              |
| ----------------- | ------------------------- | ---------------------- |
| `tenant`          | Top-level isolation       | Has many organizations |
| `organization`    | Business entity           | Belongs to tenant      |
| `user`            | Authentication entity     | Belongs to tenant      |
| `role`            | Permission group          | Belongs to tenant      |
| `role_permission` | Role ↔ permission mapping | Belongs to role        |


### Employees & HR {#employees--hr}


| Table        | Description             | Relations            |
| ------------ | ----------------------- | -------------------- |
| `employee`   | Employee profile        | Belongs to user      |
| `time_log`   | Individual time entries | Belongs to employee  |
| `timesheet`  | Weekly time summary     | Has many time_logs   |
| `time_slot`  | Activity time slots     | Belongs to time_log  |
| `screenshot` | Screen captures         | Belongs to time_slot |
| `activity`   | Keyboard/mouse activity | Belongs to time_slot |
| `expense`    | Expense records         | Belongs to employee  |
| `income`     | Income records          | Belongs to employee  |


### Project Management {#project-management}


| Table        | Description            | Relations           |
| ------------ | ---------------------- | ------------------- |
| `project`    | Project entity         | Belongs to org      |
| `task`       | Work items             | Belongs to project  |
| `sprint`     | Sprint iterations      | Belongs to project  |
| `daily_plan` | Daily work plans       | Belongs to employee |
| `goal`       | OKR objectives         | Belongs to org      |
| `goal_kpi`   | Key performance metric | Belongs to goal     |


### Accounting {#accounting}


| Table          | Description      | Relations          |
| -------------- | ---------------- | ------------------ |
| `invoice`      | Invoice entity   | Has many items     |
| `invoice_item` | Line items       | Belongs to invoice |
| `payment`      | Payment records  | Belongs to invoice |
| `estimate`     | Quotes/estimates | Has many items     |


### CRM {#crm}


| Table      | Description        | Relations           |
| ---------- | ------------------ | ------------------- |
| `contact`  | Client/lead entity | Belongs to org      |
| `pipeline` | Sales pipeline     | Has many stages     |
| `deal`     | Sales opportunity  | Belongs to pipeline |


## Common Columns {#common-columns}


All entities inherit from `TenantOrganizationBaseEntity`:

| Column           | Type      | Description        |
| ---------------- | --------- | ------------------ |
| `id`             | UUID      | Primary key        |
| `tenantId`       | UUID      | Tenant scope       |
| `organizationId` | UUID      | Organization scope |
| `createdAt`      | timestamp | Creation timestamp |
| `updatedAt`      | timestamp | Last update        |
| `isActive`       | boolean   | Soft active flag   |
| `isArchived`     | boolean   | Archive flag       |


## Related Pages {#related-pages}


- [Entity Inheritance](https://sourcey-gauzy.pages.dev/architecture/entity-inheritance/index.md) — base entities
- [Multi-Tenant Data Flow](https://sourcey-gauzy.pages.dev/architecture/multi-tenant-data-flow/index.md) — tenant scoping
- [TypeORM Migrations](https://sourcey-gauzy.pages.dev/database/typeorm-migrations/index.md) — schema changes