> ## 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.

# ejsel_ejsel table

> This table defines sources for complex selections in a many/many relationship

## ejsel\_ejsel Table (392)

This table defines sources for complex selections in a many/many relationship

## Fields

| Name       | Description                                                              | Type                                | Nullable |
| ---------- | ------------------------------------------------------------------------ | ----------------------------------- | :------: |
| id         | Primary key                                                              | PK                                  |    No    |
| parent     | The id of the selection for which this item is a source                  | FK [ejselection](./ejselection.mdx) |    No    |
| child      | The id of the child item selection                                       | FK [ejselection](./ejselection.mdx) |    No    |
| operation  | The operation to be performed when this source is added to the selection | Int                                 |    No    |
| order\_pos | The order in which the operations are performed                          | Int                                 |    No    |

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

## Indexes

| Fields     | Types | Description |
| ---------- | ----- | ----------- |
| parent     | FK    | Index       |
| child      | FK    | Index       |
| operation  | Int   | Index       |
| order\_pos | Int   | Index       |

## Relationships

| Table                        | Description                                   |
| ---------------------------- | --------------------------------------------- |
| [ejselection](./ejselection) | This table stores selections, dynamic groups. |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [ejsel_meta_result table](/en/database/tables/ejsel-meta-result.md)
- [ejsel_source_idlist table](/en/database/tables/ejsel-source-idlist.md)
- [ejsel_source_script table](/en/database/tables/ejsel-source-script.md)
- [ejsel_source_xml table](/en/database/tables/ejsel-source-xml.md)
- [ejsel_result_set table](/en/database/tables/ejsel-result-set.md)
- [ejselection table](/en/database/tables/ejselection.md)