Enterprise Architect 8 Data Modeling (create foreign key)

Source: Internet
Author: User
Enterprise Architect 8 Data Modeling (create foreign key)
----------
1 Creating foreign keys
We can follow these steps to create a foreign key:
1.1 Find two tables to associate and fields in the view
2.2 Select Association in the left toolbar, click on the table containing the foreign key, and connect to the target table
2.3 Right-clicking on the connector and selecting the Foreign keys option on the pop-up menu pops up a pop-up box
The default foreign key name in the 2.4 pop-up box is set by the foreign key name template. If you want to use a different name, you can check the override Template and overwrite it.
2.5 in the source panel and Target Panel, select and click Two column names to be associated respectively
2.6 In the on Delete and/or On Update dropdown box, select the appropriate integrity constraint
2.7 Click Apply to automatically create a foreign key
Note: Foreign key is not required, because the program can also complete the foreign KEY constraints, and: If you want to use a foreign key in the MySQL library, you must set the type of table (mentioned in the previous blog)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.