I have the following Mysql table:
'estoque_itensconsumo' (
'cod_itensconsumo' INT NOT NULL AUTO_INCREMENT,
'unidade_mendida' VARCHAR(45) NULL,
'estoque_atual' INT NULL,
'quant_minima' INT NULL,
'valor_custo' FLOAT(9,2) NULL,
'registrar_cliente' INT NULL,
'ativo' INT NULL,
PRIMARY KEY ('cod_itensconsumo'))
The company has two branches registered in another table. There is the possibility of transferring products from one branch to another. I have not found an efficient way to separate the items that are in one branch and another.
Example: I have 450 routers Link One model XXXXXX-XXX where 350 are not branch A and another 100 in branch B. How could I distribute these values in the same table, or would I have to have two tables (one for each branch) and register the example router in the two?