# System Entities {#system-entities}


System-level entities for activity logs, API call logs, features, languages, countries, currencies, image assets, and reports.


## ActivityLog {#activitylog}


| Column           | Type      | Description                     |
| ---------------- | --------- | ------------------------------- |
| `entity`         | string    | Changed entity type             |
| `entityId`       | UUID      | Changed entity ID               |
| `action`         | enum      | `CREATED`, `UPDATED`, `DELETED` |
| `actorType`      | enum?     | `User` or `System`              |
| `description`    | string?   | Change description              |
| `updatedFields`  | string[]? | List of changed fields          |
| `updatedValues`  | json?     | New values                      |
| `previousValues` | json?     | Old values                      |
| `creatorId`      | UUID?     | FK to user                      |
| `data`           | json?     | Additional data                 |


## ApiCallLog {#apicalllog}


| Column           | Type    | Description          |
| ---------------- | ------- | -------------------- |
| `url`            | string  | Request URL          |
| `method`         | string  | HTTP method          |
| `statusCode`     | number  | Response status code |
| `requestHeaders` | string? | Request headers      |
| `requestBody`    | string? | Request body         |
| `responseBody`   | string? | Response body        |
| `ipAddress`      | string? | Client IP address    |


## Feature {#feature}


| Column        | Type     | Description           |
| ------------- | -------- | --------------------- |
| `name`        | string   | Feature name          |
| `code`        | string   | Feature code          |
| `description` | string?  | Description           |
| `image`       | string?  | Feature image         |
| `link`        | string?  | Documentation link    |
| `isEnabled`   | boolean  | Default enabled state |
| `isPaid`      | boolean? | Requires payment      |
| `parentId`    | UUID?    | FK to parent feature  |


## Language {#language}


| Column        | Type    | Description     |
| ------------- | ------- | --------------- |
| `name`        | string  | Language name   |
| `code`        | string  | ISO code        |
| `is_system`   | boolean | System language |
| `description` | string? | Description     |
| `color`       | string? | Display color   |


## Country {#country}


| Column    | Type   | Description      |
| --------- | ------ | ---------------- |
| `isoCode` | string | ISO country code |
| `country` | string | Country name     |


## Currency {#currency}


| Column     | Type   | Description       |
| ---------- | ------ | ----------------- |
| `isoCode`  | string | ISO currency code |
| `currency` | string | Currency name     |


## ImageAsset {#imageasset}


| Column               | Type     | Description         |
| -------------------- | -------- | ------------------- |
| `name`               | string   | File name           |
| `url`                | string   | Full URL            |
| `thumb`              | string?  | Thumbnail URL       |
| `width`              | number?  | Image width         |
| `height`             | number?  | Image height        |
| `size`               | number?  | File size (bytes)   |
| `isFeatured`         | boolean? | Featured flag       |
| `storageProvider`    | enum?    | Storage provider    |
| `externalProviderId` | string?  | External storage ID |


## Report / ReportCategory {#report--reportcategory}


| Column        | Type     | Description          |
| ------------- | -------- | -------------------- |
| `name`        | string   | Report/category name |
| `slug`        | string?  | URL-friendly slug    |
| `description` | string?  | Description          |
| `image`       | string?  | Report image         |
| `iconClass`   | string?  | Icon CSS class       |
| `showInMenu`  | boolean? | Show in sidebar      |
| `categoryId`  | UUID?    | FK to category       |


## Tag / TagType / Skill {#tag--tagtype--skill}


Tags and skills used for categorization.

| Tag Column    | Type    | Description    |
| ------------- | ------- | -------------- |
| `name`        | string  | Tag name       |
| `color`       | string  | Color hex      |
| `icon`        | string? | Icon           |
| `description` | string? | Desc           |
| `isSystem`    | boolean | System tag     |
| `tagTypeId`   | UUID?   | FK to tag type |


## Related Pages {#related-pages}


- [Activity Log Endpoints](https://sourcey-gauzy.pages.dev/api/activity-log-endpoints/index.md) — API reference
- [Feature Toggle Endpoints](https://sourcey-gauzy.pages.dev/api/feature-toggle-endpoints/index.md) — feature flags API
- [Report Endpoints](https://sourcey-gauzy.pages.dev/api/report-endpoints/index.md) — reports API