🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
information_schema
Nivel actual
🧬 Columnas: information_schema / REFERENTIAL_CONSTRAINTS
11| Campo | Tipo | Null | Key | Default | Extra |
|---|
| CONSTRAINT_CATALOG | varchar(512) | NO | | | |
| CONSTRAINT_SCHEMA | varchar(64) | NO | | | |
| CONSTRAINT_NAME | varchar(64) | NO | | | |
| UNIQUE_CONSTRAINT_CATALOG | varchar(512) | NO | | | |
| UNIQUE_CONSTRAINT_SCHEMA | varchar(64) | NO | | | |
| UNIQUE_CONSTRAINT_NAME | varchar(64) | YES | | | |
| MATCH_OPTION | varchar(64) | NO | | | |
| UPDATE_RULE | varchar(64) | NO | | | |
| DELETE_RULE | varchar(64) | NO | | | |
| TABLE_NAME | varchar(64) | NO | | | |
| REFERENCED_TABLE_NAME | varchar(64) | YES | | | |
🔬 Muestra de datos
4 filas
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | UNIQUE_CONSTRAINT_CATALOG | UNIQUE_CONSTRAINT_SCHEMA | UNIQUE_CONSTRAINT_NAME | MATCH_OPTION | UPDATE_RULE | DELETE_RULE | TABLE_NAME | REFERENCED_TABLE_NAME |
|---|
| def | caja_negra | fk_registros_categoria | def | caja_negra | PRIMARY | NONE | RESTRICT | RESTRICT | registros | categorias |
| def | libro_vida | fk_habit_logs_habit | def | libro_vida | PRIMARY | NONE | RESTRICT | CASCADE | habit_logs | habits |
| def | bitacora | fk_frases_created_by | def | bitacora | PRIMARY | NONE | RESTRICT | SET NULL | frases | usuarios |
| def | bitacora | fk_frases_updated_by | def | bitacora | PRIMARY | NONE | RESTRICT | SET NULL | frases | usuarios |