SELECT * FROM `x$schema_flattened_keys`
|
table_schema | table_name | index_name | non_unique | subpart_exists | index_columns | |
---|---|---|---|---|---|---|
StdMdDB | course | PRIMARY | 0 | 0 | id | |
StdMdDB | student | PRIMARY | 0 | 0 | id | |
StdMdDB | user | PRIMARY | 0 | 0 | id | |
Stefano | vulcano | PRIMARY | 0 | 0 | codice | |
Table_insertion | RK | PRIMARY | 0 | 0 | Id_speciale,Id_saison,Id_pilote | |
Table_insertion | cours | PRIMARY | 0 | 0 | Id_saison,Id_voiture,Id_rallye,Id_pilote | |
Table_insertion | ecurie | PRIMARY | 0 | 0 | Id_ecurie | |
Table_insertion | pilote | PRIMARY | 0 | 0 | Id_pilote | |
Table_insertion | rallye | PRIMARY | 0 | 0 | Id_rallye | |
Table_insertion | speciale | Id_rallye | 1 | 0 | Id_rallye | |
Table_insertion | speciale | PRIMARY | 0 | 0 | Id_speciale | |
Table_insertion | voiture | Id_ecurie | 1 | 0 | Id_ecurie | |
Table_insertion | voiture | PRIMARY | 0 | 0 | Id_voiture | |
pw | credenciales | PRIMARY | 0 | 0 | user | |
pw | estudio | PRIMARY | 0 | 0 | DNI,titulo | |
pw | experiencia | PRIMARY | 0 | 0 | DNI,empresa,puesto | |
pw | idioma | PRIMARY | 0 | 0 | DNI,idioma | |
pw | usuario | PRIMARY | 0 | 0 | DNI | |
pw | usuario | user | 0 | 0 | user | |
sakila | actor | idx_actor_last_name | 1 | 0 | last_name | |
sakila | actor | PRIMARY | 0 | 0 | actor_id | |
sakila | address | idx_fk_city_id | 1 | 0 | city_id | |
sakila | address | PRIMARY | 0 | 0 | address_id | |
sakila | category | PRIMARY | 0 | 0 | category_id | |
sakila | city | idx_fk_country_id | 1 | 0 | country_id |
|