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
|
There are four methods for creating constraints within the ER Modeler. These methods work for Primary Key Constraints, Unique Constraints and Check Constraints. Primary Key Constraints do require. 1. Right clicking on a table entity in the sheet view and selecting "New Constraint" from the context menu. 2. Right clicking on a table node in the the model node browser and selecting "New Constraint" from the menu. 3. Expanding a table entity node in the model node browser, right clicking on the constraints node for that table and selecting "New constraint". 4. Left clicking on a table entity in the sheet view and choosing Edit->New Constraint from the ER Modeler application menu bar while the table entity is still selected in the sheet. A constraint may be created by right clicking on the Constraints node within a Table within the Model Browser. The resulting menu allows the selection of New Primary Key Constraint New Unique Constraint and New Check Constraint.
The New Unique Constraint window allows the editing of its Name and designation of which columns are unique with a left click on the right hand column.
The New Check Constraint window allows the the naming of the Check Constraint and its conditions.
|