Can a Foreign key be used twice in a table

[xxreenaxx1]

Hi,

 

for eg: Foreign key(staffid) references user(userid)

          Foreign ket(studentid) references user(userid)

 

Can you have this statement in one table.

[codefossa]

I'm not 100% sure of what you're asking, but here's what I believe you are asking.  You basically want to have two types of ID's in a single table. (Students & Staff)

 

To do this, I would just add an extra column which would be named 'type' or 'staff', whatever you want.  Then make sure it's an int, and just use 0 & 1 to represent student or staff.

 

If it's not what you wanted, then sorry.

[fenway]

Hi,

 

for eg: Foreign key(staffid) references user(userid)

          Foreign ket(studentid) references user(userid)

 

Can you have this statement in one table.

Did you try?