You can drag existing elements from the model content in ER and DB diagrams and drop them on certain elements. The way this happens depends on where you are dragging from, on the initial element which you drop, and on where you drop it.
Drop Area: All Diagrams
| Drag Source Area | Initial Element | n | Drop Target Element | Effect |
|---|---|---|---|---|
| Any | Comment | * | Diagram (free area, comment is not allowed to exist yet) | Adds the comment to the diagram as a node and adds connections to all commented elements displayed in the diagram. |
| Any | Attachment | * | Diagram (free area, attachment is not allowed to exist yet) | Adds the attachment to the diagram as a node and adds attachment references to all assigned elements displayed in the diagram. |
| Any | Requirement | 1 | Any (in accordance with configuration of permissible owner of an realization) | Creates an realization between target element and requirement. |
| Any | Type | 1 | Typable element (type is permitted in accordance with configuration) | The typable element is typed with the type. |
| Model Editor | Any | * | Container | The source element is assigned to the container as content. |
Drop Area: Entity Relationship or Data Vault Diagram
| Drag Source Area | Initial Element | n | Drop Target Element | Effect |
|---|---|---|---|---|
| Any |
Entity View |
* | Diagram | Diagram nodes are created. Edges are created for nodes that already exist in the diagram. |
| Any | Entity | * | View |
The view receives a From clause on the entity. If it is the first From clause on the same entity, all attributes are also applied and linked as view attributes. 'From' edges are created in all diagrams in which target and source nodes exist. |
| Any | View | * | View |
The target view receives a From clause on the view. If it is the first From clause on the same view, all attributes are also applied and linked as view attributes. 'From' edges are created in all diagrams in which target and source nodes exist. |
| Any |
Attribute |
* | View |
A new view attribute is created in the view and linked to the source attribute. If no appropriate From clause exists yet, this is created and shown in the diagram. |
| Any |
View Attribute (excluding own) |
* |
View |
A new view attribute is created in the view and linked to the source attribute. If no appropriate From clause exists yet, this is created and shown in the diagram. |
| Any | Foreign Key | 1 | View |
The view receives a From clause for the entity with the foreign key and for the entity with the referencing key. For the first From clause on the same entity in each case, all attributes for this entity are also applied and linked as view attributes. The From clause for the entity with the foreign key is linked to the foreign and primary attributes and receives the JOIN expression with the comparison with the corresponding attributes. |
| ER Diagram | Foreign Keys | 1 | "From" clause |
Only when the From clause belongs to one of the two entities of the foreign key is a From clause also created on the other entity if necessary. The From clause for the entity with the foreign key is linked to the foreign and primary attributes and receives the JOIN expression with the comparison with the corresponding attributes. |
| ER Diagram |
Attribute (from the entity for which a From edge exists) |
* |
From clause |
The attributes are assigned to the From clause as Features Used. |
| ER Diagram |
View attributes (from view for which a From edge exists) |
* | From clause |
The attributes are assigned to the From clause as Features Used. |
| ER Diagram |
Attribute (from the entity for which a From edge exists) |
1 |
View attributes |
The initial attribute is inserted into the expression as a hyperlink for a view attribute. |
| ER Diagram |
View Attribute (from the view for which a From edge exists) |
1 |
View attributes |
The initial attribute is inserted into the expression as a hyperlink for a view attribute. |
| ER Diagram |
Attribute (from same entity as target) |
* | Unique Key |
Attributes not yet included in the key are assigned. |
| ER Diagram |
Attribute (from same entity as target) |
* | Foreign key | Attributes not yet included in the key are assigned, but only as many as are required in order to complete the foreign key once more. |
| ER Diagram | Generalization (Handle) | 1 |
Generalization Set (belongs to the same entity as the generalization set of the source) |
The generalization is now part of the target generalization set. If no generalization remains in the source generalization set, it is deleted. |
| ER Diagram | Generalization Set | 1 |
Generalization Set (belongs to the same entity as the source element) |
All generalizations of the source generalization set are assigned to the target generalization set. The source generalization set is deleted. |
Drop Area: Database Diagram
| Drag Source Area | Initial Element | n | Drop Target Element | Effect |
|---|---|---|---|---|
| Any |
Database Table Database View Constraint (Disjunctive Tables) |
* | Diagram | Diagram nodes are created. Edges are created for nodes that already exist in the diagram. |
| Any | Database Table | * | Database View |
The view receives a From clause on the table. If it is the first From clause on the same table, all columns are also applied and linked as view columns. 'From' edges are created in all diagrams in which target and source nodes exist. |
| Any | Database View | * | Database view |
The target view receives a From clause on the source view. If it is the first From clause on the same view, all columns of the source view are also applied and linked as view columns in the target view. 'From' edges are created in all diagrams in which target and source nodes exist. |
| Any |
Table column |
* | Database view |
A new view column is created in the view and linked to the source column. If no appropriate From clause exists yet, this is created and shown in the diagram. |
| Any |
View column (excluding own) |
* |
Database view |
A new view column is created in the target view and linked to the source column. If no appropriate From clause exists yet, this is created and shown in the diagram. |
| Any | Foreign Key | 1 | Database view |
On drop, both database tables are applied as database table. The 2nd From clause receives as expression the comparison between primary and foreign columns. |
| DB diagram | Foreign Keys | 1 | From Clause of a Database View |
Only when the From clause belongs to one of the two tables of the foreign key is a From clause also created on the other table if necessary. The From clause for the table with the foreign key is linked to the foreign and primary columns and receives the JOIN expression with the comparison with the corresponding columns. |
| DB diagram |
Table column (from the database table for which a From edge exists) |
* |
From Clause of a Database View |
The columns are assigned to the From clause as Features Used. |
| DB diagram |
View Column (from database view for which a From edge exists) |
* | From Clause of a Database View |
The columns are assigned to the From clause as Features Used. |
| DB diagram |
Table column (from the table for which a From edge exists) |
1 |
View column |
The initial column is inserted into the expression as a hyperlink for a view column. |
| DB diagram |
View Column (from database view for which a From edge exists) |
1 |
View column |
The initial column is inserted into the expression as a hyperlink for a view column. |
| DB diagram |
Table column (from the same database table as the target) |
* | Unique Key |
Columns not yet included in the key are assigned. |
| DB diagram |
Table column (from same database table as target) |
* | Foreign key | Columns not yet included in the key are assigned, but only as many as are required in order to complete the foreign key once more. |
| DB diagram |
Table column (from the same database table as the target) |
* |
Table Index |
Columns not yet included in the index are assigned. |
Drop Area: Dimension Diagram
| Drag Source Area | Initial Element | n | Drop Target Element | Effect |
|---|---|---|---|---|
| Any | Dimension | * | Diagram | A hierarchical dimension node is created. All contained dimension levels are automatically added as dimension level nodes. The dimension precedences are added between the dimensions. |
| Any | Hierarchy | * | Diagram | A hierarchical hierarchy node is created. All contained hierarchy levels are automatically added as hierarchy level nodes. The dimension precedences are added between the hierarchy levels. |
| Any |
Entity View |
1 | Dimension level | Assigns the initial element to the property 'Entity or View' of the dimension level. |
| Any |
Entity View |
1 | Hierarchy level | Assigns the initial element to the property 'Entity or View' of the hierarchy level and thus also to the corresponding dimension level. |
Drop Area: Cube Diagram
| Drag Source Area | Initial Element | n | Drop Target Element | Effect |
|---|---|---|---|---|
| Any | Cube | * | Diagram | A diagram node is created. |
| Any | Hierarchy | * | Diagram | A hierarchical hierarchy node is created. All contained hierarchy levels are automatically added as hierarchy level nodes. The dimension precedences are added between the hierarchy levels. |
| Any |
Entity View |
1 | Hierarchy level | Assigns the initial element to the property 'Entity or View' of the hierarchy level and thus also to the corresponding dimension level. |
| Any | Entity | * | Cube |
The cube receives a From clause on the entity. If this is the first From clause on the same entity, all local attributes are also adopted as measures and are linked. 'From' edges are created in all diagrams in which target and source nodes exist. |
| Any | View | * | Cube |
The cube receives a From clause on the view. If this is the first From clause on the same view, all local attributes are also adopted as measures and are linked. 'From' edges are created in all diagrams in which target and source nodes exist. |
| Any |
Attribute |
* | Cube |
A new view attribute is created in the cube and linked to the source attribute. If no appropriate From clause exists yet, this is created and shown in the diagram. |
| Any |
View Attribute (excluding own) |
* |
Cube |
A new measure is created in the cube and is linked to the source attribute. If no appropriate From clause exists yet, this is created and shown in the diagram. |
| Any | Foreign Key | 1 | Cube |
The cube receives a From clause for the entity with the foreign key and for the entity with the referenced key. For the first From clause on the same entity in each case, all local attributes of this entity are also adopted as measures and are linked. The From clause for the entity with the foreign key is linked to the foreign and primary attributes and receives the JOIN expression with the comparison with the corresponding attributes. |
Drop Area: Whiteboard Diagram
| Drag Source Area | Initial Element | n | Drop Target Element | Effect |
|---|---|---|---|---|
| Any | Diagram or behavior (not a whiteboard diagram and not an opaque behavior) | * | Whiteboard diagram (free area, diagram or behavior is not allowed to exist yet and must be allowed as diagram contents) | Adds the diagram as a node in the whiteboard diagram. |
