How to create a link between two tables in a database where one field refers to multiple fields?

Two tables:
  1. Types
  2. Types


One view can belong to multiple types.
How to implement it in the database?

To create in the types combo box id species or are there more clever ways?
April 19th 20 at 12:27
1 answer
April 19th 20 at 12:29
If one species can be associated with multiple types, each type with only one species, the ratio is one-to-many and implemented id_вида field in the types table.
If one species can be associated with multiple types one type multiple types, it is many-to-many and is based on the staging table connection (id_вида, id_типа).

Find more questions by tags MySQL