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 | ● |
table_number | Number of the table | UShort | ● |