Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Contents |
Prev | Next |
Opening the Database Builder
When you first open the Database Builder, it searches the entire project for all Packages that have the stereotype <<Data Model>> and loads the corresponding data models as root nodes into the tree. A grayed-out icon indicates that the details of the data model are not loaded.
The above figure shows the Database Builder with a single unloaded data model called 'Orders (postgres)'.
Using the Database Builder
You can start working in the Database Builder in one of these two ways:
Task |
Action |
See also |
---|---|---|
Create a new data model |
Once you have opened the Database Builder view, right-click in the empty space of the tree and select 'New Data Model' to invoke the Model Wizard. |
Create a Data Model from a Model Pattern |
Load an existing Data Model |
Once the Database Builder view is opened, load any of the defined data models by either:
|
Data Model Properties
In earlier versions of Enterprise Architect (prior to the introduction of the Database Builder) it was necessary for the data modeler to manually set properties on database objects before some tasks were allowed. For example, Enterprise Architect would not allow the definition of a Table column without the Table first being assigned a DBMS. This was because the DBMS controls the list of available datatypes.
To improve efficiency and the user experience, the Database Builder defines defaults for a number of properties at the data model level and then applies these default values automatically whenever new objects are created.
Properties
Option |
Description |
---|---|
DBMS |
Defined against: The data model's <<Database>> Package Defined as: Tagged Value Details: Defines the DBMS of the current data model Extra Information:
|
DefaultOwner |
Defined against: The data model's <<Database>> Package Defined as: Tagged Value Details: Defines the default Owner for the current data model Extra Information:
|
DefaultConnection |
Defined against: The data model's <<Database>> Package Defined as: Tagged Value Details: (Optional) the name of the default connection Extra Information:
|
Notes