> ## 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_fields table

> This table contains entries for the extra fields in the system.

## extra\_fields Table (304)

This table contains entries for the extra fields in the system.

## Fields

| Name                 | Description                                                                                                   | Type                                   | Nullable |
| -------------------- | ------------------------------------------------------------------------------------------------------------- | -------------------------------------- | :------: |
| id                   | The primary key (auto-incremented)                                                                            | PK                                     |    No    |
| domain               | Enum indicating for what table this is an extra field (ticket, customer, company, etc).                       | domain                                 |    Yes   |
| extra\_table         | The reference to the extra\_table if this table is related to an extra\_table. NULL or -1 if not set.         | FK [extra\_tables](./extra-tables.mdx) |    Yes   |
| target\_extra\_table | If this extra field is a extra table relation, then this is the id of the extra table this entry *points* to. | FK [extra\_tables](./extra-tables.mdx) |    Yes   |
| field\_name          | The database name of this extra field.                                                                        | String(64)                             |    Yes   |
| name                 | The name of this extra field.                                                                                 | String(128)                            |    Yes   |
| default\_value       | The default value of this extra field.                                                                        | String(255)                            |    Yes   |
| type                 | Enum indicating the type for this extra field (string, int, date, etc).                                       | type                                   |    Yes   |
| flags                | A bitmask for flags for this extra field.                                                                     | Int                                    |    Yes   |
| params               | A string contaning various parameters for this extra field, stored in an arbitrary format.                    | Clob                                   |    Yes   |
| order\_pos           | Used to order elements when listed.                                                                           | Int                                    |    Yes   |
| description          | Optional description of what this field is used for.                                                          | String(2047)                           |    Yes   |

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

## Indexes

| Fields               | Types | Description |
| -------------------- | ----- | ----------- |
| extra\_table         | FK    | Index       |
| target\_extra\_table | FK    | Index       |

## Relationships

| Table                                      | Description                                                     |
| ------------------------------------------ | --------------------------------------------------------------- |
| [extra\_tables](./extra-tables)            | This table contains entries for the extra tables in the system. |
| [ticket\_log\_change](./ticket-log-change) | This table contains log entries for the tickets.                |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Working with custom objects and fields in API](/en/custom-objects/reference/index.md)
- [ExtraFieldsInfo](/en/automation/crmscript/reference/CRMScript.Native.ExtraFieldsInfo.md)
- [extra_tables table](/en/database/tables/extra-tables.md)
- [ExtraTable events](/en/automation/webhook/reference/extratable-events.md)
- [Enum ExtraFieldFlags](/en/automation/crmscript/reference/CRMScript.NetServer.ExtraFieldFlags.md)
- [SuperOffice.WebApi.Data.UserPreferenceStrings.ExtraFields](/en/api/reference/webapi/SuperOffice.WebApi.Data.UserPreferenceStrings.ExtraFields.md)