🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: libro_vida / reminders
8| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id | int(10) unsigned | NO | PRI | | auto_increment |
| title | varchar(220) | NO | | | |
| reminder_date | date | YES | MUL | | |
| reminder_time | time | YES | | | |
| category | varchar(80) | YES | | | |
| done | tinyint(1) | NO | MUL | 0 | |
| created_at | timestamp | NO | | current_timestamp() | |
| updated_at | timestamp | NO | | current_timestamp() | on update current_timestamp() |
🔬 Muestra de datos
3 filas
| id | title | reminder_date | reminder_time | category | done | created_at | updated_at |
|---|
| 1 | Respira. No tienes que hacerlo todo hoy. | 2026-06-28 | 09:00:00 | cuidado | 0 | 2026-06-28 07:55:25 | 2026-06-28 07:55:25 |
| 2 | Bebe agua | 2026-06-28 | 12:00:00 | salud | 0 | 2026-06-28 07:55:25 | 2026-06-28 07:55:25 |
| 3 | Revisar metas de la semana | 2026-06-28 | 20:00:00 | semana | 0 | 2026-06-28 07:55:25 | 2026-06-28 07:55:25 |