🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: sys / x$schema_flattened_keys
6| Campo | Tipo | Null | Key | Default | Extra |
|---|
| table_schema | varchar(64) | NO | | | |
| table_name | varchar(64) | NO | | | |
| index_name | varchar(64) | NO | | | |
| non_unique | bigint(1) | YES | | | |
| subpart_exists | bigint(1) | YES | | | |
| index_columns | mediumtext | YES | | | |
🔬 Muestra de datos
20 filas
| table_schema | table_name | index_name | non_unique | subpart_exists | index_columns |
|---|
| bitacora | frases | fk_frases_created_by | 1 | 0 | created_by |
| bitacora | frases | fk_frases_updated_by | 1 | 0 | updated_by |
| bitacora | frases | idx_autor | 1 | 0 | autor |
| bitacora | frases | idx_categoria | 1 | 0 | categoria |
| bitacora | frases | idx_created_at | 1 | 0 | created_at |
| bitacora | frases | idx_favorita | 1 | 0 | favorita |
| bitacora | frases | idx_fecha_frase | 1 | 0 | fecha_frase |
| bitacora | frases | idx_visible | 1 | 0 | visible |
| bitacora | frases | PRIMARY | 0 | 0 | id |
| bitacora | usuarios | PRIMARY | 0 | 0 | id |
| bitacora | usuarios | usuario | 0 | 0 | usuario |
| caja_negra | categorias | PRIMARY | 0 | 0 | id |
| caja_negra | categorias | slug | 0 | 0 | slug |
| caja_negra | registros | idx_categoria_fecha | 1 | 0 | categoria_id,fecha_evento |
| caja_negra | registros | idx_fecha | 1 | 0 | fecha_evento |
| caja_negra | registros | idx_intensidad | 1 | 0 | intensidad |
| caja_negra | registros | PRIMARY | 0 | 0 | id |
| fakenews_lab | frases_bigramas | idx_categoria | 1 | 0 | categoria |
| fakenews_lab | frases_bigramas | idx_intensidad | 1 | 0 | intensidad |
| fakenews_lab | frases_bigramas | idx_visible | 1 | 0 | visible |