SELECT * FROM `KEY_COLUMN_USAGE`
|
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
def | aeropuerto | PRIMARY | def | aeropuerto | Aerolineas | aerolinea_id | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Aviones | avion_id | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | numero_pasaporte | def | aeropuerto | Pasajeros | numero_pasaporte | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Pasajeros | pasajero_id | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Reservas | reserva_id | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Tripulantes | tripulante_id | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Vuelo_Aerolinea | vuelo_id | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Vuelo_Aerolinea | aerolinea_id | 2 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Vuelo_Tripulante | vuelo_id | 1 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Vuelo_Tripulante | tripulante_id | 2 | NULL | NULL | NULL | NULL | |
def | aeropuerto | PRIMARY | def | aeropuerto | Vuelos | vuelo_id | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | anexos | idAnexos | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | anotacoes_os | idAnotacoes | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | categorias | idCategorias | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | clientes | idClientes | 1 | NULL | NULL | NULL | NULL | |
def | loja | config | def | loja | configuracoes | config | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | configuracoes | idConfig | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | contas | idContas | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | documentos | idDocumentos | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | email_queue | id | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | emitente | id | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | equipamentos | idEquipamentos | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | equipamentos_os | idEquipamentos_os | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | garantias | idGarantias | 1 | NULL | NULL | NULL | NULL | |
def | loja | PRIMARY | def | loja | itens_de_vendas | idItens | 1 | NULL | NULL | NULL | NULL |
|