dudas para comenzar proyecto

[gralf]

bueno, me he echado palante y he llegado a esto

Código MySQL:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
-- 
-- Database: `stocklentesbrujuleando`
-- 
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `cilindro`
-- 
 
CREATE TABLE `cilindro` (
  `ID_cil` int(2) NOT NULL AUTO_INCREMENT,
  `cilindro` decimal(5,2) NOT NULL,
  PRIMARY KEY (`ID_cil`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `entrada`
-- 
 
CREATE TABLE `entrada` (
  `id_entrada` int(5) NOT NULL AUTO_INCREMENT,
  `entrada` int(5) DEFAULT NULL,
  `fecha_entrada` timestamp NULL DEFAULT NULL,
  `tipo_entrada` enum('compra','regul') DEFAULT NULL,
  `id_item` int(5) NOT NULL,
  PRIMARY KEY (`id_entrada`),
  KEY `fk_entrada_item1_idx` (`id_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `esfera`
-- 
 
CREATE TABLE `esfera` (
  `ID_esf` int(5) NOT NULL AUTO_INCREMENT,
  `esfera` decimal(5,2) NOT NULL,
  PRIMARY KEY (`ID_esf`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `item`
-- 
 
CREATE TABLE `item` (
  `item_ID` int(5) NOT NULL AUTO_INCREMENT,
  `ID_Item_Rx_cil` int(2) NOT NULL,
  `ID_Item_RX_esf` int(5) NOT NULL,
  `ID_Item_RX_lente` int(2) NOT NULL,
  PRIMARY KEY (`item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `lentes`
-- 
 
CREATE TABLE `lentes` (
  `ID_lente` int(2) NOT NULL AUTO_INCREMENT,
  `lente` varchar(25) NOT NULL,
  `desc` varchar(45) NOT NULL,
  `Abbe` int(2) NOT NULL,
  `densidad` varchar(15) NOT NULL,
  `geometría` varchar(15) NOT NULL,
  `id_item` int(5) NOT NULL,
  PRIMARY KEY (`ID_lente`),
  UNIQUE KEY `tipo` (`lente`),
  KEY `fk_lentes_item1_idx` (`id_item`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `rx`
-- 
 
CREATE TABLE `rx` (
  `Id_Rx` int(2) NOT NULL DEFAULT '0',
  `ID_Rx_cil` int(2) NOT NULL,
  `ID_Rx_esf` int(5) NOT NULL,
  `id_item` int(5) NOT NULL,
  `rxcol` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Id_Rx`),
  KEY `fk_cilindro_has_esfera_idx_idx` (`ID_Rx_cil`),
  KEY `fk_esfera_has_cilindro_idx_idx` (`ID_Rx_esf`),
  KEY `fk_rx_item1_idx` (`id_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `salida`
-- 
 
CREATE TABLE `salida` (
  `id_salida` int(5) NOT NULL AUTO_INCREMENT,
  `salida` int(5) DEFAULT NULL,
  `fecha_salida` timestamp NULL DEFAULT NULL,
  `tipo_salida` enum('venta','taller','regul') DEFAULT NULL,
  `id_item` int(5) NOT NULL,
  PRIMARY KEY (`id_salida`),
  KEY `fk_salida_item1_idx` (`id_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
-- 
-- Constraints for dumped tables
-- 
 
-- 
-- Constraints for table `entrada`
-- 
ALTER TABLE `entrada`
  ADD CONSTRAINT `fk_entrada_item1` FOREIGN KEY (`id_item`) REFERENCES `item` (`item_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
-- 
-- Constraints for table `lentes`
-- 
ALTER TABLE `lentes`
  ADD CONSTRAINT `fk_lentes_item1` FOREIGN KEY (`id_item`) REFERENCES `item` (`item_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
-- 
-- Constraints for table `rx`
-- 
ALTER TABLE `rx`
  ADD CONSTRAINT `fk_cilindro_has_esfera_idx` FOREIGN KEY (`ID_Rx_cil`) REFERENCES `cilindro` (`ID_cil`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_esfera_has_cilindro_idx` FOREIGN KEY (`ID_Rx_esf`) REFERENCES `esfera` (`ID_esf`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_rx_item1` FOREIGN KEY (`id_item`) REFERENCES `item` (`item_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
-- 
-- Constraints for table `salida`
-- 
ALTER TABLE `salida`
  ADD CONSTRAINT `fk_salida_item1` FOREIGN KEY (`id_item`) REFERENCES `item` (`item_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 

os pongo el err



creo que está bien para ese control de stock.

mis dudas están en las FK, os parece que están puestas correctamente?

gracias de antemano