SELECT * FROM `x$schema_flattened_keys`
|
table_schema | table_name | index_name | non_unique | subpart_exists | index_columns | |
---|---|---|---|---|---|---|
AjedrezDB | Jugador | PRIMARY | 0 | 0 | id_jugador | |
AjedrezDB | Movimiento | id_partida | 1 | 0 | id_partida | |
AjedrezDB | Movimiento | PRIMARY | 0 | 0 | id_movimiento | |
AjedrezDB | Participacion | id_jugador | 1 | 0 | id_jugador | |
AjedrezDB | Participacion | PRIMARY | 0 | 0 | id_partida,id_jugador | |
AjedrezDB | Partida | PRIMARY | 0 | 0 | id_partida | |
QCMed | Answer | PRIMARY | 0 | 0 | answer_id | |
QCMed | Answer | question_id | 1 | 0 | question_id | |
QCMed | Certificate | PRIMARY | 0 | 0 | certificate_id | |
QCMed | Question | PRIMARY | 0 | 0 | question_id | |
QCMed | Question | subject_id | 1 | 0 | subject_id | |
QCMed | Session | PRIMARY | 0 | 0 | session_id | |
QCMed | SessionCertificate | certificate_id | 1 | 0 | certificate_id | |
QCMed | SessionCertificate | PRIMARY | 0 | 0 | session_certificate_id | |
QCMed | SessionCertificate | session_id | 1 | 0 | session_id | |
QCMed | Subject | certificate_id | 1 | 0 | certificate_id | |
QCMed | Subject | PRIMARY | 0 | 0 | subject_id | |
QCMed | User | 0 | 0 | |||
QCMed | User | PRIMARY | 0 | 0 | user_id | |
QCMed | UserSession | PRIMARY | 0 | 0 | user_session_id | |
QCMed | UserSession | session_id | 1 | 0 | session_id | |
QCMed | UserSession | user_id | 1 | 0 | user_id | |
StdMdDB | course | PRIMARY | 0 | 0 | id | |
StdMdDB | student | PRIMARY | 0 | 0 | id | |
StdMdDB | user | PRIMARY | 0 | 0 | id |
|