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_at_sccrnsc02>
> 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...
Date: Tue, 06 May 2003 01:38:43 GMT
Message-ID: <DmEta.747610$L1.212108_at_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 Tue May 06 2003 - 03:38:43 CEST