This package contains the internal representation of a database.
Nomenclature:
-
"Relation" vers "join":
-
A relation is a (global) link between two tables : a "dependent" table and a "reference" table.
-
A join is a link between two tables' fields. A join is always associated to a (soft or hard) foreign key.
Please note that a relation includes one or more joins.
-
"Dependent" versus "reference" table: These notions are relative to joins. A join links a field to another field. In the database, a link between two fields is declared by a (soft or hard) foreign key.
-
The field declared as a foreign key belongs to the "dependent" table.
-
The other field belongs to the "reference" table.