A Datastore can contain the following entity types:
|
Contains metadata about a database table. |
|
|
Contains metadata about a database view. |
|
|
The equivalent of a database view, but defined in the Database Repository and implemented on the application-side with generated source code. |
Every Table, View and Custom View has a designer that can be opened from the Project Explorer by double clicking its node, or by right-clicking it and selecting the Edit option from its context menu.
Datastore Entities are built up from the following types of database objects:
|
Ordinary database columns. |
|
|
Columns based on SQL expression that can be added to Tables and Views, but not to Custom Views. |
|
|
Key objects contain metadata about all types of database keys and indexes. |
|
|
Contains metadata about relations defined in the database for maintaining referential integrity. Relations play an essential role in generated object relations in BO-Layer projects. |
/
Columns, Calculated Columns, Keys and Relations are displayed in the Project Explorer when the node of the Table, View or Custom View that they belong to is expanded. Each of these database objects has its dedicated designer in the Database Repository.