> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ejpackage_item table

> This table stores info on installed packages in the system

## ejpackage\_item Table (385)

This table stores info on installed packages in the system

## Fields

| Name       | Description                                                                  | Type                                       | Nullable |
| ---------- | ---------------------------------------------------------------------------- | ------------------------------------------ | :------: |
| id         | Primary key                                                                  | PK                                         |    No    |
| ejpackage  | The id of the package for which this item belongs                            | FK [ejpackage](./ejpackage.mdx)            |    No    |
| idx        | The index in the package                                                     | Int                                        |    No    |
| domain     | The domain for which this item belongs (domains are defined in PackageLib.h) | Int                                        |    No    |
| item\_id   | The id of the element for which this item belongs                            | Int                                        |    No    |
| ref\_name  | Used to reference the item in installscript                                  | String(255)                                |    Yes   |
| parent\_id | The parent for this package item link. -1 if this is a toplevel item link.   | FK [ejpackage\_item](./ejpackage-item.mdx) |    No    |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/ejpackage_item.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=8ba4ca5864098fa4e86efc86874d3846" alt="ejpackage_item table relationship diagram" width="508" height="59" data-path="media/loc/en/database/tables/ejpackage_item.png" />

## Indexes

| Fields     | Types | Description |
| ---------- | ----- | ----------- |
| ejpackage  | FK    | Index       |
| domain     | Int   | Index       |
| item\_id   | Int   | Index       |
| parent\_id | FK    | Index       |

## Relationships

| Table                               | Description                                                |
| ----------------------------------- | ---------------------------------------------------------- |
| [ejpackage](./ejpackage)            | This table stores packages on the system.                  |
| [ejpackage\_item](./ejpackage-item) | This table stores info on installed packages in the system |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [ejpackage table](/en/database/tables/ejpackage.md)
- [item_config table](/en/database/tables/item-config.md)
- [email_item table](/en/database/tables/email-item.md)
- [NewsFeedItem table](/en/database/tables/newsfeeditem.md)
- [NewsFeedItemRecipient table](/en/database/tables/newsfeeditemrecipient.md)
- [NewsFeedItemCta table](/en/database/tables/newsfeeditemcta.md)