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

extra_tables Table (305)

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

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

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
table_name The database name of this extra table. String(64) ●
name The name of this extra table. String(128) ●
search_header The header when searching this table. String(255) ●
view_entry_header The header when viewing entries in this table. String(255) ●
new_entry_header The header when creating a new entry in this table. String(255) ●
edit_entry_header The header when editing an entry in this table. String(255) ●
hierarchy_id This extra table is inside this hierarchy folder FK hierarchy
sort_order The default sort_order for this extra table. String(255) ●
display_field The default field to display for this extra table. FK extra_fields ●
flags Bitmap for flags for this entry. UInt ●
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 ●
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 ●
screen_chooser_entry The screen chooser to use for this extra table when viewing an entry. FK screen_chooser ●
screen_chooser_all The screen chooser to use for this extra table when viewing the table. FK screen_chooser ●
screen_chooser_edit The screen chooser to use for this extra table when editing the table. FK screen_chooser ●
description Optional description of what this table is used for String(2047) ●
icon_id The id of the binary object entry FK BinaryObject ●

extra_tables table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
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 Binary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items
extra_fields This table contains entries for the extra fields in the system.
extra_menus This table contains entries for the extra menus in the system.
extra_tables This table contains entries for the extra tables in the system.
extra_tables_result Result set of executed search in ejournal extra tables
hierarchy This table contains folders used to group the extra tables in the system.
screen_chooser Screen choosers

Replication Flags

  • None

Security Flags

  • No access control via user's Role.
In This Article
  • Fields
  • Indexes
  • Relationships
  • Replication Flags
  • Security Flags
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top