Foreign Keys with different column names

Started by davidIII, September 12, 2013, 05:19:05 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

davidIII

September 12, 2013, 05:19:05 PM Last Edit: September 12, 2013, 05:20:59 PM by davidIII
I'm using Visio 2010 to create a database model.
How do you designate foreign keys when the column names are different?

davidIII

#1
September 12, 2013, 07:29:06 PM
I see it now. Highlight the line and associate the columns under Definition. It can be named under Foreign key role name.
Print
Go Up Pages1
User actions
Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 146 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1049KB.
Tokens: post-login.
Cache hits: 13: 0.00218s for 26,551 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]