MariaDB [PalacioMascotas]> MariaDB [(none)]> DROP DATABASE IF EXISTS PalacioMascotas; Query OK, 15 rows affected (0.191 sec) MariaDB [(none)]> CREATE DATABASE PalacioMascotas; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> USE PalacioMascotas; Database changed MariaDB [PalacioMascotas]> CREATE TABLE Clientes ( -> id_cliente INT AUTO_INCREMENT PRIMARY KEY, -> nombre VARCHAR(120) NOT NULL, -> direccion VARCHAR(200), -> telefono VARCHAR(20), -> correo VARCHAR(150) UNIQUE -> ); Query OK, 0 rows affected (0.028 sec) MariaDB [PalacioMascotas]> CREATE TABLE Mascotas ( -> id_mascota INT AUTO_INCREMENT PRIMARY KEY, -> nombre VARCHAR(100) NOT NULL, -> especie ENUM('Perro','Gato','Ave','Reptil','Roedor','Otro') NOT NULL, -> raza VARCHAR(80), -> edad INT CHECK (edad >= 0), -> peso DECIMAL(6,2) CHECK (peso >= 0), -> id_cliente INT NOT NULL, -> FOREIGN KEY (id_cliente) REFERENCES Clientes(id_cliente) ON DELETE CASCADE -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [PalacioMascotas]> CREATE TABLE Veterinarios ( -> id_veterinario INT AUTO_INCREMENT PRIMARY KEY, -> nombre VARCHAR(120) NOT NULL, -> cedula VARCHAR(40) UNIQUE, -> especialidad VARCHAR(100), -> anos_experiencia INT CHECK (anos_experiencia >= 0) -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [PalacioMascotas]> CREATE TABLE Especialidades ( -> id_especialidad INT AUTO_INCREMENT PRIMARY KEY, -> nombre_especialidad VARCHAR(100) UNIQUE NOT NULL -> ); Query OK, 0 rows affected (0.034 sec) MariaDB [PalacioMascotas]> CREATE TABLE Proveedores ( -> id_proveedor INT AUTO_INCREMENT PRIMARY KEY, -> nombre VARCHAR(150) NOT NULL, -> telefono VARCHAR(20), -> direccion VARCHAR(200), -> correo VARCHAR(150) UNIQUE -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [PalacioMascotas]> CREATE TABLE Medicamentos ( -> id_medicamento INT AUTO_INCREMENT PRIMARY KEY, -> nombre VARCHAR(150) NOT NULL, -> tipo ENUM('Tableta','Inyecci¢n','Pomada','Soluci¢n','Syrup','Otro') DEFAULT 'Tableta', -> cantidad_stock INT CHECK (cantidad_stock >= 0), -> precio_unitario DECIMAL(12,2) COMMENT 'Valor en pesos colombianos (COP)' CHECK (precio_unitario >= 0), -> id_proveedor INT NULL, -> FOREIGN KEY (id_proveedor) REFERENCES Proveedores(id_proveedor) ON DELETE SET NULL -> ); Query OK, 0 rows affected (0.026 sec) MariaDB [PalacioMascotas]> CREATE TABLE Servicios ( -> id_servicio INT AUTO_INCREMENT PRIMARY KEY, -> tipo_servicio ENUM('Consulta','Vacunaci¢n','Cirug¡a','Desparasitaci¢n','Peluquer¡a','Radiograf¡a','Ecograf¡a','Odontolog¡a','Hospitalizaci¢n','Emergencia','Otro') NOT NULL, -> descripcion VARCHAR(250), -> precio DECIMAL(12,2) COMMENT 'Valor en pesos colombianos (COP)' CHECK (precio >= 0) -> ); Query OK, 0 rows affected (0.010 sec) MariaDB [PalacioMascotas]> CREATE TABLE Procedimientos ( -> id_procedimiento INT AUTO_INCREMENT PRIMARY KEY, -> nombre VARCHAR(120) NOT NULL, -> descripcion VARCHAR(250), -> costo DECIMAL(12,2) COMMENT 'Valor en pesos colombianos (COP)' CHECK (costo >= 0) -> ); Query OK, 0 rows affected (0.007 sec) MariaDB [PalacioMascotas]> CREATE TABLE Citas ( -> id_cita INT AUTO_INCREMENT PRIMARY KEY, -> fecha DATE NOT NULL, -> hora TIME NOT NULL, -> id_mascota INT NOT NULL, -> id_veterinario INT NULL, -> motivo VARCHAR(250), -> estado ENUM('Pendiente','Atendida','Cancelada') DEFAULT 'Pendiente', -> FOREIGN KEY (id_mascota) REFERENCES Mascotas(id_mascota) ON DELETE CASCADE, -> FOREIGN KEY (id_veterinario) REFERENCES Veterinarios(id_veterinario) ON DELETE SET NULL -> ); Query OK, 0 rows affected (0.029 sec) MariaDB [PalacioMascotas]> CREATE TABLE Diagnosticos ( -> id_diagnostico INT AUTO_INCREMENT PRIMARY KEY, -> id_cita INT NOT NULL, -> descripcion VARCHAR(300), -> observaciones VARCHAR(300), -> fecha_registro DATETIME DEFAULT CURRENT_TIMESTAMP, -> FOREIGN KEY (id_cita) REFERENCES Citas(id_cita) ON DELETE CASCADE -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [PalacioMascotas]> CREATE TABLE Tratamientos ( -> id_tratamiento INT AUTO_INCREMENT PRIMARY KEY, -> id_diagnostico INT NOT NULL, -> medicamento VARCHAR(150) NOT NULL, -> dosis VARCHAR(80), -> duracion VARCHAR(80), -> fecha_aplicacion DATE DEFAULT CURRENT_DATE, -> FOREIGN KEY (id_diagnostico) REFERENCES Diagnosticos(id_diagnostico) ON DELETE CASCADE -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [PalacioMascotas]> CREATE TABLE Hospitalizaciones ( -> id_hospitalizacion INT AUTO_INCREMENT PRIMARY KEY, -> id_mascota INT NOT NULL, -> fecha_ingreso DATE NOT NULL, -> fecha_salida DATE NULL, -> id_veterinario INT NULL, -> diagnostico VARCHAR(300), -> FOREIGN KEY (id_mascota) REFERENCES Mascotas(id_mascota) ON DELETE CASCADE, -> FOREIGN KEY (id_veterinario) REFERENCES Veterinarios(id_veterinario) ON DELETE SET NULL -> ); Query OK, 0 rows affected (0.025 sec) MariaDB [PalacioMascotas]> CREATE TABLE Facturas ( -> id_factura INT AUTO_INCREMENT PRIMARY KEY, -> id_cliente INT NOT NULL, -> fecha DATE NOT NULL, -> total DECIMAL(12,2) COMMENT 'Valor en pesos colombianos (COP)' CHECK (total >= 0), -> metodo_pago ENUM('Efectivo','Tarjeta','Transferencia','Otro') NOT NULL, -> FOREIGN KEY (id_cliente) REFERENCES Clientes(id_cliente) ON DELETE CASCADE -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [PalacioMascotas]> CREATE TABLE DetalleFactura ( -> id_detalle INT AUTO_INCREMENT PRIMARY KEY, -> id_factura INT NOT NULL, -> id_servicio INT, -> cantidad INT CHECK (cantidad >= 1), -> subtotal DECIMAL(12,2) COMMENT 'Valor en pesos colombianos (COP)' CHECK (subtotal >= 0), -> FOREIGN KEY (id_factura) REFERENCES Facturas(id_factura) ON DELETE CASCADE, -> FOREIGN KEY (id_servicio) REFERENCES Servicios(id_servicio) ON DELETE SET NULL -> ); Query OK, 0 rows affected (0.027 sec) MariaDB [PalacioMascotas]> CREATE TABLE Pagos ( -> id_pago INT AUTO_INCREMENT PRIMARY KEY, -> id_factura INT NOT NULL, -> monto DECIMAL(12,2) COMMENT 'Valor en pesos colombianos (COP)' CHECK (monto >= 0), -> fecha DATE NOT NULL, -> tipo_pago ENUM('Efectivo','Tarjeta','Transferencia','Otro') NOT NULL, -> FOREIGN KEY (id_factura) REFERENCES Facturas(id_factura) ON DELETE CASCADE -> ); Query OK, 0 rows affected (0.022 sec) MariaDB [PalacioMascotas]> CREATE TABLE AuditoriaCambios ( -> id_auditoria INT AUTO_INCREMENT PRIMARY KEY, -> tabla_nombre VARCHAR(100) NOT NULL, -> id_registro INT NOT NULL, -> tipo_accion ENUM('INSERT','UPDATE','DELETE') NOT NULL, -> fecha_accion DATETIME DEFAULT CURRENT_TIMESTAMP, -> usuario VARCHAR(100) -> ); Query OK, 0 rows affected (0.007 sec) MariaDB [PalacioMascotas]> SHOW TABLES; +---------------------------+ | Tables_in_palaciomascotas | +---------------------------+ | auditoriacambios | | citas | | clientes | | detallefactura | | diagnosticos | | especialidades | | facturas | | hospitalizaciones | | mascotas | | medicamentos | | pagos | | procedimientos | | proveedores | | servicios | | tratamientos | | veterinarios | +---------------------------+ 16 rows in set (0.001 sec) MariaDB [PalacioMascotas]> INSERT INTO Clientes (nombre,direccion,telefono,correo) VALUES -> ('Juan Perez','Calle 1 #10-20','3001234567','juan.perez@mail.com'), -> ('Maria Lopez','Cra 5 #12-34','3002345678','maria.lopez@mail.com'), -> ('Carlos Ruiz','Av 7 #23-45','3003456789','carlos.ruiz@mail.com'), -> ('Ana Gomez','Calle 3 #3-21','3004567890','ana.gomez@mail.com'), -> ('Luis Martinez','Cra 10 #20-10','3005678901','luis.martinez@mail.com'), -> ('Sofia Herrera','Av 11 #9-18','3006789012','sofia.h@mail.com'), -> ('Diego Torres','Calle 8 #4-12','3007890123','diego.t@mail.com'), -> ('Laura Rios','Cra 2 #1-05','3008901234','laura.rios@mail.com'), -> ('Andres Molina','Av 4 #14-16','3009012345','andres.m@mail.com'), -> ('Paula Castro','Calle 9 #7-02','3000123456','paula.c@mail.com'); Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Proveedores (nombre,telefono,direccion,correo) VALUES -> ('Proveedor Uno','3001111111','Calle 1','prov1@mail.com'), -> ('Proveedor Dos','3002222222','Calle 2','prov2@mail.com'), -> ('Proveedor Tres','3003333333','Calle 3','prov3@mail.com'), -> ('Proveedor Cuatro','3004444444','Calle 4','prov4@mail.com'), -> ('Proveedor Cinco','3005555555','Calle 5','prov5@mail.com'), -> ('Proveedor Seis','3006666666','Calle 6','prov6@mail.com'), -> ('Proveedor Siete','3007777777','Calle 7','prov7@mail.com'), -> ('Proveedor Ocho','3008888888','Calle 8','prov8@mail.com'), -> ('Proveedor Nueve','3009999999','Calle 9','prov9@mail.com'), -> ('Proveedor Diez','3010000000','Calle 10','prov10@mail.com'); Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Veterinarios (nombre,cedula,especialidad,anos_experiencia) VALUES -> ('Dr. Juan','1001','Medicina Interna',10), -> ('Dra. Maria','1002','Cirug¡a',8), -> ('Dr. Carlos','1003','Dermatolog¡a',12), -> ('Dra. Ana','1004','Odontolog¡a',7), -> ('Dr. Luis','1005','Cardiolog¡a',15), -> ('Dra. Sofia','1006','Neurolog¡a',6), -> ('Dr. Diego','1007','Oftalmolog¡a',9), -> ('Dra. Laura','1008','Reproducci¢n',11), -> ('Dr. Andres','1009','Oncolog¡a',14), -> ('Dra. Paula','1010','Pediatr¡a',5); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Especialidades (nombre_especialidad) VALUES -> ('Medicina Interna'),('Cirug¡a'),('Dermatolog¡a'),('Odontolog¡a'), -> ('Cardiolog¡a'),('Neurolog¡a'),('Oftalmolog¡a'),('Reproducci¢n'), -> ('Oncolog¡a'),('Pediatr¡a'); Query OK, 10 rows affected (0.002 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Servicios (tipo_servicio,descripcion,precio) VALUES -> ('Consulta','Consulta m‚dica general',50000.00), -> ('Vacunaci¢n','Aplicaci¢n de vacuna',30000.00), -> ('Cirug¡a','Procedimiento quir£rgico',200000.00), -> ('Desparasitaci¢n','Tratamiento antiparasitario',40000.00), -> ('Peluquer¡a','Limpieza y corte de pelo',25000.00), -> ('Radiograf¡a','Examen radiol¢gico',60000.00), -> ('Ecograf¡a','Examen de ultrasonido',80000.00), -> ('Odontolog¡a','Tratamiento dental',70000.00), -> ('Hospitalizaci¢n','Cuidado hospitalario',150000.00), -> ('Emergencia','Atenci¢n de urgencia',100000.00); Query OK, 10 rows affected (0.002 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Procedimientos (nombre,descripcion,costo) VALUES -> ('Limpieza dental','Eliminaci¢n de placa y sarro',70000.00), -> ('Suturas','Cierre de heridas',50000.00), -> ('Radiograf¡a','Examen radiol¢gico',60000.00), -> ('Ecograf¡a','Examen de ultrasonido',80000.00), -> ('Cirug¡a menor','Procedimiento quir£rgico simple',100000.00), -> ('Cirug¡a mayor','Procedimiento complejo',250000.00), -> ('Desparasitaci¢n','Eliminaci¢n de par sitos internos',40000.00), -> ('Vacunaci¢n','Aplicaci¢n de vacunas',30000.00), -> ('Chequeo cardiol¢gico','Revisi¢n del coraz¢n',90000.00), -> ('Tratamiento dermatol¢gico','Cuidado de piel y pelaje',75000.00); Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Medicamentos (nombre,tipo,cantidad_stock,precio_unitario,id_proveedor) VALUES -> ('Antibi¢tico','Tableta',100,25500.00,1), -> ('Analg‚sico','Inyecci¢n',50,40000.00,2), -> ('Vitaminas','Syrup',200,15000.00,3), -> ('Desparasitante','Tableta',150,30000.00,4), -> ('Antif£ngico','Pomada',80,20000.00,5), -> ('Suero','Soluci¢n',60,50000.00,6), -> ('Antihistam¡nico','Tableta',90,18000.00,7), -> ('Vacuna','Inyecci¢n',120,60000.00,8), -> ('Anti-inflamatorio','Tableta',70,35000.00,9), -> ('Sedante','Inyecci¢n',40,45000.00,10); Query OK, 10 rows affected (0.002 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Mascotas (nombre,especie,raza,edad,peso,id_cliente) VALUES -> ('Firulais','Perro','Labrador',3,16.50,1), -> ('Michi','Gato','Siames',2,4.20,2), -> ('Rex','Perro','Pastor Alem n',5,30.00,3), -> ('Luna','Gato','Persa',4,5.10,4), -> ('Max','Perro','Beagle',1,10.50,5), -> ('Nina','Gato','Maine Coon',3,6.80,6), -> ('Toby','Perro','Bulldog',2,20.00,7), -> ('Simba','Gato','Bengala',1,4.30,8), -> ('Rocky','Perro','Boxer',6,28.00,9), -> ('Kira','Gato','Esfinge',2,3.50,10); Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Citas (fecha,hora,id_mascota,id_veterinario,motivo,estado) VALUES -> ('2025-11-01','08:00:00',1,1,'Chequeo general','Pendiente'), -> ('2025-11-02','09:00:00',2,2,'Vacuna anual','Atendida'), -> ('2025-11-03','10:00:00',3,3,'Problema de piel','Pendiente'), -> ('2025-11-04','11:00:00',4,4,'Limpieza dental','Cancelada'), -> ('2025-11-05','12:00:00',5,5,'Chequeo cardiol¢gico','Pendiente'), -> ('2025-11-06','13:00:00',6,6,'Consulta neurol¢gica','Atendida'), -> ('2025-11-07','14:00:00',7,7,'Problema ocular','Pendiente'), -> ('2025-11-08','15:00:00',8,8,'Revisi¢n reproducci¢n','Cancelada'), -> ('2025-11-09','16:00:00',9,9,'Tratamiento oncolog¡a','Pendiente'), -> ('2025-11-10','17:00:00',10,10,'Chequeo pedi trico','Atendida'); Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Diagnosticos (id_cita,descripcion,observaciones) VALUES -> (1,'Gripe leve','Reposo y medicaci¢n'), -> (2,'Vacunaci¢n completa','Sin complicaciones'), -> (3,'Dermatitis','Evitar al‚rgenos'), -> (4,'Problemas dentales','Requiere limpieza profesional'), -> (5,'Arritmia leve','Control y seguimiento'), -> (6,'Convulsiones leves','Iniciar tratamiento'), -> (7,'Conjuntivitis','Tratamiento ocular t¢pico'), -> (8,'Revisi¢n reproductiva','Todo normal'), -> (9,'C ncer detectado','Programar cirug¡a'), -> (10,'Chequeo pedi trico','Sin complicaciones'); Query OK, 10 rows affected (0.006 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Tratamientos (id_diagnostico,medicamento,dosis,duracion) VALUES -> (1,'Antibi¢tico','2 tabletas al d¡a','5 d¡as'), -> (2,'Vacuna','1 dosis','énica'), -> (3,'Antif£ngico','Aplicar 2 veces al d¡a','7 d¡as'), -> (4,'Analg‚sico','1 inyecci¢n','1 d¡a'), -> (5,'Anti-inflamatorio','2 tabletas al d¡a','10 d¡as'), -> (6,'Anticonvulsivo','1 tableta al d¡a','30 d¡as'), -> (7,'Antihistam¡nico','1 tableta al d¡a','14 d¡as'), -> (8,'Vitaminas','5 ml al d¡a','15 d¡as'), -> (9,'Quimioterapia','1 dosis semanal','6 semanas'), -> (10,'Suero','Inyecci¢n cada 12h','3 d¡as'); Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Hospitalizaciones (id_mascota,fecha_ingreso,fecha_salida,id_veterinario,diagnostico) VALUES -> (1,'2025-11-01','2025-11-03',1,'Gripe leve'), -> (2,'2025-11-02','2025-11-02',2,'Observaci¢n post-vacuna'), -> (3,'2025-11-03','2025-11-05',3,'Dermatitis severa'), -> (4,'2025-11-04','2025-11-06',4,'Problemas dentales'), -> (5,'2025-11-05','2025-11-07',5,'Arritmia'), -> (6,'2025-11-06','2025-11-08',6,'Convulsiones'), -> (7,'2025-11-07','2025-11-09',7,'Conjuntivitis complicada'), -> (8,'2025-11-08','2025-11-10',8,'Revisi¢n reproductiva'), -> (9,'2025-11-09','2025-11-11',9,'Tratamiento oncol¢gico'), -> (10,'2025-11-10','2025-11-12',10,'Observaci¢n pedi trica'); Query OK, 10 rows affected (0.006 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Facturas (id_cliente,fecha,total,metodo_pago) VALUES -> (1,'2025-11-01',120000.00,'Efectivo'), -> (2,'2025-11-02',80000.00,'Tarjeta'), -> (3,'2025-11-03',150000.00,'Transferencia'), -> (4,'2025-11-04',60000.00,'Efectivo'), -> (5,'2025-11-05',40000.00,'Tarjeta'), -> (6,'2025-11-06',30000.00,'Efectivo'), -> (7,'2025-11-07',90000.00,'Transferencia'), -> (8,'2025-11-08',180000.00,'Tarjeta'), -> (9,'2025-11-09',55000.00,'Efectivo'), -> (10,'2025-11-10',45000.00,'Efectivo'); Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO DetalleFactura (id_factura,id_servicio,cantidad,subtotal) VALUES -> (1,1,1,50000.00), -> (1,4,1,70000.00), -> (2,2,1,30000.00), -> (3,3,1,150000.00), -> (4,6,1,60000.00), -> (5,5,1,35000.00), -> (6,1,1,30000.00), -> (7,7,1,90000.00), -> (8,8,1,180000.00), -> (9,9,1,55000.00); Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> INSERT INTO Pagos (id_factura,monto,fecha,tipo_pago) VALUES -> (1,120000.00,'2025-11-01','Efectivo'), -> (2,80000.00,'2025-11-02','Tarjeta'), -> (3,150000.00,'2025-11-03','Transferencia'), -> (4,60000.00,'2025-11-04','Efectivo'), -> (5,40000.00,'2025-11-05','Tarjeta'), -> (6,30000.00,'2025-11-06','Efectivo'), -> (7,90000.00,'2025-11-07','Transferencia'), -> (8,180000.00,'2025-11-08','Tarjeta'), -> (9,55000.00,'2025-11-09','Efectivo'), -> (10,45000.00,'2025-11-10','Efectivo'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PalacioMascotas]> SELECT * FROM Clientes; +------------+---------------+----------------+------------+------------------------+ | id_cliente | nombre | direccion | telefono | correo | +------------+---------------+----------------+------------+------------------------+ | 1 | Juan Perez | Calle 1 #10-20 | 3001234567 | juan.perez@mail.com | | 2 | Maria Lopez | Cra 5 #12-34 | 3002345678 | maria.lopez@mail.com | | 3 | Carlos Ruiz | Av 7 #23-45 | 3003456789 | carlos.ruiz@mail.com | | 4 | Ana Gomez | Calle 3 #3-21 | 3004567890 | ana.gomez@mail.com | | 5 | Luis Martinez | Cra 10 #20-10 | 3005678901 | luis.martinez@mail.com | | 6 | Sofia Herrera | Av 11 #9-18 | 3006789012 | sofia.h@mail.com | | 7 | Diego Torres | Calle 8 #4-12 | 3007890123 | diego.t@mail.com | | 8 | Laura Rios | Cra 2 #1-05 | 3008901234 | laura.rios@mail.com | | 9 | Andres Molina | Av 4 #14-16 | 3009012345 | andres.m@mail.com | | 10 | Paula Castro | Calle 9 #7-02 | 3000123456 | paula.c@mail.com | +------------+---------------+----------------+------------+------------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Mascotas; +------------+----------+---------+---------------+------+-------+------------+ | id_mascota | nombre | especie | raza | edad | peso | id_cliente | +------------+----------+---------+---------------+------+-------+------------+ | 1 | Firulais | Perro | Labrador | 3 | 16.50 | 1 | | 2 | Michi | Gato | Siames | 2 | 4.20 | 2 | | 3 | Rex | Perro | Pastor Alem n | 5 | 30.00 | 3 | | 4 | Luna | Gato | Persa | 4 | 5.10 | 4 | | 5 | Max | Perro | Beagle | 1 | 10.50 | 5 | | 6 | Nina | Gato | Maine Coon | 3 | 6.80 | 6 | | 7 | Toby | Perro | Bulldog | 2 | 20.00 | 7 | | 8 | Simba | Gato | Bengala | 1 | 4.30 | 8 | | 9 | Rocky | Perro | Boxer | 6 | 28.00 | 9 | | 10 | Kira | Gato | Esfinge | 2 | 3.50 | 10 | +------------+----------+---------+---------------+------+-------+------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Veterinarios; +----------------+------------+--------+------------------+------------------+ | id_veterinario | nombre | cedula | especialidad | anos_experiencia | +----------------+------------+--------+------------------+------------------+ | 1 | Dr. Juan | 1001 | Medicina Interna | 10 | | 2 | Dra. Maria | 1002 | Cirug¡a | 8 | | 3 | Dr. Carlos | 1003 | Dermatolog¡a | 12 | | 4 | Dra. Ana | 1004 | Odontolog¡a | 7 | | 5 | Dr. Luis | 1005 | Cardiolog¡a | 15 | | 6 | Dra. Sofia | 1006 | Neurolog¡a | 6 | | 7 | Dr. Diego | 1007 | Oftalmolog¡a | 9 | | 8 | Dra. Laura | 1008 | Reproducci¢n | 11 | | 9 | Dr. Andres | 1009 | Oncolog¡a | 14 | | 10 | Dra. Paula | 1010 | Pediatr¡a | 5 | +----------------+------------+--------+------------------+------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Especialidades; +-----------------+---------------------+ | id_especialidad | nombre_especialidad | +-----------------+---------------------+ | 5 | Cardiolog¡a | | 2 | Cirug¡a | | 3 | Dermatolog¡a | | 1 | Medicina Interna | | 6 | Neurolog¡a | | 4 | Odontolog¡a | | 7 | Oftalmolog¡a | | 9 | Oncolog¡a | | 10 | Pediatr¡a | | 8 | Reproducci¢n | +-----------------+---------------------+ 10 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT * FROM Citas; +---------+------------+----------+------------+----------------+-----------------------+-----------+ | id_cita | fecha | hora | id_mascota | id_veterinario | motivo | estado | +---------+------------+----------+------------+----------------+-----------------------+-----------+ | 1 | 2025-11-01 | 08:00:00 | 1 | 1 | Chequeo general | Pendiente | | 2 | 2025-11-02 | 09:00:00 | 2 | 2 | Vacuna anual | Atendida | | 3 | 2025-11-03 | 10:00:00 | 3 | 3 | Problema de piel | Pendiente | | 4 | 2025-11-04 | 11:00:00 | 4 | 4 | Limpieza dental | Cancelada | | 5 | 2025-11-05 | 12:00:00 | 5 | 5 | Chequeo cardiol¢gico | Pendiente | | 6 | 2025-11-06 | 13:00:00 | 6 | 6 | Consulta neurol¢gica | Atendida | | 7 | 2025-11-07 | 14:00:00 | 7 | 7 | Problema ocular | Pendiente | | 8 | 2025-11-08 | 15:00:00 | 8 | 8 | Revisi¢n reproducci¢n | Cancelada | | 9 | 2025-11-09 | 16:00:00 | 9 | 9 | Tratamiento oncolog¡a | Pendiente | | 10 | 2025-11-10 | 17:00:00 | 10 | 10 | Chequeo pedi trico | Atendida | +---------+------------+----------+------------+----------------+-----------------------+-----------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Procedimientos; +------------------+---------------------------+-----------------------------------+-----------+ | id_procedimiento | nombre | descripcion | costo | +------------------+---------------------------+-----------------------------------+-----------+ | 1 | Limpieza dental | Eliminaci¢n de placa y sarro | 70000.00 | | 2 | Suturas | Cierre de heridas | 50000.00 | | 3 | Radiograf¡a | Examen radiol¢gico | 60000.00 | | 4 | Ecograf¡a | Examen de ultrasonido | 80000.00 | | 5 | Cirug¡a menor | Procedimiento quir£rgico simple | 100000.00 | | 6 | Cirug¡a mayor | Procedimiento complejo | 250000.00 | | 7 | Desparasitaci¢n | Eliminaci¢n de par sitos internos | 40000.00 | | 8 | Vacunaci¢n | Aplicaci¢n de vacunas | 30000.00 | | 9 | Chequeo cardiol¢gico | Revisi¢n del coraz¢n | 90000.00 | | 10 | Tratamiento dermatol¢gico | Cuidado de piel y pelaje | 75000.00 | +------------------+---------------------------+-----------------------------------+-----------+ 10 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT * FROM Diagnosticos; +----------------+---------+-----------------------+-------------------------------+---------------------+ | id_diagnostico | id_cita | descripcion | observaciones | fecha_registro | +----------------+---------+-----------------------+-------------------------------+---------------------+ | 1 | 1 | Gripe leve | Reposo y medicaci¢n | 2025-11-05 14:53:38 | | 2 | 2 | Vacunaci¢n completa | Sin complicaciones | 2025-11-05 14:53:38 | | 3 | 3 | Dermatitis | Evitar al‚rgenos | 2025-11-05 14:53:38 | | 4 | 4 | Problemas dentales | Requiere limpieza profesional | 2025-11-05 14:53:38 | | 5 | 5 | Arritmia leve | Control y seguimiento | 2025-11-05 14:53:38 | | 6 | 6 | Convulsiones leves | Iniciar tratamiento | 2025-11-05 14:53:38 | | 7 | 7 | Conjuntivitis | Tratamiento ocular t¢pico | 2025-11-05 14:53:38 | | 8 | 8 | Revisi¢n reproductiva | Todo normal | 2025-11-05 14:53:38 | | 9 | 9 | C ncer detectado | Programar cirug¡a | 2025-11-05 14:53:38 | | 10 | 10 | Chequeo pedi trico | Sin complicaciones | 2025-11-05 14:53:38 | +----------------+---------+-----------------------+-------------------------------+---------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Tratamientos; +----------------+----------------+-------------------+------------------------+-----------+------------------+ | id_tratamiento | id_diagnostico | medicamento | dosis | duracion | fecha_aplicacion | +----------------+----------------+-------------------+------------------------+-----------+------------------+ | 1 | 1 | Antibi¢tico | 2 tabletas al d¡a | 5 d¡as | 2025-11-05 | | 2 | 2 | Vacuna | 1 dosis | énica | 2025-11-05 | | 3 | 3 | Antif£ngico | Aplicar 2 veces al d¡a | 7 d¡as | 2025-11-05 | | 4 | 4 | Analg‚sico | 1 inyecci¢n | 1 d¡a | 2025-11-05 | | 5 | 5 | Anti-inflamatorio | 2 tabletas al d¡a | 10 d¡as | 2025-11-05 | | 6 | 6 | Anticonvulsivo | 1 tableta al d¡a | 30 d¡as | 2025-11-05 | | 7 | 7 | Antihistam¡nico | 1 tableta al d¡a | 14 d¡as | 2025-11-05 | | 8 | 8 | Vitaminas | 5 ml al d¡a | 15 d¡as | 2025-11-05 | | 9 | 9 | Quimioterapia | 1 dosis semanal | 6 semanas | 2025-11-05 | | 10 | 10 | Suero | Inyecci¢n cada 12h | 3 d¡as | 2025-11-05 | +----------------+----------------+-------------------+------------------------+-----------+------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Medicamentos; +----------------+-------------------+-----------+----------------+-----------------+--------------+ | id_medicamento | nombre | tipo | cantidad_stock | precio_unitario | id_proveedor | +----------------+-------------------+-----------+----------------+-----------------+--------------+ | 1 | Antibi¢tico | Tableta | 100 | 25500.00 | 1 | | 2 | Analg‚sico | Inyecci¢n | 50 | 40000.00 | 2 | | 3 | Vitaminas | Syrup | 200 | 15000.00 | 3 | | 4 | Desparasitante | Tableta | 150 | 30000.00 | 4 | | 5 | Antif£ngico | Pomada | 80 | 20000.00 | 5 | | 6 | Suero | Soluci¢n | 60 | 50000.00 | 6 | | 7 | Antihistam¡nico | Tableta | 90 | 18000.00 | 7 | | 8 | Vacuna | Inyecci¢n | 120 | 60000.00 | 8 | | 9 | Anti-inflamatorio | Tableta | 70 | 35000.00 | 9 | | 10 | Sedante | Inyecci¢n | 40 | 45000.00 | 10 | +----------------+-------------------+-----------+----------------+-----------------+--------------+ 10 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT * FROM Proveedores; +--------------+------------------+------------+-----------+-----------------+ | id_proveedor | nombre | telefono | direccion | correo | +--------------+------------------+------------+-----------+-----------------+ | 1 | Proveedor Uno | 3001111111 | Calle 1 | prov1@mail.com | | 2 | Proveedor Dos | 3002222222 | Calle 2 | prov2@mail.com | | 3 | Proveedor Tres | 3003333333 | Calle 3 | prov3@mail.com | | 4 | Proveedor Cuatro | 3004444444 | Calle 4 | prov4@mail.com | | 5 | Proveedor Cinco | 3005555555 | Calle 5 | prov5@mail.com | | 6 | Proveedor Seis | 3006666666 | Calle 6 | prov6@mail.com | | 7 | Proveedor Siete | 3007777777 | Calle 7 | prov7@mail.com | | 8 | Proveedor Ocho | 3008888888 | Calle 8 | prov8@mail.com | | 9 | Proveedor Nueve | 3009999999 | Calle 9 | prov9@mail.com | | 10 | Proveedor Diez | 3010000000 | Calle 10 | prov10@mail.com | +--------------+------------------+------------+-----------+-----------------+ 10 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT * FROM Hospitalizaciones; +--------------------+------------+---------------+--------------+----------------+--------------------------+ | id_hospitalizacion | id_mascota | fecha_ingreso | fecha_salida | id_veterinario | diagnostico | +--------------------+------------+---------------+--------------+----------------+--------------------------+ | 1 | 1 | 2025-11-01 | 2025-11-03 | 1 | Gripe leve | | 2 | 2 | 2025-11-02 | 2025-11-02 | 2 | Observaci¢n post-vacuna | | 3 | 3 | 2025-11-03 | 2025-11-05 | 3 | Dermatitis severa | | 4 | 4 | 2025-11-04 | 2025-11-06 | 4 | Problemas dentales | | 5 | 5 | 2025-11-05 | 2025-11-07 | 5 | Arritmia | | 6 | 6 | 2025-11-06 | 2025-11-08 | 6 | Convulsiones | | 7 | 7 | 2025-11-07 | 2025-11-09 | 7 | Conjuntivitis complicada | | 8 | 8 | 2025-11-08 | 2025-11-10 | 8 | Revisi¢n reproductiva | | 9 | 9 | 2025-11-09 | 2025-11-11 | 9 | Tratamiento oncol¢gico | | 10 | 10 | 2025-11-10 | 2025-11-12 | 10 | Observaci¢n pedi trica | +--------------------+------------+---------------+--------------+----------------+--------------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Servicios; +-------------+-----------------+-----------------------------+-----------+ | id_servicio | tipo_servicio | descripcion | precio | +-------------+-----------------+-----------------------------+-----------+ | 1 | Consulta | Consulta m‚dica general | 50000.00 | | 2 | Vacunaci¢n | Aplicaci¢n de vacuna | 30000.00 | | 3 | Cirug¡a | Procedimiento quir£rgico | 200000.00 | | 4 | Desparasitaci¢n | Tratamiento antiparasitario | 40000.00 | | 5 | Peluquer¡a | Limpieza y corte de pelo | 25000.00 | | 6 | Radiograf¡a | Examen radiol¢gico | 60000.00 | | 7 | Ecograf¡a | Examen de ultrasonido | 80000.00 | | 8 | Odontolog¡a | Tratamiento dental | 70000.00 | | 9 | Hospitalizaci¢n | Cuidado hospitalario | 150000.00 | | 10 | Emergencia | Atenci¢n de urgencia | 100000.00 | +-------------+-----------------+-----------------------------+-----------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Facturas; +------------+------------+------------+-----------+---------------+ | id_factura | id_cliente | fecha | total | metodo_pago | +------------+------------+------------+-----------+---------------+ | 1 | 1 | 2025-11-01 | 120000.00 | Efectivo | | 2 | 2 | 2025-11-02 | 80000.00 | Tarjeta | | 3 | 3 | 2025-11-03 | 150000.00 | Transferencia | | 4 | 4 | 2025-11-04 | 60000.00 | Efectivo | | 5 | 5 | 2025-11-05 | 40000.00 | Tarjeta | | 6 | 6 | 2025-11-06 | 30000.00 | Efectivo | | 7 | 7 | 2025-11-07 | 90000.00 | Transferencia | | 8 | 8 | 2025-11-08 | 180000.00 | Tarjeta | | 9 | 9 | 2025-11-09 | 55000.00 | Efectivo | | 10 | 10 | 2025-11-10 | 45000.00 | Efectivo | +------------+------------+------------+-----------+---------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM DetalleFactura; +------------+------------+-------------+----------+-----------+ | id_detalle | id_factura | id_servicio | cantidad | subtotal | +------------+------------+-------------+----------+-----------+ | 1 | 1 | 1 | 1 | 50000.00 | | 2 | 1 | 4 | 1 | 70000.00 | | 3 | 2 | 2 | 1 | 30000.00 | | 4 | 3 | 3 | 1 | 150000.00 | | 5 | 4 | 6 | 1 | 60000.00 | | 6 | 5 | 5 | 1 | 35000.00 | | 7 | 6 | 1 | 1 | 30000.00 | | 8 | 7 | 7 | 1 | 90000.00 | | 9 | 8 | 8 | 1 | 180000.00 | | 10 | 9 | 9 | 1 | 55000.00 | +------------+------------+-------------+----------+-----------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Pagos; +---------+------------+-----------+------------+---------------+ | id_pago | id_factura | monto | fecha | tipo_pago | +---------+------------+-----------+------------+---------------+ | 1 | 1 | 120000.00 | 2025-11-01 | Efectivo | | 2 | 2 | 80000.00 | 2025-11-02 | Tarjeta | | 3 | 3 | 150000.00 | 2025-11-03 | Transferencia | | 4 | 4 | 60000.00 | 2025-11-04 | Efectivo | | 5 | 5 | 40000.00 | 2025-11-05 | Tarjeta | | 6 | 6 | 30000.00 | 2025-11-06 | Efectivo | | 7 | 7 | 90000.00 | 2025-11-07 | Transferencia | | 8 | 8 | 180000.00 | 2025-11-08 | Tarjeta | | 9 | 9 | 55000.00 | 2025-11-09 | Efectivo | | 10 | 10 | 45000.00 | 2025-11-10 | Efectivo | +---------+------------+-----------+------------+---------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_reducir_stock_tratamiento -> AFTER INSERT ON Tratamientos -> FOR EACH ROW -> BEGIN -> UPDATE Medicamentos -> SET cantidad_stock = cantidad_stock - 1 -> WHERE nombre = NEW.medicamento -> AND cantidad_stock > 0; -> END$$ Query OK, 0 rows affected (0.007 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_prevenir_stock_negativo -> BEFORE UPDATE ON Medicamentos -> FOR EACH ROW -> BEGIN -> IF NEW.cantidad_stock < 0 THEN -> SIGNAL SQLSTATE '45000' -> SET MESSAGE_TEXT = 'El stock no puede ser negativo'; -> END IF; -> END$$ Query OK, 0 rows affected (0.007 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_marcar_cita_atendida -> AFTER INSERT ON Diagnosticos -> FOR EACH ROW -> BEGIN -> UPDATE Citas -> SET estado = 'Atendida' -> WHERE id_cita = NEW.id_cita; -> END$$ Query OK, 0 rows affected (0.011 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_validar_pago -> BEFORE INSERT ON Pagos -> FOR EACH ROW -> BEGIN -> DECLARE total_fact DECIMAL(12,2); -> -> SELECT total -> INTO total_fact -> FROM Facturas -> WHERE id_factura = NEW.id_factura; -> -> IF total_fact IS NULL THEN -> SIGNAL SQLSTATE '45000' -> SET MESSAGE_TEXT = 'La factura asociada no existe'; -> END IF; -> -> IF NEW.monto > total_fact THEN -> SIGNAL SQLSTATE '45000' -> SET MESSAGE_TEXT = 'El monto del pago no puede exceder el total de la factura'; -> END IF; -> END$$ Query OK, 0 rows affected (0.004 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_calcular_subtotal_detalle -> BEFORE INSERT ON DetalleFactura -> FOR EACH ROW -> BEGIN -> DECLARE precio_serv DECIMAL(12,2); -> -> IF NEW.subtotal IS NULL OR NEW.subtotal = 0 THEN -> SELECT precio INTO precio_serv -> FROM Servicios -> WHERE id_servicio = NEW.id_servicio; -> -> IF precio_serv IS NULL THEN -> SET NEW.subtotal = 0; -> ELSE -> SET NEW.subtotal = precio_serv * NEW.cantidad; -> END IF; -> END IF; -> END$$ Query OK, 0 rows affected (0.004 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_actualizar_total_factura_after_detalle -> AFTER INSERT ON DetalleFactura -> FOR EACH ROW -> BEGIN -> UPDATE Facturas -> SET total = COALESCE(total, 0) + NEW.subtotal -> WHERE id_factura = NEW.id_factura; -> END$$ Query OK, 0 rows affected (0.007 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_auditar_diagnosticos -> AFTER UPDATE ON Diagnosticos -> FOR EACH ROW -> BEGIN -> INSERT INTO AuditoriaCambios (tabla_nombre, id_registro, tipo_accion) -> VALUES ('Diagnosticos', NEW.id_diagnostico, 'UPDATE'); -> END$$ Query OK, 0 rows affected (0.007 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> DELIMITER $$ MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> CREATE TRIGGER trg_evitar_borrar_medicamento_si_stock -> BEFORE DELETE ON Medicamentos -> FOR EACH ROW -> BEGIN -> IF OLD.cantidad_stock > 0 THEN -> SIGNAL SQLSTATE '45000' -> SET MESSAGE_TEXT = 'No se puede eliminar un medicamento con stock disponible'; -> END IF; -> END$$ Query OK, 0 rows affected (0.005 sec) MariaDB [PalacioMascotas]> MariaDB [PalacioMascotas]> DELIMITER ; MariaDB [PalacioMascotas]> CREATE OR REPLACE VIEW Vista_Historial_Mascota AS -> SELECT m.id_mascota, m.nombre AS nombre_mascota, c.fecha AS fecha_cita, d.descripcion AS diagnostico, t.medicamento, t.dosis, t.duracion -> FROM Mascotas m -> LEFT JOIN Citas c ON m.id_mascota = c.id_mascota -> LEFT JOIN Diagnosticos d ON c.id_cita = d.id_cita -> LEFT JOIN Tratamientos t ON d.id_diagnostico = t.id_diagnostico; Query OK, 0 rows affected (0.006 sec) MariaDB [PalacioMascotas]> CREATE OR REPLACE VIEW Vista_Medicamentos_Bajo_Stock AS -> SELECT id_medicamento, nombre, cantidad_stock, precio_unitario FROM Medicamentos WHERE cantidad_stock < 50; Query OK, 0 rows affected (0.003 sec) MariaDB [PalacioMascotas]> SELECT c.id_cita, c.fecha, c.hora, c.motivo, c.estado, -> m.nombre AS mascota, m.especie, v.nombre AS veterinario, v.especialidad -> FROM Citas c -> JOIN Mascotas m ON c.id_mascota = m.id_mascota -> LEFT JOIN Veterinarios v ON c.id_veterinario = v.id_veterinario; +---------+------------+----------+-----------------------+-----------+----------+---------+-------------+------------------+ | id_cita | fecha | hora | motivo | estado | mascota | especie | veterinario | especialidad | +---------+------------+----------+-----------------------+-----------+----------+---------+-------------+------------------+ | 1 | 2025-11-01 | 08:00:00 | Chequeo general | Pendiente | Firulais | Perro | Dr. Juan | Medicina Interna | | 2 | 2025-11-02 | 09:00:00 | Vacuna anual | Atendida | Michi | Gato | Dra. Maria | Cirug¡a | | 3 | 2025-11-03 | 10:00:00 | Problema de piel | Pendiente | Rex | Perro | Dr. Carlos | Dermatolog¡a | | 4 | 2025-11-04 | 11:00:00 | Limpieza dental | Cancelada | Luna | Gato | Dra. Ana | Odontolog¡a | | 5 | 2025-11-05 | 12:00:00 | Chequeo cardiol¢gico | Pendiente | Max | Perro | Dr. Luis | Cardiolog¡a | | 6 | 2025-11-06 | 13:00:00 | Consulta neurol¢gica | Atendida | Nina | Gato | Dra. Sofia | Neurolog¡a | | 7 | 2025-11-07 | 14:00:00 | Problema ocular | Pendiente | Toby | Perro | Dr. Diego | Oftalmolog¡a | | 8 | 2025-11-08 | 15:00:00 | Revisi¢n reproducci¢n | Cancelada | Simba | Gato | Dra. Laura | Reproducci¢n | | 9 | 2025-11-09 | 16:00:00 | Tratamiento oncolog¡a | Pendiente | Rocky | Perro | Dr. Andres | Oncolog¡a | | 10 | 2025-11-10 | 17:00:00 | Chequeo pedi trico | Atendida | Kira | Gato | Dra. Paula | Pediatr¡a | +---------+------------+----------+-----------------------+-----------+----------+---------+-------------+------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT f.id_factura, f.fecha, f.total, f.metodo_pago, -> cl.nombre AS cliente, s.tipo_servicio, df.cantidad, df.subtotal -> FROM Facturas f -> JOIN Clientes cl ON f.id_cliente = cl.id_cliente -> JOIN DetalleFactura df ON f.id_factura = df.id_factura -> LEFT JOIN Servicios s ON df.id_servicio = s.id_servicio; +------------+------------+-----------+---------------+---------------+-----------------+----------+-----------+ | id_factura | fecha | total | metodo_pago | cliente | tipo_servicio | cantidad | subtotal | +------------+------------+-----------+---------------+---------------+-----------------+----------+-----------+ | 1 | 2025-11-01 | 120000.00 | Efectivo | Juan Perez | Consulta | 1 | 50000.00 | | 1 | 2025-11-01 | 120000.00 | Efectivo | Juan Perez | Desparasitaci¢n | 1 | 70000.00 | | 2 | 2025-11-02 | 80000.00 | Tarjeta | Maria Lopez | Vacunaci¢n | 1 | 30000.00 | | 3 | 2025-11-03 | 150000.00 | Transferencia | Carlos Ruiz | Cirug¡a | 1 | 150000.00 | | 4 | 2025-11-04 | 60000.00 | Efectivo | Ana Gomez | Radiograf¡a | 1 | 60000.00 | | 5 | 2025-11-05 | 40000.00 | Tarjeta | Luis Martinez | Peluquer¡a | 1 | 35000.00 | | 6 | 2025-11-06 | 30000.00 | Efectivo | Sofia Herrera | Consulta | 1 | 30000.00 | | 7 | 2025-11-07 | 90000.00 | Transferencia | Diego Torres | Ecograf¡a | 1 | 90000.00 | | 8 | 2025-11-08 | 180000.00 | Tarjeta | Laura Rios | Odontolog¡a | 1 | 180000.00 | | 9 | 2025-11-09 | 55000.00 | Efectivo | Andres Molina | Hospitalizaci¢n | 1 | 55000.00 | +------------+------------+-----------+---------------+---------------+-----------------+----------+-----------+ 10 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT * FROM Vista_Historial_Mascota WHERE id_mascota = 1; +------------+----------------+------------+-------------+-------------+-------------------+----------+ | id_mascota | nombre_mascota | fecha_cita | diagnostico | medicamento | dosis | duracion | +------------+----------------+------------+-------------+-------------+-------------------+----------+ | 1 | Firulais | 2025-11-01 | Gripe leve | Antibi¢tico | 2 tabletas al d¡a | 5 d¡as | +------------+----------------+------------+-------------+-------------+-------------------+----------+ 1 row in set (0.002 sec) MariaDB [PalacioMascotas]> SELECT med.nombre AS medicamento, med.tipo, med.cantidad_stock, med.precio_unitario, p.nombre AS proveedor -> FROM Medicamentos med -> LEFT JOIN Proveedores p ON med.id_proveedor = p.id_proveedor -> WHERE med.cantidad_stock < 50; +-------------+-----------+----------------+-----------------+----------------+ | medicamento | tipo | cantidad_stock | precio_unitario | proveedor | +-------------+-----------+----------------+-----------------+----------------+ | Sedante | Inyecci¢n | 40 | 45000.00 | Proveedor Diez | +-------------+-----------+----------------+-----------------+----------------+ 1 row in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT cl.nombre AS cliente, SUM(f.total) AS total_facturado_cop -> FROM Clientes cl -> JOIN Facturas f ON cl.id_cliente = f.id_cliente -> GROUP BY cl.id_cliente -> ORDER BY total_facturado_cop DESC; +---------------+---------------------+ | cliente | total_facturado_cop | +---------------+---------------------+ | Laura Rios | 180000.00 | | Carlos Ruiz | 150000.00 | | Juan Perez | 120000.00 | | Diego Torres | 90000.00 | | Maria Lopez | 80000.00 | | Ana Gomez | 60000.00 | | Andres Molina | 55000.00 | | Paula Castro | 45000.00 | | Luis Martinez | 40000.00 | | Sofia Herrera | 30000.00 | +---------------+---------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT v.nombre AS veterinario, COUNT(*) AS citas_pendientes -> FROM Veterinarios v -> LEFT JOIN Citas c ON v.id_veterinario = c.id_veterinario -> WHERE c.estado = 'Pendiente' -> GROUP BY v.id_veterinario; +-------------+------------------+ | veterinario | citas_pendientes | +-------------+------------------+ | Dr. Juan | 1 | | Dr. Carlos | 1 | | Dr. Luis | 1 | | Dr. Diego | 1 | | Dr. Andres | 1 | +-------------+------------------+ 5 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT s.tipo_servicio, COUNT(df.id_detalle) AS veces -> FROM Servicios s -> JOIN DetalleFactura df ON s.id_servicio = df.id_servicio -> GROUP BY s.id_servicio -> ORDER BY veces DESC -> LIMIT 5; +-----------------+-------+ | tipo_servicio | veces | +-----------------+-------+ | Consulta | 2 | | Vacunaci¢n | 1 | | Cirug¡a | 1 | | Desparasitaci¢n | 1 | | Peluquer¡a | 1 | +-----------------+-------+ 5 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT t.medicamento, COUNT(*) AS veces_recetado -> FROM Tratamientos t -> GROUP BY t.medicamento -> ORDER BY veces_recetado DESC -> LIMIT 5; +----------------+----------------+ | medicamento | veces_recetado | +----------------+----------------+ | Suero | 1 | | Antif£ngico | 1 | | Vitaminas | 1 | | Antibi¢tico | 1 | | Anticonvulsivo | 1 | +----------------+----------------+ 5 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT s.tipo_servicio, AVG(s.precio) AS precio_promedio, COUNT(df.id_detalle) AS veces_vendido -> FROM Servicios s -> LEFT JOIN DetalleFactura df ON s.id_servicio = df.id_servicio -> GROUP BY s.id_servicio; +-----------------+-----------------+---------------+ | tipo_servicio | precio_promedio | veces_vendido | +-----------------+-----------------+---------------+ | Consulta | 50000.000000 | 2 | | Vacunaci¢n | 30000.000000 | 1 | | Cirug¡a | 200000.000000 | 1 | | Desparasitaci¢n | 40000.000000 | 1 | | Peluquer¡a | 25000.000000 | 1 | | Radiograf¡a | 60000.000000 | 1 | | Ecograf¡a | 80000.000000 | 1 | | Odontolog¡a | 70000.000000 | 1 | | Hospitalizaci¢n | 150000.000000 | 1 | | Emergencia | 100000.000000 | 0 | +-----------------+-----------------+---------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT DATE_FORMAT(f.fecha, '%Y-%m') AS mes, SUM(f.total) AS ingresos_cop -> FROM Facturas f -> GROUP BY mes -> ORDER BY mes DESC; +---------+--------------+ | mes | ingresos_cop | +---------+--------------+ | 2025-11 | 850000.00 | +---------+--------------+ 1 row in set (0.000 sec) MariaDB [PalacioMascotas]> SHOW TABLES; +-------------------------------+ | Tables_in_palaciomascotas | +-------------------------------+ | auditoriacambios | | citas | | clientes | | detallefactura | | diagnosticos | | especialidades | | facturas | | hospitalizaciones | | mascotas | | medicamentos | | pagos | | procedimientos | | proveedores | | servicios | | tratamientos | | veterinarios | | vista_historial_mascota | | vista_medicamentos_bajo_stock | +-------------------------------+ 18 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Clientes LIMIT 10; +------------+---------------+----------------+------------+------------------------+ | id_cliente | nombre | direccion | telefono | correo | +------------+---------------+----------------+------------+------------------------+ | 1 | Juan Perez | Calle 1 #10-20 | 3001234567 | juan.perez@mail.com | | 2 | Maria Lopez | Cra 5 #12-34 | 3002345678 | maria.lopez@mail.com | | 3 | Carlos Ruiz | Av 7 #23-45 | 3003456789 | carlos.ruiz@mail.com | | 4 | Ana Gomez | Calle 3 #3-21 | 3004567890 | ana.gomez@mail.com | | 5 | Luis Martinez | Cra 10 #20-10 | 3005678901 | luis.martinez@mail.com | | 6 | Sofia Herrera | Av 11 #9-18 | 3006789012 | sofia.h@mail.com | | 7 | Diego Torres | Calle 8 #4-12 | 3007890123 | diego.t@mail.com | | 8 | Laura Rios | Cra 2 #1-05 | 3008901234 | laura.rios@mail.com | | 9 | Andres Molina | Av 4 #14-16 | 3009012345 | andres.m@mail.com | | 10 | Paula Castro | Calle 9 #7-02 | 3000123456 | paula.c@mail.com | +------------+---------------+----------------+------------+------------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Mascotas LIMIT 10; +------------+----------+---------+---------------+------+-------+------------+ | id_mascota | nombre | especie | raza | edad | peso | id_cliente | +------------+----------+---------+---------------+------+-------+------------+ | 1 | Firulais | Perro | Labrador | 3 | 16.50 | 1 | | 2 | Michi | Gato | Siames | 2 | 4.20 | 2 | | 3 | Rex | Perro | Pastor Alem n | 5 | 30.00 | 3 | | 4 | Luna | Gato | Persa | 4 | 5.10 | 4 | | 5 | Max | Perro | Beagle | 1 | 10.50 | 5 | | 6 | Nina | Gato | Maine Coon | 3 | 6.80 | 6 | | 7 | Toby | Perro | Bulldog | 2 | 20.00 | 7 | | 8 | Simba | Gato | Bengala | 1 | 4.30 | 8 | | 9 | Rocky | Perro | Boxer | 6 | 28.00 | 9 | | 10 | Kira | Gato | Esfinge | 2 | 3.50 | 10 | +------------+----------+---------+---------------+------+-------+------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Veterinarios LIMIT 10; +----------------+------------+--------+------------------+------------------+ | id_veterinario | nombre | cedula | especialidad | anos_experiencia | +----------------+------------+--------+------------------+------------------+ | 1 | Dr. Juan | 1001 | Medicina Interna | 10 | | 2 | Dra. Maria | 1002 | Cirug¡a | 8 | | 3 | Dr. Carlos | 1003 | Dermatolog¡a | 12 | | 4 | Dra. Ana | 1004 | Odontolog¡a | 7 | | 5 | Dr. Luis | 1005 | Cardiolog¡a | 15 | | 6 | Dra. Sofia | 1006 | Neurolog¡a | 6 | | 7 | Dr. Diego | 1007 | Oftalmolog¡a | 9 | | 8 | Dra. Laura | 1008 | Reproducci¢n | 11 | | 9 | Dr. Andres | 1009 | Oncolog¡a | 14 | | 10 | Dra. Paula | 1010 | Pediatr¡a | 5 | +----------------+------------+--------+------------------+------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Especialidades LIMIT 10; +-----------------+---------------------+ | id_especialidad | nombre_especialidad | +-----------------+---------------------+ | 5 | Cardiolog¡a | | 2 | Cirug¡a | | 3 | Dermatolog¡a | | 1 | Medicina Interna | | 6 | Neurolog¡a | | 4 | Odontolog¡a | | 7 | Oftalmolog¡a | | 9 | Oncolog¡a | | 10 | Pediatr¡a | | 8 | Reproducci¢n | +-----------------+---------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Proveedores LIMIT 10; +--------------+------------------+------------+-----------+-----------------+ | id_proveedor | nombre | telefono | direccion | correo | +--------------+------------------+------------+-----------+-----------------+ | 1 | Proveedor Uno | 3001111111 | Calle 1 | prov1@mail.com | | 2 | Proveedor Dos | 3002222222 | Calle 2 | prov2@mail.com | | 3 | Proveedor Tres | 3003333333 | Calle 3 | prov3@mail.com | | 4 | Proveedor Cuatro | 3004444444 | Calle 4 | prov4@mail.com | | 5 | Proveedor Cinco | 3005555555 | Calle 5 | prov5@mail.com | | 6 | Proveedor Seis | 3006666666 | Calle 6 | prov6@mail.com | | 7 | Proveedor Siete | 3007777777 | Calle 7 | prov7@mail.com | | 8 | Proveedor Ocho | 3008888888 | Calle 8 | prov8@mail.com | | 9 | Proveedor Nueve | 3009999999 | Calle 9 | prov9@mail.com | | 10 | Proveedor Diez | 3010000000 | Calle 10 | prov10@mail.com | +--------------+------------------+------------+-----------+-----------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Medicamentos LIMIT 10; +----------------+-------------------+-----------+----------------+-----------------+--------------+ | id_medicamento | nombre | tipo | cantidad_stock | precio_unitario | id_proveedor | +----------------+-------------------+-----------+----------------+-----------------+--------------+ | 1 | Antibi¢tico | Tableta | 100 | 25500.00 | 1 | | 2 | Analg‚sico | Inyecci¢n | 50 | 40000.00 | 2 | | 3 | Vitaminas | Syrup | 200 | 15000.00 | 3 | | 4 | Desparasitante | Tableta | 150 | 30000.00 | 4 | | 5 | Antif£ngico | Pomada | 80 | 20000.00 | 5 | | 6 | Suero | Soluci¢n | 60 | 50000.00 | 6 | | 7 | Antihistam¡nico | Tableta | 90 | 18000.00 | 7 | | 8 | Vacuna | Inyecci¢n | 120 | 60000.00 | 8 | | 9 | Anti-inflamatorio | Tableta | 70 | 35000.00 | 9 | | 10 | Sedante | Inyecci¢n | 40 | 45000.00 | 10 | +----------------+-------------------+-----------+----------------+-----------------+--------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Servicios LIMIT 10; +-------------+-----------------+-----------------------------+-----------+ | id_servicio | tipo_servicio | descripcion | precio | +-------------+-----------------+-----------------------------+-----------+ | 1 | Consulta | Consulta m‚dica general | 50000.00 | | 2 | Vacunaci¢n | Aplicaci¢n de vacuna | 30000.00 | | 3 | Cirug¡a | Procedimiento quir£rgico | 200000.00 | | 4 | Desparasitaci¢n | Tratamiento antiparasitario | 40000.00 | | 5 | Peluquer¡a | Limpieza y corte de pelo | 25000.00 | | 6 | Radiograf¡a | Examen radiol¢gico | 60000.00 | | 7 | Ecograf¡a | Examen de ultrasonido | 80000.00 | | 8 | Odontolog¡a | Tratamiento dental | 70000.00 | | 9 | Hospitalizaci¢n | Cuidado hospitalario | 150000.00 | | 10 | Emergencia | Atenci¢n de urgencia | 100000.00 | +-------------+-----------------+-----------------------------+-----------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Procedimientos LIMIT 10; +------------------+---------------------------+-----------------------------------+-----------+ | id_procedimiento | nombre | descripcion | costo | +------------------+---------------------------+-----------------------------------+-----------+ | 1 | Limpieza dental | Eliminaci¢n de placa y sarro | 70000.00 | | 2 | Suturas | Cierre de heridas | 50000.00 | | 3 | Radiograf¡a | Examen radiol¢gico | 60000.00 | | 4 | Ecograf¡a | Examen de ultrasonido | 80000.00 | | 5 | Cirug¡a menor | Procedimiento quir£rgico simple | 100000.00 | | 6 | Cirug¡a mayor | Procedimiento complejo | 250000.00 | | 7 | Desparasitaci¢n | Eliminaci¢n de par sitos internos | 40000.00 | | 8 | Vacunaci¢n | Aplicaci¢n de vacunas | 30000.00 | | 9 | Chequeo cardiol¢gico | Revisi¢n del coraz¢n | 90000.00 | | 10 | Tratamiento dermatol¢gico | Cuidado de piel y pelaje | 75000.00 | +------------------+---------------------------+-----------------------------------+-----------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Citas LIMIT 10; +---------+------------+----------+------------+----------------+-----------------------+-----------+ | id_cita | fecha | hora | id_mascota | id_veterinario | motivo | estado | +---------+------------+----------+------------+----------------+-----------------------+-----------+ | 1 | 2025-11-01 | 08:00:00 | 1 | 1 | Chequeo general | Pendiente | | 2 | 2025-11-02 | 09:00:00 | 2 | 2 | Vacuna anual | Atendida | | 3 | 2025-11-03 | 10:00:00 | 3 | 3 | Problema de piel | Pendiente | | 4 | 2025-11-04 | 11:00:00 | 4 | 4 | Limpieza dental | Cancelada | | 5 | 2025-11-05 | 12:00:00 | 5 | 5 | Chequeo cardiol¢gico | Pendiente | | 6 | 2025-11-06 | 13:00:00 | 6 | 6 | Consulta neurol¢gica | Atendida | | 7 | 2025-11-07 | 14:00:00 | 7 | 7 | Problema ocular | Pendiente | | 8 | 2025-11-08 | 15:00:00 | 8 | 8 | Revisi¢n reproducci¢n | Cancelada | | 9 | 2025-11-09 | 16:00:00 | 9 | 9 | Tratamiento oncolog¡a | Pendiente | | 10 | 2025-11-10 | 17:00:00 | 10 | 10 | Chequeo pedi trico | Atendida | +---------+------------+----------+------------+----------------+-----------------------+-----------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Diagnosticos LIMIT 10; +----------------+---------+-----------------------+-------------------------------+---------------------+ | id_diagnostico | id_cita | descripcion | observaciones | fecha_registro | +----------------+---------+-----------------------+-------------------------------+---------------------+ | 1 | 1 | Gripe leve | Reposo y medicaci¢n | 2025-11-05 14:53:38 | | 2 | 2 | Vacunaci¢n completa | Sin complicaciones | 2025-11-05 14:53:38 | | 3 | 3 | Dermatitis | Evitar al‚rgenos | 2025-11-05 14:53:38 | | 4 | 4 | Problemas dentales | Requiere limpieza profesional | 2025-11-05 14:53:38 | | 5 | 5 | Arritmia leve | Control y seguimiento | 2025-11-05 14:53:38 | | 6 | 6 | Convulsiones leves | Iniciar tratamiento | 2025-11-05 14:53:38 | | 7 | 7 | Conjuntivitis | Tratamiento ocular t¢pico | 2025-11-05 14:53:38 | | 8 | 8 | Revisi¢n reproductiva | Todo normal | 2025-11-05 14:53:38 | | 9 | 9 | C ncer detectado | Programar cirug¡a | 2025-11-05 14:53:38 | | 10 | 10 | Chequeo pedi trico | Sin complicaciones | 2025-11-05 14:53:38 | +----------------+---------+-----------------------+-------------------------------+---------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Tratamientos LIMIT 10; +----------------+----------------+-------------------+------------------------+-----------+------------------+ | id_tratamiento | id_diagnostico | medicamento | dosis | duracion | fecha_aplicacion | +----------------+----------------+-------------------+------------------------+-----------+------------------+ | 1 | 1 | Antibi¢tico | 2 tabletas al d¡a | 5 d¡as | 2025-11-05 | | 2 | 2 | Vacuna | 1 dosis | énica | 2025-11-05 | | 3 | 3 | Antif£ngico | Aplicar 2 veces al d¡a | 7 d¡as | 2025-11-05 | | 4 | 4 | Analg‚sico | 1 inyecci¢n | 1 d¡a | 2025-11-05 | | 5 | 5 | Anti-inflamatorio | 2 tabletas al d¡a | 10 d¡as | 2025-11-05 | | 6 | 6 | Anticonvulsivo | 1 tableta al d¡a | 30 d¡as | 2025-11-05 | | 7 | 7 | Antihistam¡nico | 1 tableta al d¡a | 14 d¡as | 2025-11-05 | | 8 | 8 | Vitaminas | 5 ml al d¡a | 15 d¡as | 2025-11-05 | | 9 | 9 | Quimioterapia | 1 dosis semanal | 6 semanas | 2025-11-05 | | 10 | 10 | Suero | Inyecci¢n cada 12h | 3 d¡as | 2025-11-05 | +----------------+----------------+-------------------+------------------------+-----------+------------------+ 10 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT * FROM Hospitalizaciones LIMIT 10; +--------------------+------------+---------------+--------------+----------------+--------------------------+ | id_hospitalizacion | id_mascota | fecha_ingreso | fecha_salida | id_veterinario | diagnostico | +--------------------+------------+---------------+--------------+----------------+--------------------------+ | 1 | 1 | 2025-11-01 | 2025-11-03 | 1 | Gripe leve | | 2 | 2 | 2025-11-02 | 2025-11-02 | 2 | Observaci¢n post-vacuna | | 3 | 3 | 2025-11-03 | 2025-11-05 | 3 | Dermatitis severa | | 4 | 4 | 2025-11-04 | 2025-11-06 | 4 | Problemas dentales | | 5 | 5 | 2025-11-05 | 2025-11-07 | 5 | Arritmia | | 6 | 6 | 2025-11-06 | 2025-11-08 | 6 | Convulsiones | | 7 | 7 | 2025-11-07 | 2025-11-09 | 7 | Conjuntivitis complicada | | 8 | 8 | 2025-11-08 | 2025-11-10 | 8 | Revisi¢n reproductiva | | 9 | 9 | 2025-11-09 | 2025-11-11 | 9 | Tratamiento oncol¢gico | | 10 | 10 | 2025-11-10 | 2025-11-12 | 10 | Observaci¢n pedi trica | +--------------------+------------+---------------+--------------+----------------+--------------------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Facturas LIMIT 10; +------------+------------+------------+-----------+---------------+ | id_factura | id_cliente | fecha | total | metodo_pago | +------------+------------+------------+-----------+---------------+ | 1 | 1 | 2025-11-01 | 120000.00 | Efectivo | | 2 | 2 | 2025-11-02 | 80000.00 | Tarjeta | | 3 | 3 | 2025-11-03 | 150000.00 | Transferencia | | 4 | 4 | 2025-11-04 | 60000.00 | Efectivo | | 5 | 5 | 2025-11-05 | 40000.00 | Tarjeta | | 6 | 6 | 2025-11-06 | 30000.00 | Efectivo | | 7 | 7 | 2025-11-07 | 90000.00 | Transferencia | | 8 | 8 | 2025-11-08 | 180000.00 | Tarjeta | | 9 | 9 | 2025-11-09 | 55000.00 | Efectivo | | 10 | 10 | 2025-11-10 | 45000.00 | Efectivo | +------------+------------+------------+-----------+---------------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM DetalleFactura LIMIT 10; +------------+------------+-------------+----------+-----------+ | id_detalle | id_factura | id_servicio | cantidad | subtotal | +------------+------------+-------------+----------+-----------+ | 1 | 1 | 1 | 1 | 50000.00 | | 2 | 1 | 4 | 1 | 70000.00 | | 3 | 2 | 2 | 1 | 30000.00 | | 4 | 3 | 3 | 1 | 150000.00 | | 5 | 4 | 6 | 1 | 60000.00 | | 6 | 5 | 5 | 1 | 35000.00 | | 7 | 6 | 1 | 1 | 30000.00 | | 8 | 7 | 7 | 1 | 90000.00 | | 9 | 8 | 8 | 1 | 180000.00 | | 10 | 9 | 9 | 1 | 55000.00 | +------------+------------+-------------+----------+-----------+ 10 rows in set (0.000 sec) MariaDB [PalacioMascotas]> SELECT * FROM Pagos LIMIT 10; +---------+------------+-----------+------------+---------------+ | id_pago | id_factura | monto | fecha | tipo_pago | +---------+------------+-----------+------------+---------------+ | 1 | 1 | 120000.00 | 2025-11-01 | Efectivo | | 2 | 2 | 80000.00 | 2025-11-02 | Tarjeta | | 3 | 3 | 150000.00 | 2025-11-03 | Transferencia | | 4 | 4 | 60000.00 | 2025-11-04 | Efectivo | | 5 | 5 | 40000.00 | 2025-11-05 | Tarjeta | | 6 | 6 | 30000.00 | 2025-11-06 | Efectivo | | 7 | 7 | 90000.00 | 2025-11-07 | Transferencia | | 8 | 8 | 180000.00 | 2025-11-08 | Tarjeta | | 9 | 9 | 55000.00 | 2025-11-09 | Efectivo | | 10 | 10 | 45000.00 | 2025-11-10 | Efectivo | +---------+------------+-----------+------------+---------------+ 10 rows in set (0.001 sec) MariaDB [PalacioMascotas]> SELECT * FROM AuditoriaCambios LIMIT 10;NOTEE; Empty set (0.001 sec)