extra_tables Table (305)
•
Environment: onsite, online
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 | ● |
| table_number | Number of the table | UShort | ● |
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.