Erwin Related Concepts Quick Start (Albertyi original)
1. If you only do documentation, you can choose to create only Logical View2. If you are a project, you need to use Logical View and Physical View3 at the same time. General Logical View is used for documentation, and Physical View is 4 for generating or exporting scripts. The three connecting lines between the tables are used to insert the primary keys in Table 1 into Table 2, and inserted as the primary key as Table 2 for many more, very small The first kind is used to insert the primary key in Table 1 into Table 2, and inserted from the primary key as Table 2
5, the name of the corresponding table in Logical and Physical can be different, generally in the name of the table in Physical with the name of the table in Logical in Logical, if needed, in Chinese
6. You can select the item you want to operate in the table in the table in the Tools in the Physical View.
Click [Preview] to see the script, you can copy the change can be a script. Click [Report] to export the script directly to click [Generate] to connect directly to the database, and build the relevant scheme to build
7. Right-click on the Logical View, select Attribute, and enter the interface to the table. Add a basic type (Domain) in General, you can join a name, Attribute Name is The name column name in the Logical View is the name used to generate the script. Checkbox of Primary Key in General is selected as the primary key. The specific data type can be set in DataType, such as Varchar2, Number, etc.
8. Right-click on index and constraints in Entity, select the key group to create new constraints.
9. Select DataType in Attribute to select this column related constraint in Validate, select this Column's default value in Default.
10. Concepts about Domains Domain's concept is supported in SQL Server, you can define a bunch of Domain at the beginning of the script, and then reference the relevant domain name in the subsequent scripts without direct rare data types. .
For example: The card number is very much in the database design of a project: So select Domain in the Logical View in Erwin, then right click?
This new Domain can be easily used in this project.
11. About the concept of Subject Area When the entire project design is more, it is difficult to connect the relationship between all the tables in a view, which needs to be divided into multiple Area in the Subject Area, put the relevant split This is relatively easy to design in the relevant Area.
1> Right-click on a corresponding area, then go to, you can see the corresponding View2> right key -> Property, you can set the current area, which is a more useful set of buttons is the last one. Group (two), can join the Class M-class ANCESTER and N-level Descendant to join the table to join the AREA to join Area, as for M and N can choose themselves, very convenient.
