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

MariaDB [(none)]> use sistema_credito;
Database changed
MariaDB [sistema_credito]> create table referencia_cliente
    -> (Idcliente varchar(30) not null primary key,
    -> Idreferencia varchar(15) not null,
    -> Nombre varchar(50) not null,
    -> Apellido varchar(50) not null,
    -> Direccion varchar(30) not null,
    -> Fecha_nacimineto date not null,
    -> Telefono varchar(10) not null,
    -> Email varchar(30) not null);
Query OK, 0 rows affected (0.17 sec)

MariaDB [sistema_credito]> describe referencia_cliente;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| Idcliente        | varchar(30) | NO   | PRI | NULL    |       |
| Idreferencia     | varchar(15) | NO   |     | NULL    |       |
| Nombre           | varchar(50) | NO   |     | NULL    |       |
| Apellido         | varchar(50) | NO   |     | NULL    |       |
| Direccion        | varchar(30) | NO   |     | NULL    |       |
| Fecha_nacimineto | date        | NO   |     | NULL    |       |
| Telefono         | varchar(10) | NO   |     | NULL    |       |
| Email            | varchar(30) | NO   |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

MariaDB [sistema_credito]> create table cliente
    -> (Idcliente varchar(30) not null primary key,
    -> Nombre varchar(50) not null,
    -> Apellido varchar(50) not null,
    -> Direccion varchar(30) not null,
    -> Fecha_nacimineto date not null,
    -> Telefono varchar(10) not null,
    -> Email varchar(30) not null);
Query OK, 0 rows affected (0.21 sec)

MariaDB [sistema_credito]> describe cliente
    -> ;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| Idcliente        | varchar(30) | NO   | PRI | NULL    |       |
| Nombre           | varchar(50) | NO   |     | NULL    |       |
| Apellido         | varchar(50) | NO   |     | NULL    |       |
| Direccion        | varchar(30) | NO   |     | NULL    |       |
| Fecha_nacimineto | date        | NO   |     | NULL    |       |
| Telefono         | varchar(10) | NO   |     | NULL    |       |
| Email            | varchar(30) | NO   |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

MariaDB [sistema_credito]> create table tipo_credito
    -> (Idcredito varchar(15) not null primary key,
    -> Nombre_credi varchar(30) not null,
    -> Tiempo date not null);
Query OK, 0 rows affected (0.13 sec)

MariaDB [sistema_credito]> describe tipo_credito;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| Idcredito    | varchar(15) | NO   | PRI | NULL    |       |
| Nombre_credi | varchar(30) | NO   |     | NULL    |       |
| Tiempo       | date        | NO   |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

MariaDB [sistema_credito]> create table productos
    -> (Idproducto varchar(15) not null primary key,
    -> Nombre varchar(50) not null,
    -> Precio float not null,
    -> Stock int not null);
Query OK, 0 rows affected (0.32 sec)

MariaDB [sistema_credito]> describe productos;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| Idproducto | varchar(15) | NO   | PRI | NULL    |       |
| Nombre     | varchar(50) | NO   |     | NULL    |       |
| Precio     | float       | NO   |     | NULL    |       |
| Stock      | int(11)     | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)