SEO

#1 (**permalink**) 04-07-2008, 08:38 AM

I'm curious about theory of cross table references. I understand the need
but I'm wondering best practices. Specifically, should Cross-tables only be
made up of foreign keys or is it possible to have other columns?

For example, would this be an acceptable solution.
Borrower (BorrowerID)
LoanType (LoanTypeID)
CrossTable (BorrowerID, LoanTypeID, LoanScore, LoanValue)

Or should cross-table only be made up of keys.
Borrower (BorrowerID)
LoanType (LoanTypeID)
CrossTable (BorrowerID, LoanTypeID)

Thank you.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...house/200804/1

#2 (**permalink**) 04-09-2008, 05:06 PM

"doverj via SQLMonster.com" <u42617@uwe> wrote in message
news:8224215e37704@uwe...
> I'm curious about theory of cross table references. I understand the need
> but I'm wondering best practices. Specifically, should Cross-tables only
> be
> made up of foreign keys or is it possible to have other columns?
>
> For example, would this be an acceptable solution.
> Borrower (BorrowerID)
> LoanType (LoanTypeID)
> CrossTable (BorrowerID, LoanTypeID, LoanScore, LoanValue)
>
> Or should cross-table only be made up of keys.
> Borrower (BorrowerID)
> LoanType (LoanTypeID)
> CrossTable (BorrowerID, LoanTypeID)
>
> Thank you.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...house/200804/1
>

By "crosss table" I assume you mean a table that references more than one
other table using more than one foreign key - often called an "association
table" or "joining table"?

A table is a table. Use design principles like normalization if you are
unsure what other columns to include (if any).

--
David Portas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Cross Table References