Table of contents



Official Content

The extended table of a given Base Table is a virtual table composed of the base table itself plus all the tables which have N-1 relations, either directly or indirectly, starting from the given base table.

For example, if you have the following Bachman Diagram:

Bachman Diagram

  • The INVOICES base table will have the following extended table: {INVOICES, CUSTOMERS, COUNTRY}
  • The CUSTOMERS base table will have the following extended table: {CUSTOMERS, COUNTRY}
  • The COUNTRY base table will have the following extended table: {COUNTRY}

In its extended table, the INVOICES base table contains, in addition to itself, the CUSTOMERS table and the COUNTRY table. This is because starting from the INVOICES table (base table) there is an N-1 relation with the CUSTOMER table, and starting from the CUSTOMER table there is an N-1 relation with the COUNTRY table. Note that if you take one record from INVOICES, you find only one record from CUSTOMER related to it (and no more than one); and if you take one record from CUSTOMERS, you find only one record from COUNTRY related to it (and no more than one).

Following the same reasoning, in its extended table, the CUSTOMER base table contains, in addition to itself, the COUNTRY table. This is because starting from the CUSTOMER table (base table) there is an N-1 relation with the COUNTRY table. Note that if you take one record from CUSTOMERS, you find only one record from COUNTRY related to it (and not more than one).

The COUNTRY base table only contains itself in its extended table. This is because starting from it, there is no N-1 relation either directly or indirectly.
The extended table concept simplifies the way to access several tables when you are positioned in a specific Base Table.

Videos

Start Video Base and Extended table

Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant