-- -----------------------------------------------------
-- Table `omohr4`.`cliente`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`cliente` (
`rut_c` INT(9) NOT NULL ,
`nombre` VARCHAR(35) NOT NULL ,
`apellido` VARCHAR(35) NULL ,
`calle_nro` VARCHAR(35) NOT NULL ,
`comuna` VARCHAR(35) NOT NULL ,
`region` VARCHAR(35) NOT NULL ,
PRIMARY KEY (`rut_c`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`agenda_telefonica_cliente`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`agenda_telefonica_cliente` (
`rut_c` INT(9) NOT NULL ,
`telefono` INT(13) NOT NULL ,
INDEX `rut_c` (`rut_c` ASC) ,
CONSTRAINT `rut_c`
FOREIGN KEY (`rut_c` )
REFERENCES `omohr4`.`cliente` (`rut_c` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`orden_pedido`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`orden_pedido` (
`id_orden_pedido` INT NOT NULL AUTO_INCREMENT ,
`rut_c_fk` INT(9) NOT NULL ,
`fecha` DATE NOT NULL ,
PRIMARY KEY (`id_orden_pedido`) ,
INDEX `rut_c_fk` (`rut_c_fk` ASC) ,
CONSTRAINT `rut_c_fk`
FOREIGN KEY (`rut_c_fk` )
REFERENCES `omohr4`.`cliente` (`rut_c` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`proveedor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`proveedor` (
`rut_p` INT(9) NOT NULL ,
`nombre` VARCHAR(35) NOT NULL ,
`apellido` VARCHAR(35) NULL ,
`calle_nro` VARCHAR(35) NOT NULL ,
`comuna` VARCHAR(35) NOT NULL ,
`region` VARCHAR(35) NOT NULL ,
PRIMARY KEY (`rut_p`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`administrador`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`administrador` (
`rut_a` INT(8) NOT NULL ,
`titulo` VARCHAR(35) NOT NULL ,
PRIMARY KEY (`rut_a`) ,
INDEX `rut_a` (`rut_a` ASC) ,
CONSTRAINT `rut_a`
FOREIGN KEY (`rut_a` )
REFERENCES `omohr4`.`empleado` (`rut_e` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`empleado`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`empleado`
(
`rut_e` INT(8) NOT NULL ,
`nombre` VARCHAR(35) NOT NULL ,
`apellido` VARCHAR(35) NOT NULL ,
`calle_nro` VARCHAR(35) NOT NULL ,
`comuna` VARCHAR(35) NOT NULL ,
`region` VARCHAR(35) NOT NULL ,
`fecha_contrato` DATE NOT NULL ,
`tipo_empleado` ENUM('a','v','j') NOT NULL ,
`rut_a_fk` INT(8) NULL ,
PRIMARY KEY (`rut_e`) ,
INDEX `rut_a_fk` (`rut_a_fk` ASC) ,
CONSTRAINT `rut_a_fk`
FOREIGN KEY (`rut_a_fk` )
REFERENCES `omohr4`.`administrador` (`rut_a` )
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`vendedor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`vendedor` (
`rut_v` INT(8) NOT NULL ,
PRIMARY KEY (`rut_v`) ,
INDEX `rut_v` (`rut_v` ASC) ,
CONSTRAINT `rut_v`
FOREIGN KEY (`rut_v` )
REFERENCES `omohr4`.`empleado` (`rut_e` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`entrega`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`entrega` (
`id_entrega` INT NOT NULL AUTO_INCREMENT ,
`rut_c_fk2` INT(9) NOT NULL ,
`rut_v_fk` INT(8) NOT NULL ,
`fecha` DATE NOT NULL ,
PRIMARY KEY (`id_entrega`) ,
INDEX `rut_c_fk2` (`rut_c_fk2` ASC) ,
CONSTRAINT `rut_c_fk2`
FOREIGN KEY (`rut_c_fk2` )
REFERENCES `omohr4`.`cliente` (`rut_c` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `rut_v_fk`
FOREIGN KEY (`rut_v_fk` )
REFERENCES `omohr4`.`vendedor` (`rut_v` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`vehiculo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`vehiculo` (
`vin` VARCHAR(17) NOT NULL ,
`marca` VARCHAR(35) NOT NULL ,
`modelo` VARCHAR(35) NOT NULL ,
`anno` YEAR NOT NULL ,
`precio` INT(9) NOT NULL ,
`color` VARCHAR(35) NOT NULL ,
`tipo` VARCHAR(35) NOT NULL ,
`rut_p` INT(9) NOT NULL ,
`id_entrega` INT NULL AUTO_INCREMENT ,
PRIMARY KEY (`vin`) ,
INDEX `id_entrega` (`id_entrega` ASC) ,
CONSTRAINT `rut_p`
FOREIGN KEY (`rut_p` )
REFERENCES `omohr4`.`proveedor` (`rut_p` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `id_entrega`
FOREIGN KEY (`id_entrega` )
REFERENCES `omohr4`.`entrega` (`id_entrega` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`linea_orden_pedido`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`linea_orden_pedido` (
`id_linea_orden_pedido` INT NOT NULL AUTO_INCREMENT ,
`id_orden_pedido` INT NOT NULL ,
`vin` VARCHAR(17) NOT NULL ,
PRIMARY KEY (`id_linea_orden_pedido`) ,
INDEX `id_orden_pedido` (`id_orden_pedido` ASC) ,
INDEX `vin` (`vin` ASC) ,
CONSTRAINT `id_orden_pedido`
FOREIGN KEY (`id_orden_pedido` )
REFERENCES `omohr4`.`orden_pedido` (`id_orden_pedido` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `vin`
FOREIGN KEY (`vin` )
REFERENCES `omohr4`.`vehiculo` (`vin` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`junior`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`junior` (
`rut_j` INT(8) NOT NULL ,
`cargo_mantencion` VARCHAR(35) NOT NULL ,
PRIMARY KEY (`rut_j`) ,
INDEX `rut_j` (`rut_j` ASC) ,
CONSTRAINT `rut_j`
FOREIGN KEY (`rut_j` )
REFERENCES `omohr4`.`empleado` (`rut_e` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`orden_recibo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`orden_recibo` (
`id_orden_recibo` INT NOT NULL AUTO_INCREMENT ,
`rut_p_fk` INT(9) NOT NULL ,
`fecha` DATE NOT NULL ,
PRIMARY KEY (`id_orden_recibo`) ,
INDEX `rut_p_fk` (`rut_p_fk` ASC) ,
CONSTRAINT `rut_p_fk`
FOREIGN KEY (`rut_p_fk` )
REFERENCES `omohr4`.`proveedor` (`rut_p` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`linea_orden_recibo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`linea_orden_recibo` (
`id_linea_orden_recibo` INT NOT NULL AUTO_INCREMENT ,
`id_orden_recibo` INT NOT NULL ,
`vin_fk` VARCHAR(17) NOT NULL ,
PRIMARY KEY (`id_linea_orden_recibo`) ,
INDEX `id_orden_recibo` (`id_orden_recibo` ASC) ,
INDEX `vin_fk` (`vin_fk` ASC) ,
CONSTRAINT `id_orden_recibo`
FOREIGN KEY (`id_orden_recibo` )
REFERENCES `omohr4`.`orden_recibo` (`id_orden_recibo` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `vin_fk`
FOREIGN KEY (`vin_fk` )
REFERENCES `omohr4`.`vehiculo` (`vin` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`agenda_telefonica_proveedor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`agenda_telefonica_proveedor` (
`rut_p_fk2` INT(9) NOT NULL ,
`telefono` INT(13) NOT NULL ,
INDEX `rut_p_fk2` (`rut_p_fk2` ASC) ,
CONSTRAINT `rut_p_fk2`
FOREIGN KEY (`rut_p_fk2` )
REFERENCES `omohr4`.`proveedor` (`rut_p` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`camion`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`camion` (
`vin_c` VARCHAR(17) NOT NULL ,
`tipo_cabina` VARCHAR(35) NOT NULL ,
`capacidad` INT(4) NOT NULL ,
PRIMARY KEY (`vin_c`) ,
INDEX `vin_c` (`vin_c` ASC) ,
CONSTRAINT `vin_c`
FOREIGN KEY (`vin_c` )
REFERENCES `omohr4`.`vehiculo` (`vin` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `omohr4`.`auto`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `omohr4`.`auto` (
`vin_a` VARCHAR(17) NOT NULL ,
`nro_pasajeros` INT(1) NOT NULL ,
PRIMARY KEY (`vin_a`) ,
INDEX `vin_a` (`vin_a` ASC) ,
CONSTRAINT `vin_a`
FOREIGN KEY (`vin_a` )
REFERENCES `omohr4`.`vehiculo` (`vin` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;