Modelo_de_datos_Cliente_Pagos

pagos.sql

CREATE TABLE cliente (
  `id` int(11) NOT NULL,
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO cliente VALUES(1, 'Coca-Cola');
INSERT INTO cliente VALUES(3, 'IBM');
INSERT INTO cliente VALUES(4, 'Logitech');
INSERT INTO cliente VALUES(2, 'Toyota');

CREATE TABLE pago (
  `id` int(11) NOT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `monto` decimal(10,0) NOT NULL,
  `cliente_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO pago VALUES(1, '2017-01-23 09:40:08', '100', 1);
INSERT INTO pago VALUES(2, '2017-01-23 09:40:08', '300', 3);
INSERT INTO pago VALUES(3, '2017-01-23 09:40:08', '400', 4);
INSERT INTO pago VALUES(4, '2017-01-23 09:40:08', '200', 2);
INSERT INTO pago VALUES(8, '2017-01-23 09:40:10', '50', 1);
INSERT INTO pago VALUES(9, '2017-01-23 09:40:10', '150', 3);
INSERT INTO pago VALUES(10, '2017-01-23 09:40:10', '200', 4);
INSERT INTO pago VALUES(11, '2017-01-23 09:40:10', '100', 2);


ALTER TABLE cliente
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `cliente_unq_name` (`name`);

ALTER TABLE pago
  ADD PRIMARY KEY (`id`),
  ADD KEY `cliente_id` (`cliente_id`);

ALTER TABLE cliente
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE pago
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

ALTER TABLE pago
  ADD CONSTRAINT `pago_ibfk_1` FOREIGN KEY (`cliente_id`) REFERENCES `cliente` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;