Modeling relationship tables

Asked

Viewed 59 times

1

Good evening, everyone! I’d like to ask you a question. Is it possible for multiple tables to reference a single foreign key from a table? Follow the example of the modeling where the table providers and representative refers to foreign key (ref_id) table contact. I wonder if I can improve this modeling even to facilitate the editing of records.

inserir a descrição da imagem aqui

  • There is no problem in several foreign keys of different tables referencing the same field of a table.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.