MariaDB [(none)]> create database PatitasAlAire;
Query OK, 1 row affected (0.009 sec)

MariaDB [(none)]> use PatitasAlAire;
Database changed
MariaDB [PatitasAlAire]> CREATE TABLE CLIENTE (
    ->     idCliente INT PRIMARY KEY,
    ->     Cedula VARCHAR(20),
    ->     NombreUno VARCHAR(50),
    ->     NombreDos VARCHAR(50),
    ->     PrimerApellido VARCHAR(50),
    ->     SegundoApellido VARCHAR(50),
    ->     Correo VARCHAR(100),
    ->     Telefono VARCHAR(20),
    ->     Direccion VARCHAR(200),
    ->     Estado BOOLEAN
    -> );
Query OK, 0 rows affected (0.083 sec)

MariaDB [PatitasAlAire]> CREATE TABLE MASCOTA (
    ->     idMascota INT PRIMARY KEY,
    ->     Nombre VARCHAR(50),
    ->     Color VARCHAR(50),
    ->     Sexo ENUM('Macho', 'Hembra'),
    ->     FechaNacimiento DATE,
    ->     Tamano VARCHAR(20),
    ->     Peso DECIMAL(5,2),
    ->     idRaza INT,
    ->     idCliente INT,
    ->     idPaseador INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idRaza) REFERENCES RAZA(idRaza),
    ->     FOREIGN KEY (idCliente) REFERENCES CLIENTE(idCliente),
    ->     FOREIGN KEY (idPaseador) REFERENCES PASEADOR(idPaseador)
    -> );
ERROR 1005 (HY000): Can't create table `patitasalaire`.`mascota` (errno: 150 "Foreign key constraint is incorrectly formed")
MariaDB [PatitasAlAire]> CREATE TABLE TIPO_MASCOTA (
    ->     idTipoMascota INT PRIMARY KEY,
    ->     Descripcion VARCHAR(100),
    ->     Estado BOOLEAN
    -> );
Query OK, 0 rows affected (0.079 sec)

MariaDB [PatitasAlAire]> CREATE TABLE RAZA (
    ->     idRaza INT PRIMARY KEY,
    ->     Nombre VARCHAR(50),
    ->     Descripcion VARCHAR(100),
    ->     idTipoMascota INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idTipoMascota) REFERENCES TIPO_MASCOTA(idTipoMascota)
    -> );
Query OK, 0 rows affected (0.100 sec)

MariaDB [PatitasAlAire]> CREATE TABLE PASEADOR (
    ->     idPaseador INT PRIMARY KEY,
    ->     Cedula VARCHAR(20),
    ->     NombreUno VARCHAR(50),
    ->     NombreDos VARCHAR(50),
    ->     PrimerApellido VARCHAR(50),
    ->     SegundoApellido VARCHAR(50),
    ->     CorreoElectronico VARCHAR(100),
    ->     Telefono VARCHAR(20),
    ->     Estado BOOLEAN
    -> );
Query OK, 0 rows affected (0.068 sec)

MariaDB [PatitasAlAire]> CREATE TABLE MASCOTA (
    ->     idMascota INT PRIMARY KEY,
    ->     Nombre VARCHAR(50),
    ->     Color VARCHAR(50),
    ->     Sexo ENUM('Macho', 'Hembra'),
    ->     FechaNacimiento DATE,
    ->     Tamano VARCHAR(20),
    ->     Peso DECIMAL(5,2),
    ->     idRaza INT,
    ->     idCliente INT,
    ->     idPaseador INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idRaza) REFERENCES RAZA(idRaza),
    ->     FOREIGN KEY (idCliente) REFERENCES CLIENTE(idCliente),
    ->     FOREIGN KEY (idPaseador) REFERENCES PASEADOR(idPaseador)
    -> );
Query OK, 0 rows affected (0.111 sec)

MariaDB [PatitasAlAire]> CREATE TABLE COMPORTAMIENTO (
    ->     idComportamiento INT PRIMARY KEY,
    ->     Descripcion VARCHAR(100),
    ->     Estado BOOLEAN
    -> );
Query OK, 0 rows affected (0.077 sec)

MariaDB [PatitasAlAire]> CREATE TABLE RAZA_COMPORTAMIENTO (
    ->     idRaza INT,
    ->     idComportamiento INT,
    ->     Estado BOOLEAN,
    ->     PRIMARY KEY (idRaza, idComportamiento),
    ->     FOREIGN KEY (idRaza) REFERENCES RAZA(idRaza),
    ->     FOREIGN KEY (idComportamiento) REFERENCES COMPORTAMIENTO(idComportamiento)
    -> );
Query OK, 0 rows affected (0.114 sec)

MariaDB [PatitasAlAire]> CREATE TABLE HORARIOS (
    ->     idHorarios INT PRIMARY KEY,
    ->     Mes INT,
    ->     Dia INT,
    ->     Hora TIME,
    ->     idPaseador INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idPaseador) REFERENCES PASEADOR(idPaseador)
    -> );
Query OK, 0 rows affected (0.108 sec)

MariaDB [PatitasAlAire]> CREATE TABLE REGISTRO_PASEO (
    ->     idRegistroPaseo INT PRIMARY KEY,
    ->     Descripcion VARCHAR(100),
    ->     Fecha DATE,
    ->     Horainicio TIME,
    ->     HoraFin TIME,
    ->     CantidadMascotas INT,
    ->     idPaseador INT,
    ->     idSitioPaseo INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idPaseador) REFERENCES PASEADOR(idPaseador)
    -> );
Query OK, 0 rows affected (0.103 sec)

MariaDB [PatitasAlAire]> CREATE TABLE SITIO_PASEO (
    ->     idSitioPaseo INT PRIMARY KEY,
    ->     Nombre VARCHAR(50),
    ->     Ubicacion VARCHAR(100),
    ->     Estado BOOLEAN
    -> );
Query OK, 0 rows affected (0.051 sec)

MariaDB [PatitasAlAire]> CREATE TABLE CONTRATOS (
    ->     idContratos INT PRIMARY KEY,
    ->     FechaInicio DATE,
    ->     FechaFin DATE,
    ->     Clausulas TEXT,
    ->     CantidadMascotas INT,
    ->     TotalPago DECIMAL(10, 2),
    ->     idPaseador INT,
    ->     idSitioPaseo INT,
    ->     idRegistroPaseo INT,
    ->     idMascota INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idPaseador) REFERENCES PASEADOR(idPaseador),
    ->     FOREIGN KEY (idSitioPaseo) REFERENCES SITIO_PASEO(idSitioPaseo),
    ->     FOREIGN KEY (idRegistroPaseo) REFERENCES REGISTRO_PASEO(idRegistroPaseo),
    ->     FOREIGN KEY (idMascota) REFERENCES MASCOTA(idMascota)
    -> );
