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 | StdMdDB | PRIMARY | def | StdMdDB | course | id | 1 | NULL | NULL | NULL | NULL | |
def | StdMdDB | PRIMARY | def | StdMdDB | student | id | 1 | NULL | NULL | NULL | NULL | |
def | StdMdDB | PRIMARY | def | StdMdDB | user | id | 1 | NULL | NULL | NULL | NULL | |
def | Stefano | PRIMARY | def | Stefano | vulcano | codice | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | RK | Id_speciale | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | RK | Id_saison | 2 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | RK | Id_pilote | 3 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_saison | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_voiture | 2 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_rallye | 3 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_pilote | 4 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | ecurie | Id_ecurie | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | pilote | Id_pilote | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | rallye | Id_rallye | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | speciale | Id_speciale | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | voiture | Id_voiture | 1 | NULL | NULL | NULL | NULL | |
def | Tienda | PRIMARY | def | Tienda | Clientes | C_ID | 1 | NULL | NULL | NULL | NULL | |
def | Tienda | PRIMARY | def | Tienda | Productos | P_ID | 1 | NULL | NULL | NULL | NULL | |
def | Tienda | PRIMARY | def | Tienda | Ventas | V_ID | 1 | NULL | NULL | NULL | NULL | |
def | hotel_db | PRIMARY | def | hotel_db | checked | id | 1 | NULL | NULL | NULL | NULL | |
def | hotel_db | PRIMARY | def | hotel_db | contact | id | 1 | NULL | NULL | NULL | NULL | |
def | hotel_db | PRIMARY | def | hotel_db | image | id | 1 | NULL | NULL | NULL | NULL | |
def | hotel_db | PRIMARY | def | hotel_db | login | id | 1 | NULL | NULL | NULL | NULL | |
def | hotel_db | PRIMARY | def | hotel_db | newsletterlog | id | 1 | NULL | NULL | NULL | NULL | |
def | hotel_db | PRIMARY | def | hotel_db | payments | id | 1 | NULL | NULL | NULL | NULL |
|