MariaDB [Institucion]> create table TipoPersona
    -> (CodigoTP Int(5) not null primary key,
    -> Descripcion Varchar(60) not null);
Query OK, 0 rows affected (0.136 sec)

MariaDB [Institucion]> create table Estado
    -> (CodigoEstado Int(5) not null primary key,
    -> Descripcion Varchar(60) not null);
Query OK, 0 rows affected (0.263 sec)

MariaDB [Institucion]> create table Planta
    -> (CodigoPlanta Int(5) not null primary key,
    -> Descripcion Varchar(60) not null);
Query OK, 0 rows affected (0.155 sec)

MariaDB [Institucion]> create table Paciente
    -> (Cedula Int(20) not null primary key,
    -> Nombre1 Varchar(60) not null,
    -> Nombre2 Varchar(60) not null,
    -> Apellido Varchar(50) not null,
    -> Apellido2 Varchar(50) not null,
    -> Foto Text not null,
    -> UnidadOrganizacional Varchar(100),
    -> FechaNacimiento Date not null,
    -> EPS Text not null,
    -> CodigoTP Int(5) not null,
    -> foreign key(CodigoTP) references TipoPersona(CodigoTP) on delete cascade on update cascade);
Query OK, 0 rows affected (0.191 sec)

MariaDB [Institucion]> describe paciente;;
+----------------------+--------------+------+-----+---------+-------+
| Field                | Type         | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| Cedula               | int(20)      | NO   | PRI | NULL    |       |
| Nombre1              | varchar(60)  | NO   |     | NULL    |       |
| Nombre2              | varchar(60)  | NO   |     | NULL    |       |
| Apellido             | varchar(50)  | NO   |     | NULL    |       |
| Apellido2            | varchar(50)  | NO   |     | NULL    |       |
| Foto                 | text         | NO   |     | NULL    |       |
| UnidadOrganizacional | varchar(100) | YES  |     | NULL    |       |
| FechaNacimiento      | date         | NO   |     | NULL    |       |
| EPS                  | text         | NO   |     | NULL    |       |
| CodigoTP             | int(5)       | NO   | MUL | NULL    |       |
+----------------------+--------------+------+-----+---------+-------+
10 rows in set (0.010 sec)

ERROR: No query specified

MariaDB [Institucion]> describe paciente;
+----------------------+--------------+------+-----+---------+-------+
| Field                | Type         | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| Cedula               | int(20)      | NO   | PRI | NULL    |       |
| Nombre1              | varchar(60)  | NO   |     | NULL    |       |
| Nombre2              | varchar(60)  | NO   |     | NULL    |       |
| Apellido             | varchar(50)  | NO   |     | NULL    |       |
| Apellido2            | varchar(50)  | NO   |     | NULL    |       |
| Foto                 | text         | NO   |     | NULL    |       |
| UnidadOrganizacional | varchar(100) | YES  |     | NULL    |       |
| FechaNacimiento      | date         | NO   |     | NULL    |       |
| EPS                  | text         | NO   |     | NULL    |       |
| CodigoTP             | int(5)       | NO   | MUL | NULL    |       |
+----------------------+--------------+------+-----+---------+-------+
10 rows in set (0.051 sec)

MariaDB [Institucion]> create table Medico
    -> (Cedula Int(20) not null primary key,
    -> Nombre1 Varchar(60) not null,
    -> Nombre2 Varchar(60) not null,
    -> Apellido Varchar(50) not null,
    -> Apellido2 Varchar(50) not null,
    -> Foto Text not null,
    -> Especializacion Text not null,
    -> Correo Varchar(50) not null,
    -> Telefono Int(15) not null,
    -> Direccion Varchar(50) not null,
    -> FechaNacimiento Date not null);
Query OK, 0 rows affected (0.308 sec)

MariaDB [Institucion]> describe Medico;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| Cedula          | int(20)     | NO   | PRI | NULL    |       |
| Nombre1         | varchar(60) | NO   |     | NULL    |       |
| Nombre2         | varchar(60) | NO   |     | NULL    |       |
| Apellido        | varchar(50) | NO   |     | NULL    |       |
| Apellido2       | varchar(50) | NO   |     | NULL    |       |
| Foto            | text        | NO   |     | NULL    |       |
| Especializacion | text        | NO   |     | NULL    |       |
| Correo          | varchar(50) | NO   |     | NULL    |       |
| Telefono        | int(15)     | NO   |     | NULL    |       |
| Direccion       | varchar(50) | NO   |     | NULL    |       |
| FechaNacimiento | date        | NO   |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
11 rows in set (0.011 sec)

MariaDB [Institucion]> show tables;
+-----------------------+
| Tables_in_institucion |
+-----------------------+
| estado                |
| medico                |
| paciente              |
| planta                |
| tipopersona           |
+-----------------------+
5 rows in set (0.000 sec)

MariaDB [Institucion]> create table Registro
    -> (CodigoRegistro Int(5) not null primary key,
    -> CedulaPaciente Int(20) not null,
    -> CedulaMedico Int(20) not null,
    -> Estado Int(5) not null,
    -> Planta Int(5) not null,
    -> Descripcion Varchar(60) not null,
    -> FechaHora_Ingreso datetime not null,
    -> FechaHora_Salida datetime not null,
    -> foreign key(CedulaPaciente) references Paciente(Cedula) on delete cascade on update cascade,
    -> foreign key(CedulaMedico) references Medico(Cedula) on delete cascade on update cascade,
    -> foreign key(Estado) references Estado(CodigoEstado) on delete cascade on update cascade,
    -> foreign key(Planta) references Planta(CodigoPlanta) on delete cascade on update cascade);
