GeneXus uses Transaction objects to create a Knowledge Base from which a Database structure is designed for storing your Application’s Data. The Database consists of Tables (usually called files) and access paths (called Indexes), designed using the third normal form.
Each Table gets its default name from the name of the Transaction that originates it. So, if a Transaction has only one level, the Table name will be the same as the Transaction name. On the other hand, if the Transaction has several levels, the subordinated table names will be created by concatenating the Transaction name and the corresponding Level names.
Consider the following Transaction:
Company
{
CompanyId*
CompanyName
Branch
{
BranchId*
BranchAddress
BranchPhone
}
}
The Tables that will be created in the Database will be called: Company and CompanyBranch.
Indexes
Table Editor