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.