> ## 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 table > This table contains entries for the extra tables in the system. ## extra\_tables Table (305) This table contains entries for the extra tables in the system. ## Fields | Name | Description | Type | Nullable | | ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | :------: | | id | The primary key (auto-incremented) | PK | No | | table\_name | The database name of this extra table. | String(64) | Yes | | name | The name of this extra table. | String(128) | Yes | | search\_header | The header when searching this table. | String(255) | Yes | | view\_entry\_header | The header when viewing entries in this table. | String(255) | Yes | | new\_entry\_header | The header when creating a new entry in this table. | String(255) | Yes | | edit\_entry\_header | The header when editing an entry in this table. | String(255) | Yes | | hierarchy\_id | This extra table is inside this hierarchy folder | FK [hierarchy](./hierarchy.mdx) | No | | sort\_order | The default sort\_order for this extra table. | String(255) | Yes | | display\_field | The default field to display for this extra table. | FK [extra\_fields](./extra-fields.mdx) | Yes | | flags | Bitmap for flags for this entry. | UInt | Yes | | parent\_field | If this table is hierarchically organized, then this field can contain a field which is a parent-field, creating a hierarchy. | FK [extra\_tables](./extra-tables.mdx) | Yes | | fullname\_field | If this table is hierarchically organized, then this field can contain a field which will be assigned a fullname, such as \'Support/Hardware/Keyboards\'. | FK [extra\_tables](./extra-tables.mdx) | Yes | | screen\_chooser\_entry | The screen chooser to use for this extra table when viewing an entry. | FK [screen\_chooser](./screen-chooser.mdx) | Yes | | screen\_chooser\_all | The screen chooser to use for this extra table when viewing the table. | FK [screen\_chooser](./screen-chooser.mdx) | Yes | | screen\_chooser\_edit | The screen chooser to use for this extra table when editing the table. | FK [screen\_chooser](./screen-chooser.mdx) | Yes | | description | Optional description of what this table is used for | String(2047) | Yes | | icon\_id | The id of the binary object entry | FK [BinaryObject](./binaryobject.mdx) | Yes | | table\_number | Number of the table | UShort | Yes | extra_tables table relationship diagram ## Indexes | Fields | Types | Description | | ---------------------- | ----- | ----------- | | hierarchy\_id | FK | Index | | display\_field | FK | Index | | parent\_field | FK | Index | | fullname\_field | FK | Index | | screen\_chooser\_entry | FK | Index | | screen\_chooser\_all | FK | Index | | screen\_chooser\_edit | FK | Index | ## Relationships | Table | Description | | ---------------------------------------------- | ------------------------------------------------------------------------------------------------------------- | | [BinaryObject](./binaryobject) | Binary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items | | [extra\_fields](./extra-fields) | This table contains entries for the extra fields in the system. | | [extra\_menus](./extra-menus) | This table contains entries for the extra menus in the system. | | [extra\_tables](./extra-tables) | This table contains entries for the extra tables in the system. | | [extra\_tables\_result](./extra-tables-result) | Result set of executed search in ejournal extra tables | | [hierarchy](./hierarchy) | This table contains folders used to group the extra tables in the system. | | [screen\_chooser](./screen-chooser) | Screen choosers | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [ExtraTable](/en/automation/crmscript/reference/CRMScript.Native.ExtraTable.md) - [ExtraTable events](/en/automation/webhook/reference/extratable-events.md) - [extra_tables_result table](/en/database/tables/extra-tables-result.md) - [extra_tables_entry table](/en/database/tables/extra-tables-entry.md) - [extra_fields table](/en/database/tables/extra-fields.md) - [ExtraTableInfo](/en/automation/crmscript/reference/CRMScript.Native.ExtraTableInfo.md)