MariaDB [hospital_el_milagroso]> alter table hospital modify telefono bigint; Query OK, 0 rows affected (0.105 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [hospital_el_milagroso]> describe hospital; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | id_hospital | int(11) | NO | PRI | NULL | | | nombre | varchar(30) | NO | | NULL | | | Direccion | varchar(30) | NO | | NULL | | | telefono | bigint(20) | YES | | NULL | | | tipo | varchar(30) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.038 sec) MariaDB [hospital_el_milagroso]> drop procedure insertar_medico; Query OK, 0 rows affected (0.060 sec) MariaDB [hospital_el_milagroso]> drop procedure insertar_hospital; Query OK, 0 rows affected (0.080 sec) MariaDB [hospital_el_milagroso]> Delimiter // MariaDB [hospital_el_milagroso]> create procedure insertar_medico( -> in id_medico int, -> in nombre varchar(30), -> in especialidad varchar(30), -> in correo varchar(30), -> in telefono bigint) -> begin -> insert into medico values(id_medico, nombre, especialidad, correo, telefono); -> end -> // Query OK, 0 rows affected (0.079 sec) MariaDB [hospital_el_milagroso]> create procedure insertar_hospital( -> in id_hospital int, -> in nombre varchar(30), -> in direccion varchar(30), -> in telefono bigint, -> in tipo varchar(30)) -> begin -> insert into hospital values(id_hospital, nombre, direccion, telefono, tipo); -> end -> // Query OK, 0 rows affected (0.045 sec) MariaDB [hospital_el_milagroso]> delimiter ; MariaDB [hospital_el_milagroso]> Call insertar_medico(1, 'Juan P‚rez', 'Cardiolog¡a', 'juan.perez@hospital.com', 3105467234); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> select * from medico; +-----------+------------+--------------+-------------------------+------------+ | id_medico | nombre | especialidad | correo | telefono | +-----------+------------+--------------+-------------------------+------------+ | 1 | Juan P‚rez | Cardiolog¡a | juan.perez@hospital.com | 3105467234 | +-----------+------------+--------------+-------------------------+------------+ 1 row in set (0.000 sec) MariaDB [hospital_el_milagroso]> Call insertar_medico(2, 'Ana G¢mez', 'Traumatolog­a', 'ana.gomez@hospital.com', 3126549876); Query OK, 1 row affected (0.041 sec) MariaDB [hospital_el_milagroso]> Call insertar_medico(3, 'Carlos D¡az', 'Neurolog¡a', 'carlos.diaz@hospital.com', 3142323345); Query OK, 1 row affected (0.068 sec) MariaDB [hospital_el_milagroso]> Call insertar_medico(4, 'Luisa S nchez', 'Pediatr¡a', 'luisa.sanchez@hospital.com', 3156542234); Query OK, 1 row affected (0.059 sec) MariaDB [hospital_el_milagroso]> Call insertar_medico(5, 'Pedro Mart¡nez', 'Cirug¡a General', 'pedro.martinez@hospital.com', 3167876543); Query OK, 1 row affected (0.051 sec) MariaDB [hospital_el_milagroso]> CALL insertar_medico(6, 'Mar¡a L¢pez', 'Dermatolog¡a', 'maria.lopez@hospital.com', 3173456789); Query OK, 1 row affected (0.045 sec) MariaDB [hospital_el_milagroso]> CALL insertar_medico(7, 'Jos‚ Rodr¡guez', 'Ginecolog¡a', 'jose.rodriguez@hospital.com', 3189876543); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> Call insertar_medico(8, 'Laura Fern ndez', 'Oncolog¡a', 'laura.fernandez@hospital.com', 3192345678); Query OK, 1 row affected (0.054 sec) MariaDB [hospital_el_milagroso]> Call insertar_medico(9, 'Ricardo Torres', 'Oftalmolog¡a', 'ricardo.torres@hospital.com', 3201234567); Query OK, 1 row affected (0.006 sec) MariaDB [hospital_el_milagroso]> Call insertar_medico(10, 'Sof¡a Morales', 'Psiquiatr¡a', 'sofia.morales@hospital.com', 3217654321); Query OK, 1 row affected (0.051 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('medico'); +-----------+-----------------+-----------------+------------------------------+------------+ | id_medico | nombre | especialidad | correo | telefono | +-----------+-----------------+-----------------+------------------------------+------------+ | 1 | Juan P‚rez | Cardiolog¡a | juan.perez@hospital.com | 3105467234 | | 2 | Ana G¢mez | Traumatolog­a | ana.gomez@hospital.com | 3126549876 | | 3 | Carlos D¡az | Neurolog¡a | carlos.diaz@hospital.com | 3142323345 | | 4 | Luisa S nchez | Pediatr¡a | luisa.sanchez@hospital.com | 3156542234 | | 5 | Pedro Mart¡nez | Cirug¡a General | pedro.martinez@hospital.com | 3167876543 | | 6 | Mar¡a L¢pez | Dermatolog¡a | maria.lopez@hospital.com | 3173456789 | | 7 | Jos‚ Rodr¡guez | Ginecolog¡a | jose.rodriguez@hospital.com | 3189876543 | | 8 | Laura Fern ndez | Oncolog¡a | laura.fernandez@hospital.com | 3192345678 | | 9 | Ricardo Torres | Oftalmolog¡a | ricardo.torres@hospital.com | 3201234567 | | 10 | Sof¡a Morales | Psiquiatr¡a | sofia.morales@hospital.com | 3217654321 | +-----------+-----------------+-----------------+------------------------------+------------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.029 sec) MariaDB [hospital_el_milagroso]> Call insertar_paciente(1, 'Juan', 'P‚rez', '1999-05-15', 'Masculino'); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> Call insertar_paciente(2, 'Ana', 'G¢mez', '1985-09-20', 'Femenino'); Query OK, 1 row affected (0.040 sec) MariaDB [hospital_el_milagroso]> Call insertar_paciente(3, 'Carlos', 'D¡az', '2000-03-12', 'Masculino'); Query OK, 1 row affected (0.050 sec) MariaDB [hospital_el_milagroso]> Call insertar_paciente(4, 'Luisa', 'S nchez', '1992-06-10', 'Femenino'); Query OK, 1 row affected (0.006 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente(5, 'Pedro', 'Mart¡nez', '1980-11-30', 'Masculino'); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente(6, 'Mar¡a', 'L¢pez', '1995-12-05', 'Femenino'); Query OK, 1 row affected (0.028 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente(7, 'Jos‚', 'Rodr¡guez', '1997-01-18', 'Masculino'); Query OK, 1 row affected (0.042 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente(8, 'Laura', 'Fern ndez', '1988-07-22', 'Femenino'); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente(9, 'Ricardo', 'Torres', '1983-02-25', 'Masculino'); Query OK, 1 row affected (0.066 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente(10, 'Sof¡a', 'Morales', '1997-10-30', 'Femenino'); Query OK, 1 row affected (0.003 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('paciente'); +-------------+---------+-----------+------------------+-----------+ | id_paciente | nombre | apellido | fecha_nacimiento | sexo | +-------------+---------+-----------+------------------+-----------+ | 1 | Juan | P‚rez | 1999-05-15 | Masculino | | 2 | Ana | G¢mez | 1985-09-20 | Femenino | | 3 | Carlos | D¡az | 2000-03-12 | Masculino | | 4 | Luisa | S nchez | 1992-06-10 | Femenino | | 5 | Pedro | Mart¡nez | 1980-11-30 | Masculino | | 6 | Mar¡a | L¢pez | 1995-12-05 | Femenino | | 7 | Jos‚ | Rodr¡guez | 1997-01-18 | Masculino | | 8 | Laura | Fern ndez | 1988-07-22 | Femenino | | 9 | Ricardo | Torres | 1983-02-25 | Masculino | | 10 | Sof¡a | Morales | 1997-10-30 | Femenino | +-------------+---------+-----------+------------------+-----------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.017 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(1, 'Hospital General de Medell¡n', 'Carrera 51 # 68-60', 3123456789, 'P£blico'); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(2, 'Cl¡nica del Prado', 'Calle 46 # 56-10', 3102345678, 'Privado'); Query OK, 1 row affected (0.035 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(3, 'Cl¡nica Universidad de La Sabana', 'Avenida Las Vegas # 16-27', 3145678901, 'Privado'); Query OK, 1 row affected, 1 warning (0.034 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(4, 'Hospital de la Mujer', 'Calle 68 # 35-29', 3118765432, 'P£blico'); Query OK, 1 row affected (0.025 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(5, 'Cl¡nica del Country', 'Carrera 78 # 40-92', 3109988776, 'Privado'); Query OK, 1 row affected (0.037 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(6, 'Hospital Pablo Tob¢n Uribe', 'Carrera 49 # 52-31', 3171234567, 'P£blico'); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(7, 'Cl¡nica del Occidente', 'Avenida 80 # 42-85', 3153456789, 'Privado'); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(8, 'Hospital San Vicente Fundaci¢n', 'Carrera 52 # 79-23', 3008765432, 'P£blico'); Query OK, 1 row affected (0.003 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(9, 'Cl¡nica de la 80', 'Calle 80 # 50-10', 3132345678, 'Privado'); Query OK, 1 row affected (0.049 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital(10, 'Cl¡nica del Parque', 'Calle 55 # 36-50', 3206543210, 'Privado'); Query OK, 1 row affected (0.006 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('hospital'); +-------------+--------------------------------+---------------------------+------------+---------+ | id_hospital | nombre | Direccion | telefono | tipo | +-------------+--------------------------------+---------------------------+------------+---------+ | 1 | Hospital General de Medell¡n | Carrera 51 # 68-60 | 3123456789 | P£blico | | 2 | Cl¡nica del Prado | Calle 46 # 56-10 | 3102345678 | Privado | | 3 | Cl¡nica Universidad de La Saba | Avenida Las Vegas # 16-27 | 3145678901 | Privado | | 4 | Hospital de la Mujer | Calle 68 # 35-29 | 3118765432 | P£blico | | 5 | Cl¡nica del Country | Carrera 78 # 40-92 | 3109988776 | Privado | | 6 | Hospital Pablo Tob¢n Uribe | Carrera 49 # 52-31 | 3171234567 | P£blico | | 7 | Cl¡nica del Occidente | Avenida 80 # 42-85 | 3153456789 | Privado | | 8 | Hospital San Vicente Fundaci¢n | Carrera 52 # 79-23 | 3008765432 | P£blico | | 9 | Cl¡nica de la 80 | Calle 80 # 50-10 | 3132345678 | Privado | | 10 | Cl¡nica del Parque | Calle 55 # 36-50 | 3206543210 | Privado | +-------------+--------------------------------+---------------------------+------------+---------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.047 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(1, 'Estable', CURDATE()); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(2, 'Cr¡tico', CURDATE()); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(3, 'Grave', curdate()); Query OK, 1 row affected (0.003 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(4, 'Leve', curdate()); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(5, 'Recuperaci¢n', curdate()); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(6, 'Convaleciente', curdate()); Query OK, 1 row affected (0.045 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(7, 'Mejorando', curdate()); Query OK, 1 row affected (0.050 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(8, 'Desmejorado', curdate()); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(9, 'En Observaci¢n', curdate()); Query OK, 1 row affected (0.006 sec) MariaDB [hospital_el_milagroso]> call insertar_estado_salud(10, 'Alta m‚dica', curdate()); Query OK, 1 row affected (0.003 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('estado_salud'); +-----------------+--------------------------+----------------+ | id_estado_salud | descripcion_estado_salud | fecha_registro | +-----------------+--------------------------+----------------+ | 1 | Estable | 2025-02-27 | | 2 | Cr¡tico | 2025-02-27 | | 3 | Grave | 2025-02-27 | | 4 | Leve | 2025-02-27 | | 5 | Recuperaci¢n | 2025-02-27 | | 6 | Convaleciente | 2025-02-27 | | 7 | Mejorando | 2025-02-27 | | 8 | Desmejorado | 2025-02-27 | | 9 | En Observaci¢n | 2025-02-27 | | 10 | Alta m‚dica | 2025-02-27 | +-----------------+--------------------------+----------------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.018 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(1, 'Planta de Traumatolog¡a', 50); Query OK, 1 row affected (0.009 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(2, 'Planta de Cuidados Intensivos', 30); Query OK, 1 row affected (0.046 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(3, 'Planta de Pediatr¡a', 40); Query OK, 1 row affected (0.006 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(4, 'Planta de Cirug¡a General', 60); Query OK, 1 row affected (0.036 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(5, 'Planta de Oncolog¡a', 35); Query OK, 1 row affected (0.052 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(6, 'Planta de Ginecolog¡a', 45); Query OK, 1 row affected (0.003 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(7, 'Planta de Cardiolog¡a', 50); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(8, 'Planta de Neurolog¡a', 25); Query OK, 1 row affected (0.040 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(9, 'Planta de Psiquiatr¡a', 20); Query OK, 1 row affected (0.003 sec) MariaDB [hospital_el_milagroso]> call insertar_planta(10, 'Planta de Dermatolog¡a', 40); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('planta'); +-----------+-------------------------------+-----------+ | id_planta | nombre | capacidad | +-----------+-------------------------------+-----------+ | 1 | Planta de Traumatolog¡a | 50 | | 2 | Planta de Cuidados Intensivos | 30 | | 3 | Planta de Pediatr¡a | 40 | | 4 | Planta de Cirug¡a General | 60 | | 5 | Planta de Oncolog¡a | 35 | | 6 | Planta de Ginecolog¡a | 45 | | 7 | Planta de Cardiolog¡a | 50 | | 8 | Planta de Neurolog¡a | 25 | | 9 | Planta de Psiquiatr¡a | 20 | | 10 | Planta de Dermatolog¡a | 40 | +-----------+-------------------------------+-----------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.014 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(1, 'Urgencias', 300000, 'Quir£rgico', 'Activo'); Query OK, 1 row affected (0.043 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(2, 'Pediatr¡a', 200000, 'Diagn¢stico', 'Activo'); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(3, 'Radiolog¡a', 150000, 'Diagn¢stico', 'Activo'); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(4, 'Cirug¡a General', 2500000, 'Quir£rgico', 'Activo'); Query OK, 1 row affected (0.027 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(5, 'Oncolog¡a', 1500000, 'Tratamiento', 'Activo'); Query OK, 1 row affected (0.051 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(6, 'Ginecolog¡a', 250000, 'Ambulatorio', 'Activo'); Query OK, 1 row affected (0.039 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(7, 'Traumatolog¡a', 300000, 'Quir£rgico', 'Activo'); Query OK, 1 row affected (0.035 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(8, 'Dermatolog¡a', 200000, 'Diagn¢stico', 'Activo'); Query OK, 1 row affected (0.042 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(9, 'Cardiolog¡a', 500000, 'Tratamiento', 'Activo'); Query OK, 1 row affected (0.038 sec) MariaDB [hospital_el_milagroso]> call insertar_servicio(10, 'Psiquiatr¡a', 350000, 'Ambulatorio', 'Activo'); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('servicio'); +-------------+-----------------+---------+-------------+--------+ | id_servicio | nombre | costo | tipo | estado | +-------------+-----------------+---------+-------------+--------+ | 1 | Urgencias | 300000 | Quir£rgico | Activo | | 2 | Pediatr¡a | 200000 | Diagn¢stico | Activo | | 3 | Radiolog¡a | 150000 | Diagn¢stico | Activo | | 4 | Cirug¡a General | 2500000 | Quir£rgico | Activo | | 5 | Oncolog¡a | 1500000 | Tratamiento | Activo | | 6 | Ginecolog¡a | 250000 | Ambulatorio | Activo | | 7 | Traumatolog¡a | 300000 | Quir£rgico | Activo | | 8 | Dermatolog¡a | 200000 | Diagn¢stico | Activo | | 9 | Cardiolog¡a | 500000 | Tratamiento | Activo | | 10 | Psiquiatr¡a | 350000 | Ambulatorio | Activo | +-------------+-----------------+---------+-------------+--------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.016 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(1, 1); Query OK, 1 row affected (0.035 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(2, 2); Query OK, 1 row affected (0.055 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(3, 3); Query OK, 1 row affected (0.034 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(4, 4); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(5, 5); Query OK, 1 row affected (0.046 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(6, 6); Query OK, 1 row affected (0.035 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(7, 7); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(8, 8); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(9, 9); Query OK, 1 row affected (0.042 sec) MariaDB [hospital_el_milagroso]> call insertar_paciente_medico(10, 10); Query OK, 1 row affected (0.037 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('paciente_medico'); +--------------+------------+ | id_paciente2 | id_medico2 | +--------------+------------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | | 4 | 4 | | 5 | 5 | | 6 | 6 | | 7 | 7 | | 8 | 8 | | 9 | 9 | | 10 | 10 | +--------------+------------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.011 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(1, 1); Query OK, 1 row affected (0.006 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(2, 2); Query OK, 1 row affected (0.047 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(3, 3); Query OK, 1 row affected (0.053 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(4, 4); Query OK, 1 row affected (0.026 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(5, 5); Query OK, 1 row affected (0.036 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(6, 6); Query OK, 1 row affected (0.028 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(7, 7); Query OK, 1 row affected (0.028 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(8, 8); Query OK, 1 row affected (0.004 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(2, 9); Query OK, 1 row affected (0.030 sec) MariaDB [hospital_el_milagroso]> call insertar_hospital_paciente(3, 10); Query OK, 1 row affected (0.005 sec) MariaDB [hospital_el_milagroso]> call listar_tablas('hospital_paciente'); +--------------+--------------+ | id_hospital1 | id_paciente1 | +--------------+--------------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | | 4 | 4 | | 5 | 5 | | 6 | 6 | | 7 | 7 | | 8 | 8 | | 2 | 9 | | 3 | 10 | +--------------+--------------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.012 sec) MariaDB [hospital_el_milagroso]> exit