Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-03-22 : 10:51:47
|
| Assignment table(assignmentid pk,title,etc.,assignmenttype(1=forum,2=journal,etc),refid (id of a forumthread,or id of a journal)_______________________forum table(threadid pk,threadtitle,graded y/n,etc.________________journal table(journalid,journaltitle,gradedy/n.etc.)________________is it ok to use refid as a foriegn key referencing forumid in fourm table if the assignment type is forumand refid is a foreign key referencing journalid in journal table if assignment type is journalhow this can be accomplised in the best way to improve performanceI thought of doing the followingadding the following two tables journalassign(journalid,assignmentid)and forumassign(forumid, assignm)___________________________but I have similar situations in other tablesexample:lessontools(lessonid + toolid pk, tooltype (1=dropbox,2=,etc.)dropbox(dropboxid, etc)___________________thankssarah |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
1 foreign key reference PK in multiple tables