Structure in packages

Overview

Structuring in model packages does not entail any restriction of the database diagram generation. In particular, a database diagram can be modeled using several model packages.

Packages stereotyped <<schema>>

It is possible to group together several relational tables into a relational diagram. This grouping is carried out using the <<schema>> (package name) stereotype, which can be attached to a model package or to a class. This stereotype allows the creation of relational tables in a specific relational diagram. Access to these tables is then carried out with the complete name of the table: diagram name of the table.

Classes belonging to a package stereotyped <<schema>> are generated in a sub-package of the physical model, which is also stereotyped <<schema>>.

Components stereotyped <<database>>

In an environment of distributed databases, it is possible to specify the name of the database. This information is available with the <<database>> component, which can reference several model packages or classes. The generated SQL linked to the referenced elements allows "distant" requests to other databases accessible via a local network.

The tables of the referenced classes are generated in a sub-package stereotyped <<database>>.