DBVIEW
org::dbtools::db::structure Namespace Reference

Detailed Description

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.