Example:
Student
studentId
name
Staff
staffId
name
Account
accountId
foreignKeyId(studentId or staffId)
username
password
usertype
Asked
Active
Viewed 87 times
1
Joseph Quinsey
- 9,185
- 10
- 53
- 75
Hanzel Kit Campos
- 29
- 2
-
2what mysql engine are you using? and yes this does matter for me to give you an answer :) – mamdouh alramadan Jan 09 '13 at 05:04
-
You need either studentId or staffId as forein key ? – Sahal Jan 09 '13 at 05:04
-
@Sahal, what i want to happen is that,if i will to create an account for student or for a staff, it will be saved in the FOREIGNKEYID attribute. – Hanzel Kit Campos Jan 09 '13 at 09:00
2 Answers
1
IMHO strange design choice. You better go all the way around:
Account
-------
accountid
username
password
usertype
...
Student
-------
studentid
accountid
name
...
Staff
-----
staffid
accountid
name
...
peterm
- 88,818
- 14
- 143
- 153
-1
Both tables should be InnoDB. InnoDB details - http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html
The following Stack Overflow answer could help.
