can foreign key be recurred in one row

Question

in forwarders project I have a table named Ports

portid
portname

has a relationship 1 to many to quotation,

Quotationid
Qoutationdate
POL
POD

port of loading , port of discharge.

I want to show the user dropdownlist shows the portname in POL and POD and save portid in both fields

So,can foreign key be recurred in one row? , thanks in advance. And how to make it in MVC model

See https://stackoverflow.com/q/24243417/3404097. – philipxy May 04 '18 at 10:31 — philipxy, May 04 '18 at 10:31

score 2 · Accepted Answer · answered May 03 '18 at 20:36

2

Yes. Foriegn keys are nothing more than just ordinary columns/attribute, except they only contain references to other relations. There's nothing wrong in having recurring foreign keys in a tuple/row.

answered May 03 '18 at 20:36

Maddy Blacklisted

1,190
1
7
17

Thank you very much, would you mind to tell me how to make it in MVC model – hassanzi May 03 '18 at 20:38
Which MVC specifically as there are lots of MVC patterns with lots of implementation differences between languages. – Maddy Blacklisted May 03 '18 at 20:40
You can simply define multiple properties in your model class like [ForeignKey("portid")] public Ports POL { get; set; } [ForeignKey("portid")] public Ports POD { get; set; } – Maddy Blacklisted May 03 '18 at 20:47

can foreign key be recurred in one row

1 Answers1