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. 1. Right clicking on a table entity in the sheet view and selecting "New Unique Constraint", "New Primary Key Constraint" or "New Check Constraint" from the context menu. 2. Right clicking on a table node in the the model node browser and selecting "New Unique Constraint", "New Primary Key Constraint" or "New Check 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 Unique Constraint", "New Primary Key Constraint" or "New Check Constraint". 4. Left clicking on a table entity in the sheet view and choosing Edit->New Unique Constraint, "New Primary Key Constraint" or "New Check Constraint" from the ER Modeler application menu bar while the table entity is still selected in the sheet. Primary Key Constraints When the New Primary Key Constraint properties window appears, it must be named. The column names on the left can be clicked to select them for participation in the constraint. Their constraint type "Primary Key" is indicated in the constraint column and the sequence in which they are clicked determines their order number in the Sequence column. Details on the Primary Key Constraint can be selected at the bottom of the properties window. Details at the bottom of the properties window vary based on database vendor and version. Unique Constraints When the New Unique Constraint properties window appears, it must be named. Its table, database and schema display based on the table's corresponding information. The column names on the left can be clicked to select them for participation in the constraint. Their constraint type "Unique" is indicated in the constraint column and the sequence in which they are clicked determines their order number in the Sequence column. Details at the bottom of the properties window vary based on database vendor and version. Check Constraints When the New Check Constraint properties window appears, it must be named and a condition must be entered. Its table, database and schema display based on the table's corresponding information. There is an option to exclude the check constraint from replication. |
|