🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: libro_vida / week_events
9| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id | int(10) unsigned | NO | PRI | | auto_increment |
| event_date | date | NO | MUL | | |
| event_time | time | YES | | | |
| title | varchar(220) | NO | | | |
| description | text | YES | | | |
| color | varchar(24) | 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
4 filas
| id | event_date | event_time | title | description | color | done | created_at | updated_at |
|---|
| 1 | 2026-06-22 | 09:00:00 | Planificar la semana | | #a78bfa | 0 | 2026-06-28 07:55:25 | 2026-06-28 07:55:25 |
| 2 | 2026-06-24 | 18:30:00 | Caminar sin pantalla | | #7ee787 | 0 | 2026-06-28 07:55:25 | 2026-06-28 07:55:25 |
| 3 | 2026-06-26 | 17:00:00 | Revisar finanzas | | #fbbf24 | 0 | 2026-06-28 07:55:25 | 2026-06-28 07:55:25 |
| 4 | 2026-06-28 | 20:00:00 | Cerrar la semana | | #4ee0c1 | 0 | 2026-06-28 07:55:25 | 2026-06-28 07:55:25 |