1
I am with a project to create an e-commerce, in which my doubt refers to the modeling of tables:
Category(ROOT)>sub-categories>sub-categories of sub-category.
As should be these tables, and a product may be within categories pharisaic (root), and in them may also be in sub-categories. The tables would have to be able to work the same as the print below, follows:
Below is an example of what I did:
1
Categories with Sub-Categories, I usually make a single table. In this table I add a field idCategoriaPai.
When making a category registration I leave this field null. When I register a sub-category, I fill this field with the id parent-category.
If this field is filled in, the category is a sub-category. If it is not, the category is the root category.
If you need to return the name of all parent categories in your sub-category just make a recursive function.
This way, you can do several levels of sub-categories.
I don’t know if it’s the best way, but it’s the way I usually work.
Browser other questions tagged mysql database logic
You are not signed in. Login or sign up in order to post.
would say the same thing :)
– Marco Souza
Roberto, I edited my question and added another image, being it reference of your example, would be this?
– Gabriel Filippi
In my view you don’t even need this table
categorias_has_produtos. The fieldCategorias_idcan be directly on the tableProdutos. That’s because, the category and product ratio is1-1, if it were1-Nai yes this third table would be necessary.– Roberto de Campos
but this is the case, the product may be in more than one category at the same time, hence it would be necessary to table categorias_has_products, correct?
– Gabriel Filippi
Ah yes, so it is necessary yes this third table.
– Roberto de Campos
@Robertofagundes, thank you for your help!
– Gabriel Filippi