p68ArVxY

1CREATE TABLE IF NOT EXISTS `tallermecanico_hd`.`e_vehiculos` (
2`placa` INT NOT NULL,
3`marca` VARCHAR(25) NULL,
4`modelo` VARCHAR(25) NULL,
5`anio` VARCHAR(4) NULL,
6`observ` VARCHAR(255) NULL,
7`serial` VARCHAR(25) NULL,
8`color` VARCHAR(25) NULL,
9`puertas` INT,
10`motor` VARCHAR(25) NULL,
11`transmision` VARCHAR(25) NULL,
12//<<<aqui yo colocaria el campo foraneo cedula_c pero workbench no lo hizo<<<
13PRIMARY KEY (`placa`),
14CONSTRAINT `cedula_c`
15FOREIGN KEY ()
16REFERENCES `tallermecanico_hd`.`c_clientes` ()
17ON DELETE CASCADE
18ON UPDATE CASCADE)
19ENGINE = InnoDB;
20	
21FOREINGN KEY(cedula_c)REFERENCES c_clientes