• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

extra_fields Table (304)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

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

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
domain Enum indicating for what table this is an extra field (ticket, customer, company, etc). domain ●
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 ●
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 ●
field_name The database name of this extra field. String(64) ●
name The name of this extra field. String(128) ●
default_value The default value of this extra field. String(255) ●
type Enum indicating the type for this extra field (string, int, date, etc). type ●
flags A bitmask for flags for this extra field. Int ●
params A string contaning various parameters for this extra field, stored in an arbitrary format. Clob ●
order_pos Used to order elements when listed. Int ●
description Optional description of what this field is used for. String(2047) ●

extra_fields table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top