Hi everyone, I'm implementing Odoo 13 community in my business and I want to make a few changes in the database structure.
I want that the categories of products to have attributes, for example:
category attribute
switch fiber_ports_quantity
switch isadministrable
switch isPOE
So I want to create a table: category_attributes
Finally other table: product_attributes, so I can match all the attributes values to one specific product, for example:
product id category attribute value
product1 switch fiber_ports_quantity '5'
product1 switch isAdministrable 'true'
product1 switch isPOE 'false'
I dont think that I can do this without making any changes in the database, so my question is:
If I make these changes(create some tables and add columns to existing tables), will i be able to update to a newer version without conflicts?
If yes, should I do this directly from the database or the Odoo API is a better choice?
Thank you!