Home / Questions / 426215
Accepted
maraet
Asked: 2022-02-06 13:00:59 +0800 CST 2022-02-06 13:00:59 +0800 CST

Add database logic - SQL relationships

  • 772

a question based on a new functionality that I need to implement. Starting from the following image to make it clearer:

enter image description here

I have the properties table that segments the types of properties until now had general services in common.

Now I would like that when selecting, for example, house, it shows me services specific to a house and so on.

The services of a house are different from those of the departments, ph, fifth.

I was thinking of adding a relation to each one, from one to many, for example house_service, department_service, ph_service etc.

Would it be the proper way? Or should I think about it differently?

I really appreciate your time in my consultation.

sql

1 Answers

  1. Best Answer

    For a query to your database to be successful, the relationships should be

    1. Properties can have one property type, and Property Type can belong to many properties;
    2. Properties can have many Services, and Services can belong to many properties

    So when you run your query, you can get the services of a property, depending on its type. In an imaginary example, very basically and broadly speaking, what an ORM would do would be:

    a. SELECT * FROM propiedad WHERE propiedad.tipo = 1 (alli ya tienes tu propiedad y el tipo de propiedad que quieras)
b. SELECT * FROM servicio, propiedad_servicio as ps WHERE ps.propiedad_id = propiedad.id AND ps.servicio_id = servicio.id
c. Se empaqueta todo en un objeto y se devuelve para ser usado como quieras

    The result will be that you will obtain information about your property and its specific services.

    • 0