QGbvCASH

1DROP TABLE IF EXISTS `prestamo`;
2CREATE TABLE `prestamo` (
3  `id_prestamo` bigint(20) NOT NULL AUTO_INCREMENT,
4  `id_libro` bigint(20) NOT NULL,
5  `id_user` bigint(20) NOT NULL,
6  `prorroga` tinyint(4) NOT NULL,
7  `f_prestamo` date NOT NULL,
8  `f_devolucion` date NOT NULL,
9  `estado` varchar(13) NOT NULL,
10  PRIMARY KEY (`id_prestamo`),
11  KEY `id_user` (`id_user`),
12  KEY `prestamo_ibfk_1` (`id_libro`),
13  CONSTRAINT `prestamo_ibfk_1` FOREIGN KEY (`id_libro`) REFERENCES `libro` (`id_libro`) ON DELETE CASCADE,
14  CONSTRAINT `prestamo_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `usuario` (`id_user`) ON DELETE CASCADE
15) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;