tablas.txt

MariaDB [sistema_escolar_2]> describe asistencia; describe alumnos;
+-------------------------+---------------------+------+-----+---------+----------------+
| Field                   | Type                | Null | Key | Default | Extra          |
+-------------------------+---------------------+------+-----+---------+----------------+
| id                      | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| id_alumno               | bigint(20) unsigned | NO   | MUL | NULL    |                |
| estado                  | enum('a','r','f')   | NO   |     | NULL    |                |
| id_registros_asistencia | bigint(20) unsigned | NO   | MUL | NULL    |                |
+-------------------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| id               | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| nombre           | varchar(191)        | NO   |     | NULL    |                |
| apellido_paterno | varchar(191)        | NO   |     | NULL    |                |
| apellido_materno | varchar(191)        | NO   |     | NULL    |                |
| calle            | varchar(191)        | NO   |     | NULL    |                |
| numero           | varchar(191)        | NO   |     | NULL    |                |
| localidad        | varchar(191)        | NO   |     | NULL    |                |
| cp               | varchar(191)        | NO   |     | NULL    |                |
| created_at       | timestamp           | YES  |     | NULL    |                |
| updated_at       | timestamp           | YES  |     | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

MariaDB [sistema_escolar_2]>