triggers or mysql stored procedure [closed]


I am carrying out a project of industrial warehouses and warehouses but I have a doubt when making the registration of contracts. When I register a contract, I occupy a warehouse that is identified by its id. The problem comes when I register 2 contracts in a warehouse at the same time. I want to avoid this and they suggested using triggers or stored procedures. I would like to know your opinion and if you can give me an idea of how it would be.

this is the contract table

create table Contratos (
ID_BN int not null,
ID_Empresa int not null,
ID_Contrato int not null AUTO_INCREMENT,
ID_Empleado int not null,
Fecha_Contrato date not null,
Estatus_C varchar (15) not null,
PRIMARY KEY (ID_Contrato));

and it is that of warehouses and ships

create table Bodenave (
ID_BN int not null AUTO_INCREMENT,
Nombre_BN varchar(30) not null,
Tipo varchar (30) not null,
Localizacion varchar (50) not null,
Precio_renta decimal (7,2) not null,
Estatus_BN varchar (15) not null,
Metros_ancho decimal (4,2) not null,
Metros_largo decimal (4,2) not null,
Oficinas varchar (30) not null,

I would appreciate your help

asked by DashCL 28.11.2018 в 06:09

0 answers