Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE AreaLogistica(idAreaLogistica INT PRIMARY KEY NOT NULL,
- identificacionEmpleado INT NOT NULL,
- nombreEmpleado VARCHAR(60) NOT NULL,
- correo VARCHAR(20),
- telefono VARCHAR(20) NOT NULL,
- cumpleaños DATE NOT NULL);
- CREATE TABLE Pedido(codigoPedido INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- fechaPedido DATE NOT NULL,
- descripcionPedido VARCHAR(300),
- fk_idCliente VARCHAR(30) NOT NULL,
- FOREIGN KEY (fk_idCliente) REFERENCES Cliente(idCliente));
- insert into arealogistica(idAreaLogistica, identificacionEmpleado, nombreEmpleado, correo, telefono, cumpleaños, fk_codigoPedido, fk_nit)
- values(2,1037890755, 'Jeferson Andres Moreno', 'moreno23@gmail.com', '3105678456', '1998-06-09', 1, '900.017.253-6'),
- (2,1037890755, 'Jeferson Andres Moreno', 'moreno23@gmail.com', '3105678456', '1998-06-09', 2, '900.017.253-6'),
- (2,1037890755, 'Jeferson Andres Moreno', 'moreno23@gmail.com', '3105678456', '1998-06-09', 3, '900.017.253-6');
Add Comment
Please, Sign In to add comment