> ## 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. # ejscript table > ejscript ## ejscript Table (377) ejscript ## Fields | Name | Description | Type | Nullable | | ------------------------- | --------------------------------------------------------------------------------- | --------------------------------------------- | :------: | | id | Primary key | PK | No | | hierarchy\_id | The script is inside this hierarchy folder | FK [hierarchy](./hierarchy.mdx) | No | | description | A description of this script | String(255) | Yes | | include\_id | A unique name used for including this script in another | String(255) | No | | access\_key | Access key used to run this script on the customer pages | String(255) | Yes | | body | The script | Clob | Yes | | html\_output | True if this script will return HTML output | Bool | No | | long\_description | Optional description of what this script is used for. | String(2047) | Yes | | extra\_menus\_id | Optional id of related extra menu pointing to this script | FK [extra\_menus](./extra-menus.mdx) | Yes | | unique\_identifier | Global unique identifier, accross customers/tenants | String(64) | No | | registered | Registered when | UtcDateTime | Yes | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | Yes | | updated | Last updated when | UtcDateTime | Yes | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | Yes | | updatedCount | Number of updates made to this record | UShort | No | | type | The type/language of this script | Enum [ScriptType](./enums/scripttype.mdx) | No | | last\_exec\_http | The last time this script was executed by a HTTP call as a authenticated user | UtcDateTime | Yes | | last\_exec\_anon\_http | The last time this script was executed by a HTTP call anonomously | UtcDateTime | Yes | | source\_code | Contains the source code of the script | Clob | Yes | | includes | Contains a comma separated list of ids of all nested includes used by this script | String(4000) | Yes | | last\_compiled | When this script was last compiled (UTC). | DateTime | Yes | | source\_maps | Source maps in JSON format | Clob | Yes | | blocked\_verbs | The verbs that are blocked when calling a ejscript over HTTP | Enum [EjScriptVerb](./enums/ejscriptverb.mdx) | No | ejscript table relationship diagram ## Indexes | Fields | Types | Description | | ------------------ | ----------- | ----------- | | hierarchy\_id | FK | Index | | include\_id | String(255) | Index | | unique\_identifier | String(64) | Unique | ## Relationships | Table | Description | | -------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | | [associate](./associate) | Employees, resources and other users - except for External persons | | [chat\_topic](./chat-topic) | This table contains chat topics. | | [dbi\_agent\_schedule](./dbi-agent-schedule) | DBI agent schedule settings | | [extra\_menus](./extra-menus) | This table contains entries for the extra menus in the system. | | [form](./form) | A form which can be published on a webpage and submitted by visitors | | [hierarchy](./hierarchy) | This table contains folders used to group the extra tables in the system. | | [ms\_filter](./ms-filter) | This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails. | | [s\_link](./s-link) | Links in messages to measure success rate of a campaign. | | [scheduled\_task](./scheduled-task) | A scheduled entry executing a script at certain times | | [screen\_chooser](./screen-chooser) | Screen choosers | | [screen\_definition\_action](./screen-definition-action) | An action to perform for a certain button in an screen | | [TaskMenu](./taskmenu) | List items to merge into menues | | [ticket\_alert](./ticket-alert) | This table will contain ticket escalation levels. A ticket will be escalated along a \'chain\' of these levels. | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [What's new in version 11.10.705.0](/release-notes/database/changes-11.10.705.md) - [What's new in version 11.7.727.0](/release-notes/database/changes-11.7.727.md) - [What's new in version 11.8.788.0](/release-notes/database/changes-11.8.788.md) - [What's new in version 11.9.1204.0](/release-notes/database/changes-11.9.1204.md) - [What's new in version 12.0.342.0](/release-notes/database/changes-12.0.342.md) - [What's new in version 12.1.1412.0](/release-notes/database/changes-12.1.1412.md)