Quote:
Originally Posted by felgall
A one column table would need to have its column as part of the key in the other tables that refer to it.
|
Just to clarify - it doesn't have to be part of the primary key (although it would be in a join table used to attach multiple values), it could be a foreign key (in a table where exactly one of the values is required)..