Query OK, 0 rows affected (0.237 sec)

MariaDB [Institucion]> describe Registro;
+-------------------+-------------+------+-----+---------+-------+
| Field             | Type        | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| CodigoRegistro    | int(5)      | NO   | PRI | NULL    |       |
| CedulaPaciente    | int(20)     | NO   | MUL | NULL    |       |
| CedulaMedico      | int(20)     | NO   | MUL | NULL    |       |
| Estado            | int(5)      | NO   | MUL | NULL    |       |
| Planta            | int(5)      | NO   | MUL | NULL    |       |
| Descripcion       | varchar(60) | NO   |     | NULL    |       |
| FechaHora_Ingreso | datetime    | NO   |     | NULL    |       |
| FechaHora_Salida  | datetime    | NO   |     | NULL    |       |
+-------------------+-------------+------+-----+---------+-------+
8 rows in set (0.010 sec)

MariaDB [Institucion]> show tables;
+-----------------------+
| Tables_in_institucion |
+-----------------------+
| estado                |
| medico                |
| paciente              |
| planta                |
| registro              |
| tipopersona           |
+-----------------------+
6 rows in set (0.001 sec)

MariaDB [Institucion]> INSERT INTO TipoPersona (CodigoTP, Descripcion)
    -> VALUES
    ->     (1, 'Persona Jurˇdica'),
    ->     (2, 'Persona Natural');
