Glossary of terms

From JACOBWiki

B
backfill	Activity triggered by the selection of a data record in a search browser. The record data and the data of related records is entered, i.e. "backfilled", into the groups of the forms relevant to the record.
browser	GUI element listing data records in a tabular form. The browser definition determines which table columns are displayed in which order.
D
DB Elements	DB Elements are GUI elements such as textfields, checkboxes, etc. that are directly tied to a table field.
domain	A jACOB™ Designer domain is a folder like element grouping forms.
F
foreign field	A data field in a form’s group showing data from a "foreign" table alias. In jACOB™ Designer a group is always assigned to one table alias. A foreign field shows data from a table alias different than the table alias assigned to the group the field is contained in.
foreign field browser	Browser listing the data records found by a search on a foreign field.
foreign key	A column or combination of columns whose values match the primary key of some other table. A foreign key does not have to be unique; in fact, foreign keys are often in a many-to-one relationship to a primary key.
G
GUI hook	User-defined call-back method which is called by the jACOB™ application server due to user actions at the GUI. GUI hooks are assigned to a GUI element.
I
index	A database object that provides access to data in the rows of a table, based on key values. Indexes provide quick access to data and can enforce uniqueness on the rows in a table.
inform browser	Browser listing data records in a form as part of a group.
N
normal element	Normal elements are GUI elements such as textfields, checkboxes, etc. that are not directly tied to a table field. They can show e.g. calculated values and are normally controlled by GUI hooks.
P
primary key	A column or combination of columns that uniquely identifies a row in a table. It cannot allow null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.
R
relation set	A set of relations associated to each other. A graphical presentation of a relation set (table aliases as nodes and relations as connecting lines) normally results in a cohesive graph. Relation sets are used for complex searches on several data tables joined to each other. Relation sets are also used for the backfilling of data in associated forms after a record has been selected from a search browser.
S
search browser	Browser listing data records found by a search.
T
table alias	Unique name for a subset of data records in a table fulfilling a certain condition. Data with a similar data structure can be combined in one table. Table aliases make it possible to efficiently access single subsets of this table. If no condition is defined for a table alias, the subset of the table will contain the whole table. In this case the table alias is an alternative name for the table.
table hook	User-defined call-back method which is called by the jACOB™ application server while accessing the database. Table hooks are assigned to a table alias.
U
unique index	An index in which no two key fields or combinations of key fields on which the index is created may have the same value.