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

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

MariaDB [hospital_el_milagroso]> create table hospital
    -> ( id_hospital int not null primary key,
    -> nombre varchar(30) not null,
    -> Direccion varchar(30) not null,
    -> telefono int not null,
    -> tipo varchar(30) not null);
Query OK, 0 rows affected (0.031 sec)

MariaDB [hospital_el_milagroso]> create table paciente
    -> ( id_paciente int not null primary key,
    -> nombre varchar(30) not null,
    -> apellido varchar(30) not null,
    -> fecha_nacimiento date not null,
    -> sexo varchar(30) not null);
Query OK, 0 rows affected (0.015 sec)

MariaDB [hospital_el_milagroso]> create table servicio
    -> (id_servicio int not null primary key,
    -> nombre varchar(30) not null,
    -> costo float not null,
    -> tipo varchar(30) not null,
    -> estado varchar(30) not null);
Query OK, 0 rows affected (0.014 sec)

MariaDB [hospital_el_milagroso]> create table medico
    -> (id_medico int not null primary key,
    -> nombre varchar(30) not null,
    -> especialidad varchar(30) not null,
    -> correo varchar(30) not null,
    -> telefono int not null);
Query OK, 0 rows affected (0.011 sec)

MariaDB [hospital_el_milagroso]> create table estado_salud
    -> (id_estado_salud int not null primary key,
    -> descripcion_estado_salud varchar(30) not null,
    -> fecha_registro date not null);
Query OK, 0 rows affected (0.014 sec)

MariaDB [hospital_el_milagroso]> create table planta
    -> (id_planta int not null primary key,
    -> nombre varchar(30) not null,
    -> capacidad int not null);
Query OK, 0 rows affected (0.014 sec)

MariaDB [hospital_el_milagroso]> create table hospital_paciente
    -> ( id_hospital1 int not null,
    -> id_paciente1 int not null,
    -> foreign key(id_hospital1) references hospital(id_hospital) on delete cascade on update cascade,
    -> foreign key(id_paciente1) references paciente(id_paciente) on delete cascade on update cascade);
Query OK, 0 rows affected (0.031 sec)

 
MariaDB [hospital_el_milagroso]> create table paciente_medico
    -> ( id_paciente2 int not null,
    -> id_medico2 int not null,
    -> foreign key(id_paciente2) references paciente(id_paciente) on delete cascade on update cascade,
    -> foreign key(id_medico2) references medico(id_medico) on delete cascade on update cascade);
Query OK, 0 rows affected (0.059 sec)

MariaDB [hospital_el_milagroso]> exit