JINAK

DevMakoto

Dec 8th, 2015

324

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

MySQL 2.89 KB | None | 0 0

raw download clone embed print report

-- MySQL Workbench Synchronization
-- Generated: 2015-12-08 16:17
-- Model: New Model
-- Version: 1.0
-- Project: Name of the project
-- Author: EOL
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
CREATE SCHEMA IF NOT EXISTS `jinak` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
CREATE TABLE IF NOT EXISTS `jinak`.`producto_tipo` (
`id_tipo` INT(11) NOT NULL AUTO_INCREMENT,
`nombre` VARCHAR(45) NULL DEFAULT NULL,
PRIMARY KEY (`id_tipo`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `jinak`.`usuarios` (
`id_usuario` INT(11) NOT NULL,
`codigo` VARCHAR(45) NULL DEFAULT NULL,
`password` VARCHAR(45) NULL DEFAULT NULL,
`nombre` VARCHAR(45) NULL DEFAULT NULL,
PRIMARY KEY (`id_usuario`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `jinak`.`producto` (
`id_producto` INT(11) NOT NULL AUTO_INCREMENT,
`cod_producto` VARCHAR(45) NOT NULL,
`id_tipo` INT(11) NOT NULL,
`nombre` VARCHAR(255) NULL DEFAULT NULL,
`precio` VARCHAR(45) NULL DEFAULT NULL,
`cantidad` VARCHAR(45) NULL DEFAULT NULL,
PRIMARY KEY (`id_producto`, `cod_producto`),
INDEX `fk_producto_producto_tipo1_idx` (`id_tipo` ASC),
CONSTRAINT `fk_producto_tipo`
FOREIGN KEY (`id_tipo`)
REFERENCES `jinak`.`producto_tipo` (`id_tipo`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `jinak`.`factura` (
`cod_factura` INT(11) NOT NULL AUTO_INCREMENT,
`cliente` VARCHAR(45) NULL DEFAULT NULL,
`dni` VARCHAR(45) NULL DEFAULT NULL,
`total` VARCHAR(45) NULL DEFAULT NULL,
`metodo` VARCHAR(45) NULL DEFAULT NULL,
`fecha` VARCHAR(10) NULL DEFAULT NULL,
PRIMARY KEY (`cod_factura`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
CREATE TABLE IF NOT EXISTS `jinak`.`factura_detalle` (
`id_fac_detalle` INT(11) NOT NULL AUTO_INCREMENT,
`cod_factura` INT(11) NOT NULL,
`cod_producto` VARCHAR(45) NULL DEFAULT NULL,
`nombre_producto` VARCHAR(255) NULL DEFAULT NULL,
`cantidad_producto` VARCHAR(45) NULL DEFAULT NULL,
`precio_producto` VARCHAR(45) NULL DEFAULT NULL,
`total` VARCHAR(45) NULL DEFAULT NULL,
PRIMARY KEY (`id_fac_detalle`),
INDEX `fk_factura_detalle_factura1_idx` (`cod_factura` ASC),
CONSTRAINT `fk_factura_detalle_factura1`
FOREIGN KEY (`cod_factura`)
REFERENCES `jinak`.`factura` (`cod_factura`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Add Comment

Please, Sign In to add comment