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

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| hospital           |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.024 sec)

MariaDB [(none)]> use hospital;
Database changed
MariaDB [hospital]> Create table pacientes (
    -> id_paciente Varchar(45) not null PRIMARY KEY,
    -> nombre VARCHAR(45) NOT NULL,
    -> genero VARCHAR(45) NOT NULL,
    -> telefono VARCHAR(45) NOT NULL,
    -> Email VARCHAR(45) NOT NULL);
Query OK, 0 rows affected (0.011 sec)

MariaDB [hospital]> describe pacientes;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| id_paciente | varchar(45) | NO   | PRI | NULL    |       |
| nombre      | varchar(45) | NO   |     | NULL    |       |
| genero      | varchar(45) | NO   |     | NULL    |       |
| telefono    | varchar(45) | NO   |     | NULL    |       |
| Email       | varchar(45) | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
5 rows in set (0.017 sec)

MariaDB [hospital]> CREATE TABLE Medicos (
    -> id_medico  Varchar(45) not null PRIMARY KEY,
    -> nombre VARCHAR(45) NOT NULL,
    -> especialidad VARCHAR(45) NOT NULL,
    -> telefono VARCHAR(45) NOT NULL,
    -> Email VARCHAR(45) NOT NULL);
Query OK, 0 rows affected (0.013 sec)

MariaDB [hospital]> describe MEDICOS;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_medico    | varchar(45) | NO   | PRI | NULL    |       |
| nombre       | varchar(45) | NO   |     | NULL    |       |
| especialidad | varchar(45) | NO   |     | NULL    |       |
| telefono     | varchar(45) | NO   |     | NULL    |       |
| Email        | varchar(45) | NO   |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
5 rows in set (0.014 sec)

MariaDB [hospital]> CREATE TABLE Plantas (
    -> id_planta  Varchar(45) not null PRIMARY KEY,
    -> nombre_planta VARCHAR(45) NOT NULL);
Query OK, 0 rows affected (0.012 sec)

MariaDB [hospital]> describe plantas;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_planta     | varchar(45) | NO   | PRI | NULL    |       |
| nombre_planta | varchar(45) | NO   |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.012 sec)

MariaDB [hospital]> CREATE TABLE Ingresos (
    -> id_ingreso  Varchar(45) not null PRIMARY KEY,
    -> fecha_ingreso VARCHAR(45) NOT NULL,
    -> fecha_alta VARCHAR(45) NOT NULL,
    -> FK_paciente varchar(45) not null,
    -> FK_planta varchar(45) not null,
    -> foreign key(FK_paciente) references pacientes(id_paciente) on delete cascade on update cascade,
    -> foreign key(FK_planta) references plantas(id_planta) on delete cascade on update cascade);
Query OK, 0 rows affected (0.028 sec)

MariaDB [hospital]> describe ingresos;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_ingreso    | varchar(45) | NO   | PRI | NULL    |       |
| fecha_ingreso | varchar(45) | NO   |     | NULL    |       |
| fecha_alta    | varchar(45) | NO   |     | NULL    |       |
| FK_paciente   | varchar(45) | NO   | MUL | NULL    |       |
| FK_planta     | varchar(45) | NO   | MUL | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.016 sec)

MariaDB [hospital]> CREATE TABLE Asignaciones_Medicos (
    -> id_asignacion Varchar(45) not null PRIMARY KEY,
    -> fecha_asignacion VARCHAR(45) NOT NULL,
    -> FK_ingreso varchar(45) not null,
    -> FK_medico varchar(45) not null,
    -> foreign key(FK_ingreso) references ingresos(id_ingreso) on delete cascade on update cascade,
    -> foreign key(FK_medico) references medicos(id_medico) on delete cascade on update cascade);
Query OK, 0 rows affected (0.029 sec)

MariaDB [hospital]> describe Asignaciones_Medicos;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| id_asignacion    | varchar(45) | NO   | PRI | NULL    |       |
| fecha_asignacion | varchar(45) | NO   |     | NULL    |       |
| FK_ingreso       | varchar(45) | NO   | MUL | NULL    |       |
| FK_medico        | varchar(45) | NO   | MUL | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
4 rows in set (0.015 sec)

MariaDB [hospital]> exit