Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) unsigned | NO | PRI | auto_increment | |
| habit_id | int(10) unsigned | NO | MUL | ||
| log_date | date | NO | MUL | ||
| done | tinyint(1) | NO | 1 | ||
| note | text | YES | |||
| created_at | timestamp | NO | current_timestamp() |
| id | habit_id | log_date | done | note | created_at |
|---|---|---|---|---|---|
| 1 | 1 | 2026-06-28 | 1 | 2026-06-28 08:01:55 | |
| 2 | 2 | 2026-06-28 | 1 | 2026-06-28 08:27:21 |