Query OK, 0 rows affected (0.116 sec)

MariaDB [PatitasAlAire]> CREATE TABLE TIPO_PAGO (
    ->     idTipoPago INT PRIMARY KEY,
    ->     NombreTipoPago VARCHAR(50),
    ->     CodigoTipoPago VARCHAR(20),
    ->     idFactura INT,
    ->     Estado BOOLEAN
    -> );
Query OK, 0 rows affected (0.049 sec)

MariaDB [PatitasAlAire]> CREATE TABLE FACTURA (
    ->     idFactura INT PRIMARY KEY,
    ->     Fecha DATE,
    ->     Hora TIME,
    ->     idContratos INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idContratos) REFERENCES CONTRATOS(idContratos)
    -> );
Query OK, 0 rows affected (0.126 sec)

MariaDB [PatitasAlAire]> CREATE TABLE PAGO (
    ->     idPago INT PRIMARY KEY,
    ->     FechaPago DATE,
    ->     Valor DECIMAL(10, 2),
    ->     EstadoPago BOOLEAN,
    ->     idFactura INT,
    ->     idTipoPago INT,
    ->     Estado BOOLEAN,
    ->     FOREIGN KEY (idFactura) REFERENCES FACTURA(idFactura),
    ->     FOREIGN KEY (idTipoPago) REFERENCES TIPO_PAGO(idTipoPago)
    -> );
Query OK, 0 rows affected (0.121 sec)

MariaDB [PatitasAlAire]> CREATE TABLE PERFIL (
    ->     idPerfil INT PRIMARY KEY,
    ->     NombrePerfil VARCHAR(50),
    ->     Estado BOOLEAN
    -> );
Query OK, 0 rows affected (0.040 sec)

MariaDB [PatitasAlAire]> CREATE TABLE USUARIO (
    ->     idUsuario INT PRIMARY KEY,
    ->     NombreUsuario VARCHAR(50),
    ->     Contrasena VARCHAR(100),
    ->     Estado BOOLEAN,
    ->     idPerfil INT,
    ->     FOREIGN KEY (idPerfil) REFERENCES PERFIL(idPerfil)
    -> );
Query OK, 0 rows affected (0.101 sec)

MariaDB [PatitasAlAire]> CREATE TABLE MASCOTA_REGISTRO_PASEO (
    ->     idMascota INT,
    ->     idRegistroPaseo INT,
    ->     Descripcion VARCHAR(100),
    ->     Estado BOOLEAN,
    ->     PRIMARY KEY (idMascota, idRegistroPaseo),
    ->     FOREIGN KEY (idMascota) REFERENCES MASCOTA(idMascota),
    ->     FOREIGN KEY (idRegistroPaseo) REFERENCES REGISTRO_PASEO(idRegistroPaseo)
    -> );
Query OK, 0 rows affected (0.079 sec)

MariaDB [PatitasAlAire]> show tables;
+-------------------------+
| Tables_in_patitasalaire |
+-------------------------+
| cliente                 |
| comportamiento          |
| contratos               |
| factura                 |
| horarios                |
| mascota                 |
| mascota_registro_paseo  |
| pago                    |
| paseador                |
| perfil                  |
| raza                    |
| raza_comportamiento     |
| registro_paseo          |
| sitio_paseo             |
| tipo_mascota            |
| tipo_pago               |
| usuario                 |
+-------------------------+
17 rows in set (0.007 sec)

MariaDB [PatitasAlAire]> INSERT INTO CLIENTE (idCliente, Cedula, NombreUno, NombreDos, PrimerApellido, SegundoApellido, Correo, Telefono, Direccion, Estado) VALUES
    -> (1, '12345678', 'Juan', 'Carlos', 'P‚rez', 'G¢mez', 'juan.perez@example.com', '5551234', 'Calle 1', TRUE),
    -> (2, '87654321', 'Ana', 'Maria', 'Martinez', 'Lopez', 'ana.martinez@example.com', '5555678', 'Calle 2', TRUE),
    -> (3, '23456789', 'Luis', 'Fernando', 'Gonzalez', 'Reyes', 'luis.gonzalez@example.com', '5558765', 'Calle 3', TRUE),
    -> (4, '34567890', 'Sofia', 'Isabel', 'Jimenez', 'Morales', 'sofia.jimenez@example.com', '5554321', 'Calle 4', TRUE),
    -> (5, '45678901', 'Carlos', 'Eduardo', 'Ramirez', 'Sanchez', 'carlos.ramirez@example.com', '5556789', 'Calle 5', TRUE),
    -> (6, '56789012', 'Mar¡a', 'Luisa', 'Hernandez', 'Diaz', 'maria.hernandez@example.com', '5550987', 'Calle 6', TRUE),
    -> (7, '67890123', 'Jos‚', 'Alberto', 'Lopez', 'Salazar', 'jose.lopez@example.com', '5552345', 'Calle 7', TRUE),
    -> (8, '78901234', 'Isabel', 'Cristina', 'Martinez', 'Cordero', 'isabel.martinez@example.com', '5558765', 'Calle 8', TRUE),
    -> (9, '89012345', 'Andr‚s', 'Miguel', 'P‚rez', 'Cruz', 'andres.perez@example.com', '5553456', 'Calle 9', TRUE),
    -> (10, '90123456', 'Valeria', 'Carmen', 'Gonzalez', 'N£¤ez', 'valeria.gonzalez@example.com', '5556543', 'Calle 10', TRUE);
