Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Hi
>>
>>If you had a table that was related to say, 6 tables, would it be better to have 6 individual foreign key fields, or would it be better to have 1 foreign key field and then a "type" to identify where it came from.
>>
>>I prefer the latter, but what about everyone else?
>>
>>Thanks
>>Kev
>
>I see two difficulties with the approach you propose: 1) What if the table is related to two or more other tables at the same time? 2) It is quite messy to define relations.
1) That will never happen.
2) Type+Ref, not too bad
>I suggest you give a more specific example of what you want to achieve. What sort of information do the 6 "other" tables contain?
Quite simply, the table is a list of people, and there will need to be the ability to create lists related to different tables, so there will be more than 6 tables in the long run.
Kev
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement