SELECT * FROM `STATISTICS`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_SCHEMA | INDEX_NAME | SEQ_IN_INDEX | COLUMN_NAME | COLLATION | CARDINALITY | SUB_PART | PACKED | NULLABLE | INDEX_TYPE | COMMENT | INDEX_COMMENT | IS_VISIBLE | EXPRESSION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | Consultorio | Medico | 0 | Consultorio | PRIMARY | 1 | Cod_Médico | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Consultorio | paciente | 0 | Consultorio | PRIMARY | 1 | ID_Paciente | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | StdMdDB | course | 0 | StdMdDB | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | StdMdDB | student | 0 | StdMdDB | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | StdMdDB | user | 0 | StdMdDB | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Stefano | vulcano | 0 | Stefano | PRIMARY | 1 | codice | A | 4 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | RK | 0 | Table_insertion | PRIMARY | 1 | Id_speciale | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | RK | 0 | Table_insertion | PRIMARY | 2 | Id_saison | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | RK | 0 | Table_insertion | PRIMARY | 3 | Id_pilote | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | cours | 0 | Table_insertion | PRIMARY | 1 | Id_saison | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | cours | 0 | Table_insertion | PRIMARY | 2 | Id_voiture | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | cours | 0 | Table_insertion | PRIMARY | 3 | Id_rallye | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | cours | 0 | Table_insertion | PRIMARY | 4 | Id_pilote | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | ecurie | 0 | Table_insertion | PRIMARY | 1 | Id_ecurie | A | 4 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | pilote | 0 | Table_insertion | PRIMARY | 1 | Id_pilote | A | 30 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | rallye | 0 | Table_insertion | PRIMARY | 1 | Id_rallye | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | speciale | 1 | Table_insertion | Id_rallye | 1 | Id_rallye | A | 0 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | Table_insertion | speciale | 0 | Table_insertion | PRIMARY | 1 | Id_speciale | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | voiture | 1 | Table_insertion | Id_ecurie | 1 | Id_ecurie | A | 4 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | Table_insertion | voiture | 0 | Table_insertion | PRIMARY | 1 | Id_voiture | A | 14 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Aerolineas | 0 | aeropuerto | PRIMARY | 1 | aerolinea_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Aviones | 0 | aeropuerto | PRIMARY | 1 | avion_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Pasajeros | 0 | aeropuerto | numero_pasaporte | 1 | numero_pasaporte | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Pasajeros | 0 | aeropuerto | PRIMARY | 1 | pasajero_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Reservas | 1 | aeropuerto | pasajero_id | 1 | pasajero_id | A | 20 | NULL | NULL | YES | BTREE | YES | NULL |
|