I found some answers on the subject, but I still have some doubts, I will try to be as clear as possible. My Bank Example. I have the following Tables
Table
-
Client > id | name | request
-
client_system > customer_id | system_name (foreign)
-
System > id | id_sist | version
-
Service > id_sist | id_num | id_serie (Foreign key)
-
Number > id | type | lic
-
Series > id | nserie |
In the above model I have the CUSTOMER with the primary key ID name and request (data) as follows the other tables, with the exception of the system_user and Service, related as foreign.
What I am tantando is the following, in the customer registry he will have more than one service option, and the service will have a type and type, I have a serial number, when carrying out the query bring all the service and series of the client within the table.
I have to use INNER JOIN for this rule.
I have the Bank model in MySQL Workbench
Thanks to anyone who can clarify my idea.