Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Creating a New ER Model
Below is a demonstration of an ER Model being created, with tables, relationships, constraints and indexes. The model is then used to generate the DDL for importing into a database.
Create an ER Model and Add a Table
| 1. Select New Model | 2. Select Vendor | 3. Create New Table | 4. Double click on Table |
5. Set Table Properties |
6. Table Added | 7. Add More Tables |
Create Relationships
| 8. New Table Added |
9. Right click on Table | 10. Select New Relationship |
11. Set Relationship Properties |
12. Relationship added |
13. Right Click Constraints |
14. Enter Constraints Properties |
Create Primary Key Constraints, Indexes and Generate a Script from the Model
| 15. New Primary Key Added |
16. Right Click Indexes |
17. Enter Index Properties |
18. Index is created | 19. More Relationships Constraints, Indexes & Tables |
20. Select Generate Script |
21. Select Schemas |
View the Script Generation Status, View the script and further modify the diagram
| 22. Specify Script Name |
23. Script Generation Status |
24. Generated SQL Script |
25. Diagram Region added |