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 | aeropuerto | Aerolineas | 0 | aeropuerto | PRIMARY | 1 | aerolinea_id | A | 19 | 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 | |||
def | aeropuerto | Reservas | 0 | aeropuerto | PRIMARY | 1 | reserva_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Reservas | 1 | aeropuerto | vuelo_id | 1 | vuelo_id | A | 20 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | aeropuerto | Tripulantes | 0 | aeropuerto | PRIMARY | 1 | tripulante_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Vuelo_Aerolinea | 1 | aeropuerto | aerolinea_id | 1 | aerolinea_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Vuelo_Aerolinea | 0 | aeropuerto | PRIMARY | 1 | vuelo_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Vuelo_Aerolinea | 0 | aeropuerto | PRIMARY | 2 | aerolinea_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Vuelo_Tripulante | 0 | aeropuerto | PRIMARY | 1 | vuelo_id | A | 16 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Vuelo_Tripulante | 0 | aeropuerto | PRIMARY | 2 | tripulante_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Vuelo_Tripulante | 1 | aeropuerto | tripulante_id | 1 | tripulante_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | aeropuerto | Vuelos | 1 | aeropuerto | avion_id | 1 | avion_id | A | 20 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | aeropuerto | Vuelos | 0 | aeropuerto | PRIMARY | 1 | vuelo_id | A | 20 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | anexos | 1 | loja | fk_anexos_os1 | 1 | os_id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | anexos | 0 | loja | PRIMARY | 1 | idAnexos | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | anotacoes_os | 0 | loja | PRIMARY | 1 | idAnotacoes | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | categorias | 0 | loja | PRIMARY | 1 | idCategorias | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | ci_sessions | 1 | loja | ci_sessions_timestamp | 1 | timestamp | A | 52 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | clientes | 0 | loja | PRIMARY | 1 | idClientes | A | 2 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | configuracoes | 0 | loja | config | 1 | config | A | 5 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | configuracoes | 0 | loja | PRIMARY | 1 | idConfig | A | 5 | NULL | NULL | BTREE | YES | NULL | ||||
def | loja | contas | 0 | loja | PRIMARY | 1 | idContas | A | 0 | NULL | NULL | BTREE | YES | NULL |
|