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

# extra_tables_result table

> Result set of executed search in ejournal extra tables

## extra\_tables\_result Table (308)

Result set of executed search in ejournal extra tables

## Fields

| Name         | Description                                             | Type                                   | Nullable |
| ------------ | ------------------------------------------------------- | -------------------------------------- | :------: |
| id           | The primary key (auto-incremented)                      | PK                                     |    No    |
| login\_id    | The id of the login session this result set belongs to. | FK [login](./login.mdx)                |    No    |
| extra\_table | The id of the extra table.                              | FK [extra\_tables](./extra-tables.mdx) |    No    |
| num\_entries | The number of results.                                  | Int                                    |    Yes   |
| active\_page | The current active page.                                | Int                                    |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/extra_tables_result.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=62737d31ae53679a2f74d8cbf7b15e5f" alt="extra_tables_result table relationship diagram" width="759" height="730" data-path="media/loc/en/database/tables/extra_tables_result.png" />

## Indexes

| Fields       | Types | Description |
| ------------ | ----- | ----------- |
| login\_id    | FK    | Index       |
| extra\_table | FK    | Index       |

## Relationships

| Table                                        | Description                                                            |
| -------------------------------------------- | ---------------------------------------------------------------------- |
| [extra\_tables](./extra-tables)              | This table contains entries for the extra tables in the system.        |
| [extra\_tables\_entry](./extra-tables-entry) | Hits/entries in result set of executed search in ejournal extra tables |
| [login](./login)                             | This table contains entries for the user sessions.                     |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [extra_tables_entry table](/en/database/tables/extra-tables-entry.md)
- [extra_tables table](/en/database/tables/extra-tables.md)
- [Add extra table](/en/custom-objects/admin/create-extra-table.md)
- [extra_fields table](/en/database/tables/extra-fields.md)
- [extra_menus table](/en/database/tables/extra-menus.md)
- [ExtraTable](/en/automation/crmscript/reference/CRMScript.Native.ExtraTable.md)