> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-worktree-351-fix-webapi-escaped-anchors.mintlify.site/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-worktree-351-fix-webapi-escaped-anchors/oakzUux-xoBtUKJP/media/loc/en/database/tables/ejpackage_item.png?fit=max&auto=format&n=oakzUux-xoBtUKJP&q=85&s=9482c187745d18ba04f892780f5c051d" 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.