How to organize the engine database structure?

Question

Database design

You need to make a MySql table that stores engine models.
Some motors are not compatible with individual housings.
There can be many boxes.
A certain engine may not be compatible with a certain tank, etc.
How can I organize the storage of a list of "incompatibilities" for each engine? Because the number of entries is finite and relatively small, it is planned to make a column in which IDs of incompatible parts will be written through the separator as a line. But incompatible parts can be stored in different tables, and their IDs in their tables can match! How to organize the database structure?

Answer 1

1. Separate tables
2. json
3. ENUM
4. A string separated by a delimiter.
The uniqueness of this must be guaranteed when recording. If there is already data for this category, then do not add it.

Answer 2

cases
engines
cases2engines
id
case_id
engine_id