Query OK, 2 rows affected (0.117 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [Institucion]> select * from TipoPersona
    -> ;
+----------+------------------+
| CodigoTP | Descripcion      |
+----------+------------------+
|        1 | Persona Jurˇdica |
|        2 | Persona Natural  |
+----------+------------------+
2 rows in set (0.000 sec)

MariaDB [Institucion]> INSERT INTO Estado (CodigoEstado, Descripcion)
    -> VALUES
    ->     (1, 'No urgente'),
    ->     (2, 'Menos urgente'),
    ->     (3, 'Urgente'),
    ->     (4, 'Emergencia'),
    ->     (5, 'Reanimacion');
Query OK, 5 rows affected (0.049 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [Institucion]> select * from Estado
    -> ;
+--------------+---------------+
| CodigoEstado | Descripcion   |
+--------------+---------------+
|            1 | No urgente    |
|            2 | Menos urgente |
|            3 | Urgente       |
|            4 | Emergencia    |
|            5 | Reanimacion   |
+--------------+---------------+
5 rows in set (0.000 sec)

MariaDB [Institucion]> INSERT INTO Planta (CodigoPlanta, Descripcion)
    -> VALUES
    -> (1, 'Radiologˇa'),
    ->     (2, 'Cirugˇa'),
    ->     (3, 'Cardiologˇa'),
    ->     (4, 'Pediatrˇa'),
    ->     (5, 'Ginecologˇa'),
    ->     (6, 'Urgencias'),
    ->     (7, 'Neurologˇa'),
    ->     (8, 'Oftalmologˇa'),
    ->     (9, 'Oncologˇa'),
    ->     (10, 'Traumatologˇa');
Query OK, 10 rows affected (0.052 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [Institucion]> select * from Planta;
+--------------+---------------+
| CodigoPlanta | Descripcion   |
+--------------+---------------+
|            1 | Radiologˇa    |
|            2 | Cirugˇa       |
|            3 | Cardiologˇa   |
|            4 | Pediatrˇa     |
|            5 | Ginecologˇa   |
|            6 | Urgencias     |
|            7 | Neurologˇa    |
|            8 | Oftalmologˇa  |
|            9 | Oncologˇa     |
|           10 | Traumatologˇa |
+--------------+---------------+
10 rows in set (0.000 sec)

MariaDB [Institucion]> INSERT INTO Paciente (Cedula, Nombre1, Nombre2, Apellido, Apellido2, Foto, UnidadOrganizacional, FechaNacimiento, EPS, CodigoTP)
    -> Values
    -> ('123456789', 'Juan', 'Carlos', 'P‚rez', 'G˘mez', 'ruta/foto1.jpg', 'Empresa', '1990-05-15', 'EPS SaludTotal', 1),
    ->     ('987654321', 'Marˇa', 'Isabel', 'Gonz lez', 'Martˇnez', 'ruta/foto2.jpg', 'Empresa', '1985-08-22', 'EPS Coomeva', 2),
    ->     ('456789123', 'Luis', 'Miguel', 'Rodrˇguez', 'Hern ndez', 'ruta/foto3.jpg', 'Empresa', '1977-03-10', 'EPS Sura', 1),
    ->     ('789123456', 'Ana', 'Marˇa', 'L˘pez', 'S nchez', 'ruta/foto4.jpg', 'Universidad', '1995-11-02', 'EPS Famisanar', 2),
    ->     ('321654987', 'Pedro', 'Jos‚', 'Martˇnez', 'Fern ndez', 'ruta/foto5.jpg', 'Empresa', '1988-07-18', 'EPS Sanitas', 1),
    ->     ('654987321', 'Carolina', 'Andrea', 'Ramˇrez', 'Vargas', 'ruta/foto6.jpg', 'Empresa', '1982-12-30', 'EPS Compensar', 2),
    ->     ('111222333', 'Miguel', 'µngel', 'G˘mez', 'P‚rez', 'ruta/foto7.jpg', 'Empresa', '1972-09-25', 'EPS Aliansalud', 1),
    ->     ('444555666', 'Sofˇa', 'Camila', 'Hern ndez', 'Gonz lez', 'ruta/foto8.jpg', 'Colegio', '2000-01-05', 'EPS Nueva EPS', 2),
    ->     ('777888999', 'Andr‚s', 'Felipe', 'P‚rez', 'Garcˇa', 'ruta/foto9.jpg', 'Universidad', '1998-06-12', 'EPS SaludTotal', 1),
    ->     ('888999000', 'Laura', 'Valentina', 'Torres', 'Rojas', 'ruta/foto10.jpg', 'Colegio', '2002-03-20', 'EPS Coomeva', 2);
Query OK, 10 rows affected (0.128 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [Institucion]> select * from Pacientes;
ERROR 1146 (42S02): Table 'institucion.pacientes' doesn't exist
MariaDB [Institucion]> select * from Paciente;
+-----------+----------+-----------+-----------+-----------+-----------------+----------------------+-----------------+----------------+----------+
| Cedula    | Nombre1  | Nombre2   | Apellido  | Apellido2 | Foto            | UnidadOrganizacional | FechaNacimiento | EPS            | CodigoTP |
+-----------+----------+-----------+-----------+-----------+-----------------+----------------------+-----------------+----------------+----------+
| 111222333 | Miguel   | µngel     | G˘mez     | P‚rez     | ruta/foto7.jpg  | Empresa              | 1972-09-25      | EPS Aliansalud |        1 |
| 123456789 | Juan     | Carlos    | P‚rez     | G˘mez     | ruta/foto1.jpg  | Empresa              | 1990-05-15      | EPS SaludTotal |        1 |
| 321654987 | Pedro    | Jos‚      | Martˇnez  | Fern ndez | ruta/foto5.jpg  | Empresa              | 1988-07-18      | EPS Sanitas    |        1 |
| 444555666 | Sofˇa    | Camila    | Hern ndez | Gonz lez  | ruta/foto8.jpg  | Colegio              | 2000-01-05      | EPS Nueva EPS  |        2 |
| 456789123 | Luis     | Miguel    | Rodrˇguez | Hern ndez | ruta/foto3.jpg  | Empresa              | 1977-03-10      | EPS Sura       |        1 |
| 654987321 | Carolina | Andrea    | Ramˇrez   | Vargas    | ruta/foto6.jpg  | Empresa              | 1982-12-30      | EPS Compensar  |        2 |
| 777888999 | Andr‚s   | Felipe    | P‚rez     | Garcˇa    | ruta/foto9.jpg  | Universidad          | 1998-06-12      | EPS SaludTotal |        1 |
| 789123456 | Ana      | Marˇa     | L˘pez     | S nchez   | ruta/foto4.jpg  | Universidad          | 1995-11-02      | EPS Famisanar  |        2 |
| 888999000 | Laura    | Valentina | Torres    | Rojas     | ruta/foto10.jpg | Colegio              | 2002-03-20      | EPS Coomeva    |        2 |
| 987654321 | Marˇa    | Isabel    | Gonz lez  | Martˇnez  | ruta/foto2.jpg  | Empresa              | 1985-08-22      | EPS Coomeva    |        2 |
+-----------+----------+-----------+-----------+-----------+-----------------+----------------------+-----------------+----------------+----------+
10 rows in set (0.000 sec)

MariaDB [Institucion]> INSERT INTO Medico (Cedula, Nombre1, Nombre2, Apellido, Apellido2, Foto, Especializacion, Correo, Telefono, Direccion, FechaNacimiento)
    -> Values
    -> ('123456789', 'Alejandro', 'Jos‚', 'G˘mez', 'L˘pez', 'ruta/foto_medico1.jpg', 'Cardi˘logo', 'alejandro@example.com', '123-456-7890', 'Calle Principal 123', '1980-05-15'),
    ->     ('987654321', 'Marˇa', 'Isabel', 'Martˇnez', 'Rojas', 'ruta/foto_medico2.jpg', 'Pediatra', 'maria@example.com', '987-654-3210', 'Avenida Central 456', '1975-08-22'),
    ->     ('456789123', 'Luis', 'Miguel', 'Rodrˇguez', 'Hern ndez', 'ruta/foto_medico3.jpg', 'Cirujano General', 'luis@example.com', '567-890-1234', 'Plaza Mayor 789', '1972-03-10'),
    ->     ('789123456', 'Ana', 'Marˇa', 'L˘pez', 'S nchez', 'ruta/foto_medico4.jpg', 'Ginec˘logo', 'ana@example.com', '987-654-3210', 'Calle 5 de Mayo 234', '1988-11-02'),
    ->     ('321654987', 'Pedro', 'Jos‚', 'Martˇnez', 'Fern ndez', 'ruta/foto_medico5.jpg', 'Urgenci˘logo', 'pedro@example.com', '123-456-7890', 'Carrera 10 567', '1985-07-18'),
    ->     ('654987321', 'Carolina', 'Andrea', 'Ramˇrez', 'Vargas', 'ruta/foto_medico6.jpg', 'Onc˘logo', 'carolina@example.com', '567-890-1234', 'Avenida Libertad 890', '1992-12-30'),
    ->     ('111222333', 'Miguel', 'µngel', 'G˘mez', 'P‚rez', 'ruta/foto_medico7.jpg', 'Neur˘logo', 'miguel@example.com', '987-654-3210', 'Paseo de la Reforma 123', '1983-09-25'),
    ->     ('444555666', 'Sofˇa', 'Camila', 'Hern ndez', 'Gonz lez', 'ruta/foto_medico8.jpg', 'Traumat˘logo', 'sofia@example.com', '123-456-7890', 'Boulevard de la Salud 456', '1979-01-05'),
    ->     ('777888999', 'Andr‚s', 'Felipe', 'P‚rez', 'Garcˇa', 'ruta/foto_medico9.jpg', 'Cardi˘logo', 'andres@example.com', '567-890-1234', 'Calle de los M‚dicos 789', '1987-06-12'),
    ->     ('888999000', 'Laura', 'Valentina', 'Torres', 'Rojas', 'ruta/foto_medico10.jpg', 'Pediatra', 'laura@example.com', '987-654-3210', 'Avenida de la Salud 234', '1990-03-20');
Query OK, 10 rows affected, 10 warnings (0.058 sec)
Records: 10  Duplicates: 0  Warnings: 10

MariaDB [Institucion]> select * from Medico;
+-----------+-----------+-----------+-----------+-----------+------------------------+------------------+-----------------------+----------+---------------------------+-----------------+
| Cedula    | Nombre1   | Nombre2   | Apellido  | Apellido2 | Foto                   | Especializacion  | Correo                | Telefono | Direccion                 | FechaNacimiento |
+-----------+-----------+-----------+-----------+-----------+------------------------+------------------+-----------------------+----------+---------------------------+-----------------+
| 111222333 | Miguel    | µngel     | G˘mez     | P‚rez     | ruta/foto_medico7.jpg  | Neur˘logo        | miguel@example.com    |      987 | Paseo de la Reforma 123   | 1983-09-25      |
| 123456789 | Alejandro | Jos‚      | G˘mez     | L˘pez     | ruta/foto_medico1.jpg  | Cardi˘logo       | alejandro@example.com |      123 | Calle Principal 123       | 1980-05-15      |
| 321654987 | Pedro     | Jos‚      | Martˇnez  | Fern ndez | ruta/foto_medico5.jpg  | Urgenci˘logo     | pedro@example.com     |      123 | Carrera 10 567            | 1985-07-18      |
| 444555666 | Sofˇa     | Camila    | Hern ndez | Gonz lez  | ruta/foto_medico8.jpg  | Traumat˘logo     | sofia@example.com     |      123 | Boulevard de la Salud 456 | 1979-01-05      |
| 456789123 | Luis      | Miguel    | Rodrˇguez | Hern ndez | ruta/foto_medico3.jpg  | Cirujano General | luis@example.com      |      567 | Plaza Mayor 789           | 1972-03-10      |
| 654987321 | Carolina  | Andrea    | Ramˇrez   | Vargas    | ruta/foto_medico6.jpg  | Onc˘logo         | carolina@example.com  |      567 | Avenida Libertad 890      | 1992-12-30      |
| 777888999 | Andr‚s    | Felipe    | P‚rez     | Garcˇa    | ruta/foto_medico9.jpg  | Cardi˘logo       | andres@example.com    |      567 | Calle de los M‚dicos 789  | 1987-06-12      |
| 789123456 | Ana       | Marˇa     | L˘pez     | S nchez   | ruta/foto_medico4.jpg  | Ginec˘logo       | ana@example.com       |      987 | Calle 5 de Mayo 234       | 1988-11-02      |
| 888999000 | Laura     | Valentina | Torres    | Rojas     | ruta/foto_medico10.jpg | Pediatra         | laura@example.com     |      987 | Avenida de la Salud 234   | 1990-03-20      |
| 987654321 | Marˇa     | Isabel    | Martˇnez  | Rojas     | ruta/foto_medico2.jpg  | Pediatra         | maria@example.com     |      987 | Avenida Central 456       | 1975-08-22      |
+-----------+-----------+-----------+-----------+-----------+------------------------+------------------+-----------------------+----------+---------------------------+-----------------+
10 rows in set (0.000 sec)

MariaDB [Institucion]> select * from paciente;
+-----------+----------+-----------+-----------+-----------+-----------------+----------------------+-----------------+----------------+----------+
| Cedula    | Nombre1  | Nombre2   | Apellido  | Apellido2 | Foto            | UnidadOrganizacional | FechaNacimiento | EPS            | CodigoTP |
+-----------+----------+-----------+-----------+-----------+-----------------+----------------------+-----------------+----------------+----------+
| 111222333 | Miguel   | µngel     | G˘mez     | P‚rez     | ruta/foto7.jpg  | Empresa              | 1972-09-25      | EPS Aliansalud |        1 |
| 123456789 | Juan     | Carlos    | P‚rez     | G˘mez     | ruta/foto1.jpg  | Empresa              | 1990-05-15      | EPS SaludTotal |        1 |
| 321654987 | Pedro    | Jos‚      | Martˇnez  | Fern ndez | ruta/foto5.jpg  | Empresa              | 1988-07-18      | EPS Sanitas    |        1 |
| 444555666 | Sofˇa    | Camila    | Hern ndez | Gonz lez  | ruta/foto8.jpg  | Colegio              | 2000-01-05      | EPS Nueva EPS  |        2 |
| 456789123 | Luis     | Miguel    | Rodrˇguez | Hern ndez | ruta/foto3.jpg  | Empresa              | 1977-03-10      | EPS Sura       |        1 |
| 654987321 | Carolina | Andrea    | Ramˇrez   | Vargas    | ruta/foto6.jpg  | Empresa              | 1982-12-30      | EPS Compensar  |        2 |
| 777888999 | Andr‚s   | Felipe    | P‚rez     | Garcˇa    | ruta/foto9.jpg  | Universidad          | 1998-06-12      | EPS SaludTotal |        1 |
| 789123456 | Ana      | Marˇa     | L˘pez     | S nchez   | ruta/foto4.jpg  | Universidad          | 1995-11-02      | EPS Famisanar  |        2 |
| 888999000 | Laura    | Valentina | Torres    | Rojas     | ruta/foto10.jpg | Colegio              | 2002-03-20      | EPS Coomeva    |        2 |
| 987654321 | Marˇa    | Isabel    | Gonz lez  | Martˇnez  | ruta/foto2.jpg  | Empresa              | 1985-08-22      | EPS Coomeva    |        2 |
+-----------+----------+-----------+-----------+-----------+-----------------+----------------------+-----------------+----------------+----------+
10 rows in set (0.000 sec)

MariaDB [Institucion]> select * from Planta;
+--------------+---------------+
| CodigoPlanta | Descripcion   |
+--------------+---------------+
|            1 | Radiologˇa    |
|            2 | Cirugˇa       |
|            3 | Cardiologˇa   |
|            4 | Pediatrˇa     |
|            5 | Ginecologˇa   |
|            6 | Urgencias     |
|            7 | Neurologˇa    |
|            8 | Oftalmologˇa  |
|            9 | Oncologˇa     |
|           10 | Traumatologˇa |
+--------------+---------------+
10 rows in set (0.000 sec)

MariaDB [Institucion]> select * from Estado;
+--------------+---------------+
| CodigoEstado | Descripcion   |
+--------------+---------------+
|            1 | No urgente    |
|            2 | Menos urgente |
|            3 | Urgente       |
|            4 | Emergencia    |
|            5 | Reanimacion   |
+--------------+---------------+
5 rows in set (0.000 sec)

MariaDB [Institucion]> INSERT INTO Registro (CodigoRegistro, CedulaPaciente, CedulaMedico, Estado, Planta, Descripcion, FechaHora_Ingreso, FechaHora_Paciente)
    -> Values
    -> (1, '123456789', '123456789', 1, 3, 'Fractura en brazo izquierdo', '2023-08-08 09:30:00', '2023-08-08 10:00:00'),
    ->     (2, '987654321', '987654321', 2, 5, 'Fiebre alta y tos persistente', '2023-08-08 11:15:00', '2023-08-08 11:30:00'),
    ->     (3, '456789123', '456789123', 3, 2, 'Apendicitis aguda', '2023-08-08 13:20:00', '2023-08-08 13:45:00'),
    ->     (4, '789123456', '789123456', 1, 8, 'Control prenatal', '2023-08-08 14:50:00', '2023-08-08 15:10:00'),
    ->     (5, '321654987', '321654987', 4, 6, 'Contusi˘n en pierna derecha', '2023-08-08 16:30:00', '2023-08-08 17:00:00'),
    ->     (6, '654987321', '654987321', 5, 4, 'Tratamiento de quimioterapia', '2023-08-08 18:15:00', '2023-08-08 18:30:00'),
    ->     (7, '111222333', '111222333', 1, 1, 'Dolor de cabeza intenso', '2023-08-08 20:00:00', '2023-08-08 20:30:00'),
    ->     (8, '444555666', '444555666', 2, 7, 'Fractura en mano derecha', '2023-08-08 22:45:00', '2023-08-08 23:00:00'),
    ->     (9, '777888999', '777888999', 3, 9, 'Control cardiol˘gico', '2023-08-08 23:30:00', '2023-08-08 23:45:00'),
    ->     (10, '888999000', '888999000', 1, 10, 'Fiebre y dolor de garganta', '2023-08-08 08:00:00', '2023-08-08 08:15:00');
ERROR 1054 (42S22): Unknown column 'FechaHora_Paciente' in 'field list'
MariaDB [Institucion]> INSERT INTO Registro (CodigoRegistro, CedulaPaciente, CedulaMedico, Estado, Planta, Descripcion, FechaHora_Ingreso, FechaHora_Salida)
    -> Values
    -> (1, '123456789', '123456789', 1, 3, 'Fractura en brazo izquierdo', '2023-08-08 09:30:00', '2023-08-08 10:00:00'),
    ->     (2, '987654321', '987654321', 2, 5, 'Fiebre alta y tos persistente', '2023-08-08 11:15:00', '2023-08-08 11:30:00'),
    ->     (3, '456789123', '456789123', 3, 2, 'Apendicitis aguda', '2023-08-08 13:20:00', '2023-08-08 13:45:00'),
    ->     (4, '789123456', '789123456', 1, 8, 'Control prenatal', '2023-08-08 14:50:00', '2023-08-08 15:10:00'),
    ->     (5, '321654987', '321654987', 4, 6, 'Contusi˘n en pierna derecha', '2023-08-08 16:30:00', '2023-08-08 17:00:00'),
    ->     (6, '654987321', '654987321', 5, 4, 'Tratamiento de quimioterapia', '2023-08-08 18:15:00', '2023-08-08 18:30:00'),
    ->     (7, '111222333', '111222333', 1, 1, 'Dolor de cabeza intenso', '2023-08-08 20:00:00', '2023-08-08 20:30:00'),
    ->     (8, '444555666', '444555666', 2, 7, 'Fractura en mano derecha', '2023-08-08 22:45:00', '2023-08-08 23:00:00'),
    ->     (9, '777888999', '777888999', 3, 9, 'Control cardiol˘gico', '2023-08-08 23:30:00', '2023-08-08 23:45:00'),
    ->     (10, '888999000', '888999000', 1, 10, 'Fiebre y dolor de garganta', '2023-08-08 08:00:00', '2023-08-08 08:15:00');
Query OK, 10 rows affected (0.115 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [Institucion]> select * from Registro;
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
| CodigoRegistro | CedulaPaciente | CedulaMedico | Estado | Planta | Descripcion                   | FechaHora_Ingreso   | FechaHora_Salida    |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
|              1 |      123456789 |    123456789 |      1 |      3 | Fractura en brazo izquierdo   | 2023-08-08 09:30:00 | 2023-08-08 10:00:00 |
|              2 |      987654321 |    987654321 |      2 |      5 | Fiebre alta y tos persistente | 2023-08-08 11:15:00 | 2023-08-08 11:30:00 |
|              3 |      456789123 |    456789123 |      3 |      2 | Apendicitis aguda             | 2023-08-08 13:20:00 | 2023-08-08 13:45:00 |
|              4 |      789123456 |    789123456 |      1 |      8 | Control prenatal              | 2023-08-08 14:50:00 | 2023-08-08 15:10:00 |
|              5 |      321654987 |    321654987 |      4 |      6 | Contusi˘n en pierna derecha   | 2023-08-08 16:30:00 | 2023-08-08 17:00:00 |
|              6 |      654987321 |    654987321 |      5 |      4 | Tratamiento de quimioterapia  | 2023-08-08 18:15:00 | 2023-08-08 18:30:00 |
|              7 |      111222333 |    111222333 |      1 |      1 | Dolor de cabeza intenso       | 2023-08-08 20:00:00 | 2023-08-08 20:30:00 |
|              8 |      444555666 |    444555666 |      2 |      7 | Fractura en mano derecha      | 2023-08-08 22:45:00 | 2023-08-08 23:00:00 |
|              9 |      777888999 |    777888999 |      3 |      9 | Control cardiol˘gico          | 2023-08-08 23:30:00 | 2023-08-08 23:45:00 |
|             10 |      888999000 |    888999000 |      1 |     10 | Fiebre y dolor de garganta    | 2023-08-08 08:00:00 | 2023-08-08 08:15:00 |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
10 rows in set (0.000 sec)

MariaDB [Institucion]> DELIMITER //
MariaDB [Institucion]> 
MariaDB [Institucion]> CREATE FUNCTION InsertarRegistro(
    ->     cedula_paciente INT(20),
    ->     cedula_medico INT(20),
    ->     estado INT(5),
    ->     planta INT(5),
    ->     descripcion Varchar(60),
    ->     fecha_hora_ingreso DATETIME,
    ->     fecha_hora_salida DATETIME
    -> ) RETURNS INT
    -> BEGIN
    ->     DECLARE registro_id INT;
    ->     
    ->     INSERT INTO Registro (CedulaPaciente, CedulaMedico, Estado, Planta, Descripcion, FechaHora_Ingreso, FechaHora_Salida)
    ->     VALUES (cedula_paciente, cedula_medico, estado, planta, descripcion, fecha_hora_ingreso, fecha_hora_salida);
    ->     
    ->     SET registro_id = LAST_INSERT_ID();
    ->     
    ->     RETURN registro_id;
    -> END //
Query OK, 0 rows affected (0.105 sec)

MariaDB [Institucion]> 
MariaDB [Institucion]> DELIMITER ;
MariaDB [Institucion]> show procedure status;
Empty set (0.010 sec)

MariaDB [Institucion]> show function status;
+-------------+------------------+----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db          | Name             | Type     | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+-------------+------------------+----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| institucion | InsertarRegistro | FUNCTION | root@localhost | 2023-08-08 10:52:03 | 2023-08-08 10:52:03 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+-------------+------------------+----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
1 row in set (0.010 sec)

MariaDB [Institucion]> SET @nuevoRegistroID = InsertarRegistro('123456789', '123456789', 1, 3, 'Fractura en brazo izquierdo', '2023-08-08 09:30:00', '2023-08-08 10:00:00');
Query OK, 0 rows affected (0.078 sec)

MariaDB [Institucion]> select * from Registro
    -> ;
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
| CodigoRegistro | CedulaPaciente | CedulaMedico | Estado | Planta | Descripcion                   | FechaHora_Ingreso   | FechaHora_Salida    |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
|              0 |      123456789 |    123456789 |      1 |      3 | Fractura en brazo izquierdo   | 2023-08-08 09:30:00 | 2023-08-08 10:00:00 |
|              1 |      123456789 |    123456789 |      1 |      3 | Fractura en brazo izquierdo   | 2023-08-08 09:30:00 | 2023-08-08 10:00:00 |
|              2 |      987654321 |    987654321 |      2 |      5 | Fiebre alta y tos persistente | 2023-08-08 11:15:00 | 2023-08-08 11:30:00 |
|              3 |      456789123 |    456789123 |      3 |      2 | Apendicitis aguda             | 2023-08-08 13:20:00 | 2023-08-08 13:45:00 |
|              4 |      789123456 |    789123456 |      1 |      8 | Control prenatal              | 2023-08-08 14:50:00 | 2023-08-08 15:10:00 |
|              5 |      321654987 |    321654987 |      4 |      6 | Contusi˘n en pierna derecha   | 2023-08-08 16:30:00 | 2023-08-08 17:00:00 |
|              6 |      654987321 |    654987321 |      5 |      4 | Tratamiento de quimioterapia  | 2023-08-08 18:15:00 | 2023-08-08 18:30:00 |
|              7 |      111222333 |    111222333 |      1 |      1 | Dolor de cabeza intenso       | 2023-08-08 20:00:00 | 2023-08-08 20:30:00 |
|              8 |      444555666 |    444555666 |      2 |      7 | Fractura en mano derecha      | 2023-08-08 22:45:00 | 2023-08-08 23:00:00 |
|              9 |      777888999 |    777888999 |      3 |      9 | Control cardiol˘gico          | 2023-08-08 23:30:00 | 2023-08-08 23:45:00 |
|             10 |      888999000 |    888999000 |      1 |     10 | Fiebre y dolor de garganta    | 2023-08-08 08:00:00 | 2023-08-08 08:15:00 |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
11 rows in set (0.000 sec)

MariaDB [Institucion]> select * from Registro;
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
| CodigoRegistro | CedulaPaciente | CedulaMedico | Estado | Planta | Descripcion                   | FechaHora_Ingreso   | FechaHora_Salida    |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
|              0 |      123456789 |    123456789 |      1 |      3 | Fractura en brazo izquierdo   | 2023-08-08 09:30:00 | 2023-08-08 10:00:00 |
|              1 |      123456789 |    123456789 |      1 |      3 | Fractura en brazo izquierdo   | 2023-08-08 09:30:00 | 2023-08-08 10:00:00 |
|              2 |      987654321 |    987654321 |      2 |      5 | Fiebre alta y tos persistente | 2023-08-08 11:15:00 | 2023-08-08 11:30:00 |
|              3 |      456789123 |    456789123 |      3 |      2 | Apendicitis aguda             | 2023-08-08 13:20:00 | 2023-08-08 13:45:00 |
|              4 |      789123456 |    789123456 |      1 |      8 | Control prenatal              | 2023-08-08 14:50:00 | 2023-08-08 15:10:00 |
|              5 |      321654987 |    321654987 |      4 |      6 | Contusi˘n en pierna derecha   | 2023-08-08 16:30:00 | 2023-08-08 17:00:00 |
|              6 |      654987321 |    654987321 |      5 |      4 | Tratamiento de quimioterapia  | 2023-08-08 18:15:00 | 2023-08-08 18:30:00 |
|              7 |      111222333 |    111222333 |      1 |      1 | Dolor de cabeza intenso       | 2023-08-08 20:00:00 | 2023-08-08 20:30:00 |
|              8 |      444555666 |    444555666 |      2 |      7 | Fractura en mano derecha      | 2023-08-08 22:45:00 | 2023-08-08 23:00:00 |
|              9 |      777888999 |    777888999 |      3 |      9 | Control cardiol˘gico          | 2023-08-08 23:30:00 | 2023-08-08 23:45:00 |
|             10 |      888999000 |    888999000 |      1 |     10 | Fiebre y dolor de garganta    | 2023-08-08 08:00:00 | 2023-08-08 08:15:00 |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
11 rows in set (0.000 sec)

MariaDB [Institucion]> delete from Registro where CodigoRegistro = 0;
Query OK, 1 row affected (0.041 sec)

MariaDB [Institucion]> select * from Registro;
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
| CodigoRegistro | CedulaPaciente | CedulaMedico | Estado | Planta | Descripcion                   | FechaHora_Ingreso   | FechaHora_Salida    |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
|              1 |      123456789 |    123456789 |      1 |      3 | Fractura en brazo izquierdo   | 2023-08-08 09:30:00 | 2023-08-08 10:00:00 |
|              2 |      987654321 |    987654321 |      2 |      5 | Fiebre alta y tos persistente | 2023-08-08 11:15:00 | 2023-08-08 11:30:00 |
|              3 |      456789123 |    456789123 |      3 |      2 | Apendicitis aguda             | 2023-08-08 13:20:00 | 2023-08-08 13:45:00 |
|              4 |      789123456 |    789123456 |      1 |      8 | Control prenatal              | 2023-08-08 14:50:00 | 2023-08-08 15:10:00 |
|              5 |      321654987 |    321654987 |      4 |      6 | Contusi˘n en pierna derecha   | 2023-08-08 16:30:00 | 2023-08-08 17:00:00 |
|              6 |      654987321 |    654987321 |      5 |      4 | Tratamiento de quimioterapia  | 2023-08-08 18:15:00 | 2023-08-08 18:30:00 |
|              7 |      111222333 |    111222333 |      1 |      1 | Dolor de cabeza intenso       | 2023-08-08 20:00:00 | 2023-08-08 20:30:00 |
|              8 |      444555666 |    444555666 |      2 |      7 | Fractura en mano derecha      | 2023-08-08 22:45:00 | 2023-08-08 23:00:00 |
|              9 |      777888999 |    777888999 |      3 |      9 | Control cardiol˘gico          | 2023-08-08 23:30:00 | 2023-08-08 23:45:00 |
|             10 |      888999000 |    888999000 |      1 |     10 | Fiebre y dolor de garganta    | 2023-08-08 08:00:00 | 2023-08-08 08:15:00 |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
10 rows in set (0.000 sec)

MariaDB [Institucion]> DELIMITER //
MariaDB [Institucion]> CREATE PROCEDURE ListarRegistros()
    -> BEGIN
    -> 	Select * from Registro
    -> End//
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 4
MariaDB [Institucion]> CREATE PROCEDURE ListarRegistros()
    -> BEGIN
    -> 	Select * from Registro;
    -> END//
Query OK, 0 rows affected (0.109 sec)

MariaDB [Institucion]> DELIMITER ;
MariaDB [Institucion]> show procedure status;
+-------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db          | Name            | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+-------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| institucion | ListarRegistros | PROCEDURE | root@localhost | 2023-08-08 11:05:52 | 2023-08-08 11:05:52 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+-------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
1 row in set (0.009 sec)

MariaDB [Institucion]> call ListarRegistros;
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
| CodigoRegistro | CedulaPaciente | CedulaMedico | Estado | Planta | Descripcion                   | FechaHora_Ingreso   | FechaHora_Salida    |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
|              1 |      123456789 |    123456789 |      1 |      3 | Fractura en brazo izquierdo   | 2023-08-08 09:30:00 | 2023-08-08 10:00:00 |
|              2 |      987654321 |    987654321 |      2 |      5 | Fiebre alta y tos persistente | 2023-08-08 11:15:00 | 2023-08-08 11:30:00 |
|              3 |      456789123 |    456789123 |      3 |      2 | Apendicitis aguda             | 2023-08-08 13:20:00 | 2023-08-08 13:45:00 |
|              4 |      789123456 |    789123456 |      1 |      8 | Control prenatal              | 2023-08-08 14:50:00 | 2023-08-08 15:10:00 |
|              5 |      321654987 |    321654987 |      4 |      6 | Contusi˘n en pierna derecha   | 2023-08-08 16:30:00 | 2023-08-08 17:00:00 |
|              6 |      654987321 |    654987321 |      5 |      4 | Tratamiento de quimioterapia  | 2023-08-08 18:15:00 | 2023-08-08 18:30:00 |
|              7 |      111222333 |    111222333 |      1 |      1 | Dolor de cabeza intenso       | 2023-08-08 20:00:00 | 2023-08-08 20:30:00 |
|              8 |      444555666 |    444555666 |      2 |      7 | Fractura en mano derecha      | 2023-08-08 22:45:00 | 2023-08-08 23:00:00 |
|              9 |      777888999 |    777888999 |      3 |      9 | Control cardiol˘gico          | 2023-08-08 23:30:00 | 2023-08-08 23:45:00 |
|             10 |      888999000 |    888999000 |      1 |     10 | Fiebre y dolor de garganta    | 2023-08-08 08:00:00 | 2023-08-08 08:15:00 |
+----------------+----------------+--------------+--------+--------+-------------------------------+---------------------+---------------------+
10 rows in set (0.000 sec)

Query OK, 0 rows affected (0.051 sec)

MariaDB [Institucion]> DELIMITER //
MariaDB [Institucion]> 
MariaDB [Institucion]> CREATE PROCEDURE ConsultarRegistroPorCodigo(IN codigo INT)
    -> BEGIN
    ->     SELECT *
    ->     FROM Registro
    ->     WHERE CodigoRegistro = codigo;
    -> END //
Query OK, 0 rows affected (0.117 sec)

MariaDB [Institucion]> CREATE PROCEDURE EliminarRegistro(IN codigo Int)
    -> BEGIN
    ->  DELETE FROM Registro WHERE CodigoRegistro = codigo;
    -> END//
Query OK, 0 rows affected (0.115 sec)

MariaDB [Institucion]> DELIMITER ;
MariaDB [Institucion]> show procedure status;
+-------------+----------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db          | Name                       | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+-------------+----------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| institucion | ConsultarRegistroPorCodigo | PROCEDURE | root@localhost | 2023-08-08 11:07:23 | 2023-08-08 11:07:23 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
| institucion | EliminarRegistro           | PROCEDURE | root@localhost | 2023-08-08 11:09:57 | 2023-08-08 11:09:57 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
| institucion | ListarRegistros            | PROCEDURE | root@localhost | 2023-08-08 11:05:52 | 2023-08-08 11:05:52 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+-------------+----------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
3 rows in set (0.010 sec)

MariaDB [Institucion]> DELIMITER //
MariaDB [Institucion]> 
MariaDB [Institucion]> CREATE PROCEDURE ModificarRegistro(
    ->     IN codigo INT(5),
    ->     IN nueva_descripcion VARCHAR(60)
    -> )
    -> BEGIN
    -> UPDATE Registro
    ->     SET Descripcion = nueva_descripcion
    ->     WHERE CodigoRegistro = codigo;
    -> END//
Query OK, 0 rows affected (0.128 sec)

MariaDB [Institucion]> DELIMITER ;
MariaDB [Institucion]> show procedure status;
+-------------+----------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db          | Name                       | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+-------------+----------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| institucion | ConsultarRegistroPorCodigo | PROCEDURE | root@localhost | 2023-08-08 11:07:23 | 2023-08-08 11:07:23 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
| institucion | EliminarRegistro           | PROCEDURE | root@localhost | 2023-08-08 11:09:57 | 2023-08-08 11:09:57 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
| institucion | ListarRegistros            | PROCEDURE | root@localhost | 2023-08-08 11:05:52 | 2023-08-08 11:05:52 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
| institucion | ModificarRegistro          | PROCEDURE | root@localhost | 2023-08-08 11:17:05 | 2023-08-08 11:17:05 | DEFINER       |         | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+-------------+----------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
4 rows in set (0.012 sec)

MariaDB [Institucion]> exit