extra_tables Table (305)

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

Fields

NameDescriptionTypeNull
idThe primary key (auto-incremented)PK
table_nameThe database name of this extra table.String(64)
nameThe name of this extra table.String(128)
search_headerThe header when searching this table.String(255)
view_entry_headerThe header when viewing entries in this table.String(255)
new_entry_headerThe header when creating a new entry in this table.String(255)
edit_entry_headerThe header when editing an entry in this table.String(255)
hierarchy_idThis extra table is inside this hierarchy folderFK hierarchy
sort_orderThe default sort_order for this extra table.String(255)
display_fieldThe default field to display for this extra table.FK extra_fields
flagsBitmap for flags for this entry.UInt
parent_fieldIf this table is hierarchically organized, then this field can contain a field which is a parent-field, creating a hierarchy.FK extra_tables
fullname_fieldIf 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_entryThe screen chooser to use for this extra table when viewing an entry.FK screen_chooser
screen_chooser_allThe screen chooser to use for this extra table when viewing the table.FK screen_chooser
screen_chooser_editThe screen chooser to use for this extra table when editing the table.FK screen_chooser
descriptionOptional description of what this table is used forString(2047)
icon_idThe id of the binary object entryFK BinaryObject
table_numberNumber of the tableUShort

extra_tables table relationship diagram

Indexes

FieldsTypesDescription
idPKClustered, Unique
hierarchy_idFKIndex
display_fieldFKIndex
parent_fieldFKIndex
fullname_fieldFKIndex
screen_chooser_entryFKIndex
screen_chooser_allFKIndex
screen_chooser_editFKIndex

Relationships

TableDescription
BinaryObjectBinary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items
extra_fieldsThis table contains entries for the extra fields in the system.
extra_menusThis table contains entries for the extra menus in the system.
extra_tablesThis table contains entries for the extra tables in the system.
extra_tables_resultResult set of executed search in ejournal extra tables
hierarchyThis table contains folders used to group the extra tables in the system.
screen_chooserScreen choosers

Replication Flags

  • None

Security Flags

  • No access control via user’s Role.