Re: Column Naming Question

From: Marshall Spight <mspight_at_dnai.com>
Date: Tue, 06 May 2003 01:38:43 GMT
Message-ID: <DmEta.747610$L1.212108@sccrnsc02>

"john" <nospam_at_nospam.com> wrote in message news:_QBta.15538$9C6.772696_at_wards.force9.net...

> I have a table called Files which holds data about Files held for a project.
> I also have a table called user. I want the Files table to hold data about
> who has the file checked out and who initially uploaded the file. Since
> these two fields will be foriegn keys relating to User.User_ID how can i
> contain this data in the table - I can't have two columns called User_ID in
> my Files table...

So you call them two different names and have both of them be foreign keys. The name doesn't have to match.

This is not really a theory question ...

Marshall Received on Mon May 05 2003 - 20:38:43 CDT