MySQL Workbench Forward Engineering
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET@OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Schema Polleria-- -----------------------------------------------------
-------------------------------------------------------
-- Schema Polleria-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `Polleria` DEFAULT CHARACTER SET utf8 COLLATEutf8_general_ci ;USE `Polleria` ;-- -----------------------------------------------------
-- Table `Polleria`.`TipoEmpleado`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS`Polleria`.`TipoEmpleado` (
`idTipo` INT NOT NULL,
`Descripcion` VARCHAR(45) NULL,
PRIMARY KEY (`idTipo`))
ENGINE = InnoDB;
-- -----------------------------------------------------
--Table `Polleria`.`Departamento`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Polleria`.`Departamento` (
`idDepartamento` INT NOT NULL,
`Descripcion`VARCHAR(45) NULL,
PRIMARY KEY (`idDepartamento`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `Polleria`.`Empleado`
-------------------------------------------------------
CREATE TABLE IF NOT EXISTS `Polleria`.`Empleado` (
`idEmpleado` INT NOT NULL,
`Nombre` VARCHAR(45) NULL,
`Apellido` VARCHAR(45) NULL,
`Sexo` CHAR(1) NULL,
`Direccion`VARCHAR(50) NULL,
`Telefono` VARCHAR(11) NULL,
`idTipo` INT NOT NULL,
`idDepartamento` INT NOT NULL,
PRIMARY KEY (`idEmpleado`))
ENGINE = InnoDB;
-------------------------------------------------------
-- Table `Polleria`.`TipodePago`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Polleria`.`TipodePago` (
`idTipodePago` INT NOT NULL,...
Regístrate para leer el documento completo.