Query OK, 10 rows affected (0.162 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Cliente;
+-----------+----------+-----------+-----------+----------------+-----------------+------------------------------+----------+-----------+--------+
| idCliente | Cedula   | NombreUno | NombreDos | PrimerApellido | SegundoApellido | Correo                       | Telefono | Direccion | Estado |
+-----------+----------+-----------+-----------+----------------+-----------------+------------------------------+----------+-----------+--------+
|         1 | 12345678 | Juan      | Carlos    | P‚rez          | G¢mez           | juan.perez@example.com       | 5551234  | Calle 1   |      1 |
|         2 | 87654321 | Ana       | Maria     | Martinez       | Lopez           | ana.martinez@example.com     | 5555678  | Calle 2   |      1 |
|         3 | 23456789 | Luis      | Fernando  | Gonzalez       | Reyes           | luis.gonzalez@example.com    | 5558765  | Calle 3   |      1 |
|         4 | 34567890 | Sofia     | Isabel    | Jimenez        | Morales         | sofia.jimenez@example.com    | 5554321  | Calle 4   |      1 |
|         5 | 45678901 | Carlos    | Eduardo   | Ramirez        | Sanchez         | carlos.ramirez@example.com   | 5556789  | Calle 5   |      1 |
|         6 | 56789012 | Mar¡a     | Luisa     | Hernandez      | Diaz            | maria.hernandez@example.com  | 5550987  | Calle 6   |      1 |
|         7 | 67890123 | Jos‚      | Alberto   | Lopez          | Salazar         | jose.lopez@example.com       | 5552345  | Calle 7   |      1 |
|         8 | 78901234 | Isabel    | Cristina  | Martinez       | Cordero         | isabel.martinez@example.com  | 5558765  | Calle 8   |      1 |
|         9 | 89012345 | Andr‚s    | Miguel    | P‚rez          | Cruz            | andres.perez@example.com     | 5553456  | Calle 9   |      1 |
|        10 | 90123456 | Valeria   | Carmen    | Gonzalez       | N£¤ez           | valeria.gonzalez@example.com | 5556543  | Calle 10  |      1 |
+-----------+----------+-----------+-----------+----------------+-----------------+------------------------------+----------+-----------+--------+
10 rows in set (0.002 sec)

MariaDB [PatitasAlAire]> INSERT INTO TIPO_MASCOTA (idTipoMascota, Descripcion, Estado) VALUES
    -> (1, 'Perro', TRUE),
    -> (2, 'Gato', TRUE),
    -> (3, 'Loro', TRUE),
    -> (4, 'Tortuga', TRUE),
    -> (5, 'Conejo', TRUE),
    -> (6, 'Hamster', TRUE),
    -> (7, 'Pez', TRUE),
    -> (8, 'Halc¢n', TRUE),
    -> (9, 'Cuy', TRUE),
    -> (10, 'Serpiente', TRUE);
Query OK, 10 rows affected (0.007 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Tipo_Mascota;
+---------------+-------------+--------+
| idTipoMascota | Descripcion | Estado |
+---------------+-------------+--------+
|             1 | Perro       |      1 |
|             2 | Gato        |      1 |
|             3 | Loro        |      1 |
|             4 | Tortuga     |      1 |
|             5 | Conejo      |      1 |
|             6 | Hamster     |      1 |
|             7 | Pez         |      1 |
|             8 | Halc¢n      |      1 |
|             9 | Cuy         |      1 |
|            10 | Serpiente   |      1 |
+---------------+-------------+--------+
10 rows in set (0.001 sec)

MariaDB [PatitasAlAire]> INSERT INTO RAZA (idRaza, Nombre, Descripcion, idTipoMascota, Estado) VALUES
    -> (1, 'Labrador', 'Raza grande', 1, TRUE),
    -> (2, 'Pastor Alem n', 'Raza de trabajo', 1, TRUE),
    -> (3, 'Bulldog', 'Raza robusta', 1, TRUE),
    -> (4, 'Persa', 'Raza de gato', 2, TRUE),
    -> (5, 'Siam‚s', 'Raza de gato', 2, TRUE),
    -> (6, 'Cacat£a', 'Ave colorida', 3, TRUE),
    -> (7, 'Terrapin', 'Tortuga de agua', 4, TRUE),
    -> (8, 'Angora', 'Conejo de orejas largas', 5, TRUE),
    -> (9, 'Dwarf', 'Hamster enano', 6, TRUE),
    -> (10, 'Guppy', 'Pez de agua dulce', 7, TRUE);
Query OK, 10 rows affected (0.011 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Raza;
+--------+---------------+-------------------------+---------------+--------+
| idRaza | Nombre        | Descripcion             | idTipoMascota | Estado |
+--------+---------------+-------------------------+---------------+--------+
|      1 | Labrador      | Raza grande             |             1 |      1 |
|      2 | Pastor Alem n | Raza de trabajo         |             1 |      1 |
|      3 | Bulldog       | Raza robusta            |             1 |      1 |
|      4 | Persa         | Raza de gato            |             2 |      1 |
|      5 | Siam‚s        | Raza de gato            |             2 |      1 |
|      6 | Cacat£a       | Ave colorida            |             3 |      1 |
|      7 | Terrapin      | Tortuga de agua         |             4 |      1 |
|      8 | Angora        | Conejo de orejas largas |             5 |      1 |
|      9 | Dwarf         | Hamster enano           |             6 |      1 |
|     10 | Guppy         | Pez de agua dulce       |             7 |      1 |
+--------+---------------+-------------------------+---------------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO PASEADOR (idPaseador, Cedula, NombreUno, NombreDos, PrimerApellido, SegundoApellido, CorreoElectronico, Telefono, Estado) VALUES
    -> (1, '12398765', 'Pedro', 'Luis', 'Ram¡rez', 'Gonz lez', 'pedro.ramirez@example.com', '5558765', TRUE),
    -> (2, '98712345', 'Lucia', 'Sofia', 'Ortega', 'Fern ndez', 'lucia.ortega@example.com', '5554321', TRUE),
    -> (3, '15975348', 'Jorge', 'Alejandro', 'Cruz', 'Vargas', 'jorge.cruz@example.com', '5551234', TRUE),
    -> (4, '25896314', 'Ana', 'Luc¡a', 'P‚rez', 'Mart¡nez', 'ana.perez@example.com', '5555678', TRUE),
    -> (5, '35715964', 'Miguel', 'Angel', 'Santos', 'Torres', 'miguel.santos@example.com', '5558765', TRUE),
    -> (6, '14725836', 'Claudia', 'Natalia', 'Ordo¤ez', 'Quintero', 'claudia.ordonez@example.com', '5554321', TRUE),
    -> (7, '96385274', 'Roberto', 'Carlos', 'D¡az', 'Hern ndez', 'roberto.diaz@example.com', '5556789', TRUE),
    -> (8, '75395142', 'Carolina', 'Milagros', 'Cordero', 'Salazar', 'carolina.cordero@example.com', '5552345', TRUE),
    -> (9, '85274169', 'Fernando', 'David', 'Ceballos', 'N£¤ez', 'fernando.ceballos@example.com', '5558765', TRUE),
    -> (10, '45612378', 'Isabella', 'Fernanda', 'L¢pez', 'Mora', 'isabella.lopez@example.com', '5553456', TRUE);
Query OK, 10 rows affected (0.015 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Paseador;
+------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+
| idPaseador | Cedula   | NombreUno | NombreDos | PrimerApellido | SegundoApellido | CorreoElectronico             | Telefono | Estado |
+------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+
|          1 | 12398765 | Pedro     | Luis      | Ram¡rez        | Gonz lez        | pedro.ramirez@example.com     | 5558765  |      1 |
|          2 | 98712345 | Lucia     | Sofia     | Ortega         | Fern ndez       | lucia.ortega@example.com      | 5554321  |      1 |
|          3 | 15975348 | Jorge     | Alejandro | Cruz           | Vargas          | jorge.cruz@example.com        | 5551234  |      1 |
|          4 | 25896314 | Ana       | Luc¡a     | P‚rez          | Mart¡nez        | ana.perez@example.com         | 5555678  |      1 |
|          5 | 35715964 | Miguel    | Angel     | Santos         | Torres          | miguel.santos@example.com     | 5558765  |      1 |
|          6 | 14725836 | Claudia   | Natalia   | Ordo¤ez        | Quintero        | claudia.ordonez@example.com   | 5554321  |      1 |
|          7 | 96385274 | Roberto   | Carlos    | D¡az           | Hern ndez       | roberto.diaz@example.com      | 5556789  |      1 |
|          8 | 75395142 | Carolina  | Milagros  | Cordero        | Salazar         | carolina.cordero@example.com  | 5552345  |      1 |
|          9 | 85274169 | Fernando  | David     | Ceballos       | N£¤ez           | fernando.ceballos@example.com | 5558765  |      1 |
|         10 | 45612378 | Isabella  | Fernanda  | L¢pez          | Mora            | isabella.lopez@example.com    | 5553456  |      1 |
+------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO MASCOTA (idMascota, Nombre, Color, Sexo, FechaNacimiento, Tamano, Peso, idRaza, idCliente, idPaseador, Estado) VALUES
    -> (1, 'Fido', 'Marr¢n', 'Macho', '2020-01-15', 'Mediano', 20.5, 1, 1, 1, TRUE),
    -> (2, 'Bella', 'Negro', 'Hembra', '2019-05-20', 'Grande', 30.0, 2, 2, 2, TRUE),
    -> (3, 'Rex', 'Dorado', 'Macho', '2018-03-10', 'Grande', 35.0, 1, 3, 3, TRUE),
    -> (4, 'Luna', 'Blanco', 'Hembra', '2021-06-25', 'Peque¤o', 10.0, 3, 4, 4, TRUE),
    -> (5, 'Miau', 'Gris', 'Hembra', '2017-11-05', 'Peque¤o', 4.5, 4, 5, 5, TRUE),
    -> (6, 'Bunny', 'Blanco', 'Macho', '2022-02-12', 'Peque¤o', 2.0, 8, 6, 6, TRUE),
    -> (7, 'Chico', 'Verde', 'Macho', '2023-07-18', 'Mediano', 1.0, 6, 7, 7, TRUE),
    -> (8, 'Dora', 'Amarillo', 'Hembra', '2020-09-01', 'Peque¤o', 5.0, 5, 8, 8, TRUE),
    -> (9, 'Tina', 'Marr¢n', 'Hembra', '2019-12-30', 'Mediano', 15.0, 2, 9, 9, TRUE),
    -> (10, 'Kiki', 'Rojo', 'Macho', '2021-08-15', 'Peque¤o', 3.5, 3, 10, 10, TRUE);
Query OK, 10 rows affected (0.023 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Mascota;
+-----------+--------+----------+--------+-----------------+---------+-------+--------+-----------+------------+--------+
| idMascota | Nombre | Color    | Sexo   | FechaNacimiento | Tamano  | Peso  | idRaza | idCliente | idPaseador | Estado |
+-----------+--------+----------+--------+-----------------+---------+-------+--------+-----------+------------+--------+
|         1 | Fido   | Marr¢n   | Macho  | 2020-01-15      | Mediano | 20.50 |      1 |         1 |          1 |      1 |
|         2 | Bella  | Negro    | Hembra | 2019-05-20      | Grande  | 30.00 |      2 |         2 |          2 |      1 |
|         3 | Rex    | Dorado   | Macho  | 2018-03-10      | Grande  | 35.00 |      1 |         3 |          3 |      1 |
|         4 | Luna   | Blanco   | Hembra | 2021-06-25      | Peque¤o | 10.00 |      3 |         4 |          4 |      1 |
|         5 | Miau   | Gris     | Hembra | 2017-11-05      | Peque¤o |  4.50 |      4 |         5 |          5 |      1 |
|         6 | Bunny  | Blanco   | Macho  | 2022-02-12      | Peque¤o |  2.00 |      8 |         6 |          6 |      1 |
|         7 | Chico  | Verde    | Macho  | 2023-07-18      | Mediano |  1.00 |      6 |         7 |          7 |      1 |
|         8 | Dora   | Amarillo | Hembra | 2020-09-01      | Peque¤o |  5.00 |      5 |         8 |          8 |      1 |
|         9 | Tina   | Marr¢n   | Hembra | 2019-12-30      | Mediano | 15.00 |      2 |         9 |          9 |      1 |
|        10 | Kiki   | Rojo     | Macho  | 2021-08-15      | Peque¤o |  3.50 |      3 |        10 |         10 |      1 |
+-----------+--------+----------+--------+-----------------+---------+-------+--------+-----------+------------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO COMPORTAMIENTO (idComportamiento, Descripcion, Estado) VALUES
    -> (1, 'Amigable', TRUE),
    -> (2, 'Agresivo', TRUE),
    -> (3, 'Juguet¢n', TRUE),
    -> (4, 'T¡mido', TRUE),
    -> (5, 'Cazador', TRUE),
    -> (6, 'Protector', TRUE),
    -> (7, 'Sociable', TRUE),
    -> (8, 'Independiente', TRUE),
    -> (9, 'Curioso', TRUE),
    -> (10, 'Tranquilo', TRUE);
Query OK, 10 rows affected (0.017 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Comportamiento;
+------------------+---------------+--------+
| idComportamiento | Descripcion   | Estado |
+------------------+---------------+--------+
|                1 | Amigable      |      1 |
|                2 | Agresivo      |      1 |
|                3 | Juguet¢n      |      1 |
|                4 | T¡mido        |      1 |
|                5 | Cazador       |      1 |
|                6 | Protector     |      1 |
|                7 | Sociable      |      1 |
|                8 | Independiente |      1 |
|                9 | Curioso       |      1 |
|               10 | Tranquilo     |      1 |
+------------------+---------------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO RAZA_COMPORTAMIENTO (idRaza, idComportamiento, Estado) VALUES
    -> (1, 1, TRUE),
    -> (1, 2, TRUE),
    -> (2, 3, TRUE),
    -> (2, 4, TRUE),
    -> (3, 5, TRUE),
    -> (3, 6, TRUE),
    -> (4, 7, TRUE),
    -> (4, 8, TRUE),
    -> (5, 9, TRUE),
    -> (5, 10, TRUE);
Query OK, 10 rows affected (0.025 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Raza_Comportamiento;
+--------+------------------+--------+
| idRaza | idComportamiento | Estado |
+--------+------------------+--------+
|      1 |                1 |      1 |
|      1 |                2 |      1 |
|      2 |                3 |      1 |
|      2 |                4 |      1 |
|      3 |                5 |      1 |
|      3 |                6 |      1 |
|      4 |                7 |      1 |
|      4 |                8 |      1 |
|      5 |                9 |      1 |
|      5 |               10 |      1 |
+--------+------------------+--------+
10 rows in set (0.001 sec)

MariaDB [PatitasAlAire]> INSERT INTO HORARIOS (idHorario, Mes, Dia, Hora, idPaseador, Estado) VALUES
    -> (1, 'Enero', 'Lunes', '08:00', 1, TRUE),
    -> (2, 'Febrero', 'Martes', '10:00', 2, TRUE),
    -> (3, 'Marzo', 'Mi‚rcoles', '12:00', 3, TRUE),
    -> (4, 'Abril', 'Jueves', '14:00', 4, TRUE),
    -> (5, 'Mayo', 'Viernes', '16:00', 5, TRUE),
    -> (6, 'Junio', 'S bado', '18:00', 6, TRUE),
    -> (7, 'Julio', 'Domingo', '09:00', 7, TRUE),
    -> (8, 'Agosto', 'Lunes', '11:00', 8, TRUE),
    -> (9, 'Septiembre', 'Martes', '13:00', 9, TRUE),
    -> (10, 'Octubre', 'Mi‚rcoles', '15:00', 10, TRUE);
ERROR 1054 (42S22): Unknown column 'idHorario' in 'field list'
MariaDB [PatitasAlAire]> 
MariaDB [PatitasAlAire]> describe Horarios;
+------------+------------+------+-----+---------+-------+
| Field      | Type       | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| idHorarios | int(11)    | NO   | PRI | NULL    |       |
| Mes        | int(11)    | YES  |     | NULL    |       |
| Dia        | int(11)    | YES  |     | NULL    |       |
| Hora       | time       | YES  |     | NULL    |       |
| idPaseador | int(11)    | YES  | MUL | NULL    |       |
| Estado     | tinyint(1) | YES  |     | NULL    |       |
+------------+------------+------+-----+---------+-------+
6 rows in set (0.023 sec)

MariaDB [PatitasAlAire]> INSERT INTO HORARIOS (idHorarios, Mes, Dia, Hora, idPaseador, Estado) VALUES
    -> (1, 'Enero', 'Lunes', '08:00', 1, TRUE),
    -> (2, 'Febrero', 'Martes', '10:00', 2, TRUE),
    -> (3, 'Marzo', 'Mi‚rcoles', '12:00', 3, TRUE),
    -> (4, 'Abril', 'Jueves', '14:00', 4, TRUE),
    -> (5, 'Mayo', 'Viernes', '16:00', 5, TRUE),
    -> (6, 'Junio', 'S bado', '18:00', 6, TRUE),
    -> (7, 'Julio', 'Domingo', '09:00', 7, TRUE),
    -> (8, 'Agosto', 'Lunes', '11:00', 8, TRUE),
    -> (9, 'Septiembre', 'Martes', '13:00', 9, TRUE),
    -> (10, 'Octubre', 'Mi‚rcoles', '15:00', 10, TRUE);
Query OK, 10 rows affected, 20 warnings (0.020 sec)
Records: 10  Duplicates: 0  Warnings: 20

MariaDB [PatitasAlAire]> select * from Horarios;
+------------+------+------+----------+------------+--------+
| idHorarios | Mes  | Dia  | Hora     | idPaseador | Estado |
+------------+------+------+----------+------------+--------+
|          1 |    0 |    0 | 08:00:00 |          1 |      1 |
|          2 |    0 |    0 | 10:00:00 |          2 |      1 |
|          3 |    0 |    0 | 12:00:00 |          3 |      1 |
|          4 |    0 |    0 | 14:00:00 |          4 |      1 |
|          5 |    0 |    0 | 16:00:00 |          5 |      1 |
|          6 |    0 |    0 | 18:00:00 |          6 |      1 |
|          7 |    0 |    0 | 09:00:00 |          7 |      1 |
|          8 |    0 |    0 | 11:00:00 |          8 |      1 |
|          9 |    0 |    0 | 13:00:00 |          9 |      1 |
|         10 |    0 |    0 | 15:00:00 |         10 |      1 |
+------------+------+------+----------+------------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO REGISTRO_PASEO (idRegistroPaseo, Descripcion, Fecha, Horainicio, Horafin, CantidadMascotas, idPaseador, idSitioPaseo, Estado) VALUES
    -> (1, 'Paseo en el parque', '2024-01-01', '08:00', '09:00', 3, 1, 1, TRUE),
    -> (2, 'Paseo en el bosque', '2024-01-02', '10:00', '11:00', 2, 2, 2, TRUE),
    -> (3, 'Paseo en la playa', '2024-01-03', '12:00', '13:00', 5, 3, 3, TRUE),
    -> (4, 'Paseo en el centro', '2024-01-04', '14:00', '15:00', 4, 4, 4, TRUE),
    -> (5, 'Paseo en la monta¤a', '2024-01-05', '16:00', '17:00', 3, 5, 5, TRUE),
    -> (6, 'Paseo en el r¡o', '2024-01-06', '18:00', '19:00', 1, 6, 6, TRUE),
    -> (7, 'Paseo en el lago', '2024-01-07', '09:00', '10:00', 2, 7, 7, TRUE),
    -> (8, 'Paseo en la ciudad', '2024-01-08', '11:00', '12:00', 4, 8, 8, TRUE),
    -> (9, 'Paseo en el campo', '2024-01-09', '13:00', '14:00', 2, 9, 9, TRUE),
    -> (10, 'Paseo en el valle', '2024-01-10', '15:00', '16:00', 3, 10, 10, TRUE);
Query OK, 10 rows affected (0.025 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Registro_Paseo;
+-----------------+---------------------+------------+------------+----------+------------------+------------+--------------+--------+
| idRegistroPaseo | Descripcion         | Fecha      | Horainicio | HoraFin  | CantidadMascotas | idPaseador | idSitioPaseo | Estado |
+-----------------+---------------------+------------+------------+----------+------------------+------------+--------------+--------+
|               1 | Paseo en el parque  | 2024-01-01 | 08:00:00   | 09:00:00 |                3 |          1 |            1 |      1 |
|               2 | Paseo en el bosque  | 2024-01-02 | 10:00:00   | 11:00:00 |                2 |          2 |            2 |      1 |
|               3 | Paseo en la playa   | 2024-01-03 | 12:00:00   | 13:00:00 |                5 |          3 |            3 |      1 |
|               4 | Paseo en el centro  | 2024-01-04 | 14:00:00   | 15:00:00 |                4 |          4 |            4 |      1 |
|               5 | Paseo en la monta¤a | 2024-01-05 | 16:00:00   | 17:00:00 |                3 |          5 |            5 |      1 |
|               6 | Paseo en el r¡o     | 2024-01-06 | 18:00:00   | 19:00:00 |                1 |          6 |            6 |      1 |
|               7 | Paseo en el lago    | 2024-01-07 | 09:00:00   | 10:00:00 |                2 |          7 |            7 |      1 |
|               8 | Paseo en la ciudad  | 2024-01-08 | 11:00:00   | 12:00:00 |                4 |          8 |            8 |      1 |
|               9 | Paseo en el campo   | 2024-01-09 | 13:00:00   | 14:00:00 |                2 |          9 |            9 |      1 |
|              10 | Paseo en el valle   | 2024-01-10 | 15:00:00   | 16:00:00 |                3 |         10 |           10 |      1 |
+-----------------+---------------------+------------+------------+----------+------------------+------------+--------------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO SITIO_PASEO (idSitioPaseo, Nombre, Ubicacion, Estado) VALUES
    -> (1, 'Parque Central', 'Zona Norte', TRUE),
    -> (2, 'Bosque Nacional', 'Zona Oeste', TRUE),
    -> (3, 'Playa Dorada', 'Zona Sur', TRUE),
    -> (4, 'Centro Hist¢rico', 'Zona Este', TRUE),
    -> (5, 'Monta¤a Verde', 'Zona Noreste', TRUE),
    -> (6, 'R¡o Azul', 'Zona Suroeste', TRUE),
    -> (7, 'Lago Sereno', 'Zona Sureste', TRUE),
    -> (8, 'Ciudad Moderna', 'Zona Centro', TRUE),
    -> (9, 'Campo Abierto', 'Zona Rural', TRUE),
    -> (10, 'Valle Florido', 'Zona Monta¤osa', TRUE);
Query OK, 10 rows affected (0.015 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Sitio_Paseo;
+--------------+------------------+----------------+--------+
| idSitioPaseo | Nombre           | Ubicacion      | Estado |
+--------------+------------------+----------------+--------+
|            1 | Parque Central   | Zona Norte     |      1 |
|            2 | Bosque Nacional  | Zona Oeste     |      1 |
|            3 | Playa Dorada     | Zona Sur       |      1 |
|            4 | Centro Hist¢rico | Zona Este      |      1 |
|            5 | Monta¤a Verde    | Zona Noreste   |      1 |
|            6 | R¡o Azul         | Zona Suroeste  |      1 |
|            7 | Lago Sereno      | Zona Sureste   |      1 |
|            8 | Ciudad Moderna   | Zona Centro    |      1 |
|            9 | Campo Abierto    | Zona Rural     |      1 |
|           10 | Valle Florido    | Zona Monta¤osa |      1 |
+--------------+------------------+----------------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO CONTRATOS (idContrato, FechaInicio, FechaFin, Clausulas, CantidadMascotas, TipoPago, Precio, idPaseador, idSitioPaseo, idRegistroPaseo, idMascota, Estado) VALUES
    -> (1, '2024-01-01', '2024-06-01', 'Cl usula A', 3, 'Tarjeta', 150.00, 1, 1, 1, 1, TRUE),
    -> (2, '2024-02-01', '2024-07-01', 'Cl usula B', 2, 'Efectivo', 200.00, 2, 2, 2, 2, TRUE),
    -> (3, '2024-03-01', '2024-08-01', 'Cl usula C', 1, 'Cheque', 250.00, 3, 3, 3, 3, TRUE),
    -> (4, '2024-04-01', '2024-09-01', 'Cl usula D', 5, 'Tarjeta', 300.00, 4, 4, 4, 4, TRUE),
    -> (5, '2024-05-01', '2024-10-01', 'Cl usula E', 4, 'Efectivo', 350.00, 5, 5, 5, 5, TRUE),
    -> (6, '2024-06-01', '2024-11-01', 'Cl usula F', 3, 'Cheque', 400.00, 6, 6, 6, 6, TRUE),
    -> (7, '2024-07-01', '2024-12-01', 'Cl usula G', 2, 'Tarjeta', 450.00, 7, 7, 7, 7, TRUE),
    -> (8, '2024-08-01', '2025-01-01', 'Cl usula H', 4, 'Efectivo', 500.00, 8, 8, 8, 8, TRUE),
    -> (9, '2024-09-01', '2025-02-01', 'Cl usula I', 3, 'Cheque', 550.00, 9, 9, 9, 9, TRUE),
    -> (10, '2024-10-01', '2025-03-01', 'Cl usula J', 1, 'Tarjeta', 600.00, 10, 10, 10, 10, TRUE);
ERROR 1054 (42S22): Unknown column 'idContrato' in 'field list'
MariaDB [PatitasAlAire]> describe Contratos;
+------------------+---------------+------+-----+---------+-------+
| Field            | Type          | Null | Key | Default | Extra |
+------------------+---------------+------+-----+---------+-------+
| idContratos      | int(11)       | NO   | PRI | NULL    |       |
| FechaInicio      | date          | YES  |     | NULL    |       |
| FechaFin         | date          | YES  |     | NULL    |       |
| Clausulas        | text          | YES  |     | NULL    |       |
| CantidadMascotas | int(11)       | YES  |     | NULL    |       |
| TotalPago        | decimal(10,2) | YES  |     | NULL    |       |
| idPaseador       | int(11)       | YES  | MUL | NULL    |       |
| idSitioPaseo     | int(11)       | YES  | MUL | NULL    |       |
| idRegistroPaseo  | int(11)       | YES  | MUL | NULL    |       |
| idMascota        | int(11)       | YES  | MUL | NULL    |       |
| Estado           | tinyint(1)    | YES  |     | NULL    |       |
+------------------+---------------+------+-----+---------+-------+
11 rows in set (0.026 sec)

MariaDB [PatitasAlAire]> INSERT INTO CONTRATOS (idContratos, FechaInicio, FechaFin, Clausulas, CantidadMascotas, TotalPago, idPaseador, idSitioPaseo, idRegistroPaseo, idMascota, Estado) VALUES
    -> (1, '2024-01-01', '2024-06-01', 'Cl usula A', 3, 150.00, 1, 1, 1, 1, TRUE),
    -> (2, '2024-02-01', '2024-07-01', 'Cl usula B', 2, 200.00, 2, 2, 2, 2, TRUE),
    -> (3, '2024-03-01', '2024-08-01', 'Cl usula C', 1, 250.00, 3, 3, 3, 3, TRUE),
    -> (4, '2024-04-01', '2024-09-01', 'Cl usula D', 5, 300.00, 4, 4, 4, 4, TRUE),
    -> (5, '2024-05-01', '2024-10-01', 'Cl usula E', 4, 350.00, 5, 5, 5, 5, TRUE),
    -> (6, '2024-06-01', '2024-11-01', 'Cl usula F', 3, 400.00, 6, 6, 6, 6, TRUE),
    -> (7, '2024-07-01', '2024-12-01', 'Cl usula G', 2, 450.00, 7, 7, 7, 7, TRUE),
    -> (8, '2024-08-01', '2025-01-01', 'Cl usula H', 4, 500.00, 8, 8, 8, 8, TRUE),
    -> (9, '2024-09-01', '2025-02-01', 'Cl usula I', 3, 550.00, 9, 9, 9, 9, TRUE),
    -> (10, '2024-10-01', '2025-03-01', 'Cl usula J', 1, 600.00, 10, 10, 10, 10, TRUE);
Query OK, 10 rows affected (0.020 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from Contratos;
+-------------+-------------+------------+------------+------------------+-----------+------------+--------------+-----------------+-----------+--------+
| idContratos | FechaInicio | FechaFin   | Clausulas  | CantidadMascotas | TotalPago | idPaseador | idSitioPaseo | idRegistroPaseo | idMascota | Estado |
+-------------+-------------+------------+------------+------------------+-----------+------------+--------------+-----------------+-----------+--------+
|           1 | 2024-01-01  | 2024-06-01 | Cl usula A |                3 |    150.00 |          1 |            1 |               1 |         1 |      1 |
|           2 | 2024-02-01  | 2024-07-01 | Cl usula B |                2 |    200.00 |          2 |            2 |               2 |         2 |      1 |
|           3 | 2024-03-01  | 2024-08-01 | Cl usula C |                1 |    250.00 |          3 |            3 |               3 |         3 |      1 |
|           4 | 2024-04-01  | 2024-09-01 | Cl usula D |                5 |    300.00 |          4 |            4 |               4 |         4 |      1 |
|           5 | 2024-05-01  | 2024-10-01 | Cl usula E |                4 |    350.00 |          5 |            5 |               5 |         5 |      1 |
|           6 | 2024-06-01  | 2024-11-01 | Cl usula F |                3 |    400.00 |          6 |            6 |               6 |         6 |      1 |
|           7 | 2024-07-01  | 2024-12-01 | Cl usula G |                2 |    450.00 |          7 |            7 |               7 |         7 |      1 |
|           8 | 2024-08-01  | 2025-01-01 | Cl usula H |                4 |    500.00 |          8 |            8 |               8 |         8 |      1 |
|           9 | 2024-09-01  | 2025-02-01 | Cl usula I |                3 |    550.00 |          9 |            9 |               9 |         9 |      1 |
|          10 | 2024-10-01  | 2025-03-01 | Cl usula J |                1 |    600.00 |         10 |           10 |              10 |        10 |      1 |
+-------------+-------------+------------+------------+------------------+-----------+------------+--------------+-----------------+-----------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO TIPO_PAGO (idTipoPago, NombreTipoPago, CodigoTipoPago, Estado) VALUES
    -> (1, 'Tarjeta de Cr‚dito', 'TC01', TRUE),
    -> (2, 'Tarjeta de D‚bito', 'TD01', TRUE),
    -> (3, 'Efectivo', 'EF01', TRUE),
    -> (4, 'Transferencia Bancaria', 'TB01', TRUE),
    -> (5, 'Pago M¢vil', 'PM01', TRUE),
    -> (6, 'Cheque', 'CH01', TRUE),
    -> (7, 'Paypal', 'PP01', TRUE),
    -> (8, 'Cr‚dito', 'CR01', TRUE),
    -> (9, 'Bitcoin', 'BT01', TRUE),
    -> (10, 'Otro', 'OT01', TRUE);
Query OK, 10 rows affected (0.006 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> Select * from Tipo_Pago;
+------------+------------------------+----------------+-----------+--------+
| idTipoPago | NombreTipoPago         | CodigoTipoPago | idFactura | Estado |
+------------+------------------------+----------------+-----------+--------+
|          1 | Tarjeta de Cr‚dito     | TC01           |      NULL |      1 |
|          2 | Tarjeta de D‚bito      | TD01           |      NULL |      1 |
|          3 | Efectivo               | EF01           |      NULL |      1 |
|          4 | Transferencia Bancaria | TB01           |      NULL |      1 |
|          5 | Pago M¢vil             | PM01           |      NULL |      1 |
|          6 | Cheque                 | CH01           |      NULL |      1 |
|          7 | Paypal                 | PP01           |      NULL |      1 |
|          8 | Cr‚dito                | CR01           |      NULL |      1 |
|          9 | Bitcoin                | BT01           |      NULL |      1 |
|         10 | Otro                   | OT01           |      NULL |      1 |
+------------+------------------------+----------------+-----------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO FACTURA (idFactura, Fecha, Hora, idContrato, Estado) VALUES
    -> (1, '2024-01-01', '10:00', 1, TRUE),
    -> (2, '2024-02-01', '12:00', 2, TRUE),
    -> (3, '2024-03-01', '14:00', 3, TRUE),
    -> (4, '2024-04-01', '16:00', 4, TRUE),
    -> (5, '2024-05-01', '18:00', 5, TRUE),
    -> (6, '2024-06-01', '09:00', 6, TRUE),
    -> (7, '2024-07-01', '11:00', 7, TRUE),
    -> (8, '2024-08-01', '13:00', 8, TRUE),
    -> (9, '2024-09-01', '15:00', 9, TRUE),
    -> (10, '2024-10-01', '17:00', 10, TRUE);
ERROR 1054 (42S22): Unknown column 'idContrato' in 'field list'
MariaDB [PatitasAlAire]> describe factura;
+-------------+------------+------+-----+---------+-------+
| Field       | Type       | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+-------+
| idFactura   | int(11)    | NO   | PRI | NULL    |       |
| Fecha       | date       | YES  |     | NULL    |       |
| Hora        | time       | YES  |     | NULL    |       |
| idContratos | int(11)    | YES  | MUL | NULL    |       |
| Estado      | tinyint(1) | YES  |     | NULL    |       |
+-------------+------------+------+-----+---------+-------+
5 rows in set (0.025 sec)

MariaDB [PatitasAlAire]> INSERT INTO FACTURA (idFactura, Fecha, Hora, idContratos, Estado) VALUES
    -> (1, '2024-01-01', '10:00', 1, TRUE),
    -> (2, '2024-02-01', '12:00', 2, TRUE),
    -> (3, '2024-03-01', '14:00', 3, TRUE),
    -> (4, '2024-04-01', '16:00', 4, TRUE),
    -> (5, '2024-05-01', '18:00', 5, TRUE),
    -> (6, '2024-06-01', '09:00', 6, TRUE),
    -> (7, '2024-07-01', '11:00', 7, TRUE),
    -> (8, '2024-08-01', '13:00', 8, TRUE),
    -> (9, '2024-09-01', '15:00', 9, TRUE),
    -> (10, '2024-10-01', '17:00', 10, TRUE);
Query OK, 10 rows affected (0.006 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from factura;
+-----------+------------+----------+-------------+--------+
| idFactura | Fecha      | Hora     | idContratos | Estado |
+-----------+------------+----------+-------------+--------+
|         1 | 2024-01-01 | 10:00:00 |           1 |      1 |
|         2 | 2024-02-01 | 12:00:00 |           2 |      1 |
|         3 | 2024-03-01 | 14:00:00 |           3 |      1 |
|         4 | 2024-04-01 | 16:00:00 |           4 |      1 |
|         5 | 2024-05-01 | 18:00:00 |           5 |      1 |
|         6 | 2024-06-01 | 09:00:00 |           6 |      1 |
|         7 | 2024-07-01 | 11:00:00 |           7 |      1 |
|         8 | 2024-08-01 | 13:00:00 |           8 |      1 |
|         9 | 2024-09-01 | 15:00:00 |           9 |      1 |
|        10 | 2024-10-01 | 17:00:00 |          10 |      1 |
+-----------+------------+----------+-------------+--------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> INSERT INTO PERFIL (idPerfil, NombrePerfil, Estado) VALUES
    -> (1, 'Administrador', TRUE),
    -> (2, 'Cliente', TRUE),
    -> (3, 'Paseador', TRUE),
    -> (4, 'Recepcionista', TRUE),
    -> (5, 'Gerente', TRUE),
    -> (6, 'Contador', TRUE),
    -> (7, 'Supervisor', TRUE),
    -> (8, 'Soporte T‚cnico', TRUE),
    -> (9, 'Desarrollador', TRUE),
    -> (10, 'Marketing', TRUE);
Query OK, 10 rows affected (0.016 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> Select * from Perfil;
+----------+-----------------+--------+
| idPerfil | NombrePerfil    | Estado |
+----------+-----------------+--------+
|        1 | Administrador   |      1 |
|        2 | Cliente         |      1 |
|        3 | Paseador        |      1 |
|        4 | Recepcionista   |      1 |
|        5 | Gerente         |      1 |
|        6 | Contador        |      1 |
|        7 | Supervisor      |      1 |
|        8 | Soporte T‚cnico |      1 |
|        9 | Desarrollador   |      1 |
|       10 | Marketing       |      1 |
+----------+-----------------+--------+
10 rows in set (0.001 sec)

MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrase¤a, Estado, idPerfil) VALUES
    -> (1, 'admin', 'admin123', TRUE, 1),
    -> (2, 'cliente1', 'cliente123', TRUE, 2),
    -> (3, 'paseador1', 'paseador123', TRUE, 3),
    -> (4, 'recepcionista1', 'recepcionista123', TRUE, 4),
    -> (5, 'gerente1', 'gerente123', TRUE, 5),
    -> (6, 'contador1', 'contador123', TRUE, 6),
    -> (7, 'supervisor1', 'supervisor123', TRUE, 7),
    -> (8, 'soporte1', 'soporte123', TRUE, 8),
    -> (9, 'desarrollador1', 'desarrollador123', TRUE, 9),
    -> (10, 'marketing1', 'marketing123', TRUE, 10);
ERROR 1054 (42S22): Unknown column 'Contrase¤a' in 'field list'
MariaDB [PatitasAlAire]> describe Usuario;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| idUsuario     | int(11)      | NO   | PRI | NULL    |       |
| NombreUsuario | varchar(50)  | YES  |     | NULL    |       |
| Contrasena    | varchar(100) | YES  |     | NULL    |       |
| Estado        | tinyint(1)   | YES  |     | NULL    |       |
| idPerfil      | int(11)      | YES  | MUL | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
5 rows in set (0.029 sec)

MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrasena, Estado, idPerfil) VALUES
    -> (1, 'admin', 'admin123', TRUE, 1),
    -> (2, 'cliente1', 'cliente123', TRUE, 2),
    -> (3, 'paseador1', 'paseador123', TRUE, 3),
    -> (4, 'recepcionista1', 'recepcionista123', TRUE, 4),
    -> (5, 'gerente1', 'gerente123', TRUE, 5),
    -> (6, 'contador1', 'contador123', TRUE, 6),
    -> (7, 'supervisor1', 'supervisor123', TRUE, 7),
    -> (8, 'soporte1', 'soporte123', TRUE, 8),
    -> (9, 'desarrollador1', 'desarrollador123', TRUE, 9),
    -> (10, 'marketing1', 'marketing123', TRUE, 10);
Query OK, 10 rows affected (0.010 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [PatitasAlAire]> select * from usuario;
+-----------+----------------+------------------+--------+----------+
| idUsuario | NombreUsuario  | Contrasena       | Estado | idPerfil |
+-----------+----------------+------------------+--------+----------+
|         1 | admin          | admin123         |      1 |        1 |
|         2 | cliente1       | cliente123       |      1 |        2 |
|         3 | paseador1      | paseador123      |      1 |        3 |
|         4 | recepcionista1 | recepcionista123 |      1 |        4 |
|         5 | gerente1       | gerente123       |      1 |        5 |
|         6 | contador1      | contador123      |      1 |        6 |
|         7 | supervisor1    | supervisor123    |      1 |        7 |
|         8 | soporte1       | soporte123       |      1 |        8 |
|         9 | desarrollador1 | desarrollador123 |      1 |        9 |
|        10 | marketing1     | marketing123     |      1 |       10 |
+-----------+----------------+------------------+--------+----------+
10 rows in set (0.000 sec)

MariaDB [PatitasAlAire]> Exit