extra_fields table - SuperOffice

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

Indexes

Fields	Types	Description
extra_table	FK	Index
target_extra_table	FK	Index

Relationships

Table	Description
extra_tables	This table contains entries for the extra tables in the system.
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 ExtraFieldsInfo extra_tables table ExtraTable events Enum ExtraFieldFlags Extra fields

⌘I