Created
September 6, 2022 16:04
-
-
Save codigoconjuan/55c8521c79b458344f95fc938d3df9a0 to your computer and use it in GitHub Desktop.
Base de datos de Registro
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE `registros` ( | |
| `id` int NOT NULL AUTO_INCREMENT, | |
| `paquete_id` int DEFAULT NULL, | |
| `pago_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, | |
| `token` varchar(8) DEFAULT NULL, | |
| `usuario_id` int DEFAULT NULL, | |
| PRIMARY KEY (`id`), | |
| KEY `usuarioId` (`usuario_id`), | |
| KEY `paquete_id` (`paquete_id`), | |
| CONSTRAINT `registros_ibfk_1` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`), | |
| CONSTRAINT `registros_ibfk_2` FOREIGN KEY (`paquete_id`) REFERENCES `paquetes` (`id`) | |
| ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Very important good😊🤙🏾