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 | Events | PRIMARY | def | Events | events | event_id | 1 | NULL | NULL | NULL | NULL | |
def | Events | PRIMARY | def | Events | participants | participants_id | 1 | NULL | NULL | NULL | NULL | |
def | Events | PRIMARY | def | Events | ticket | ticket_id | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | PRIMARY | def | INFS1200_RELEASE | Address | AddressID | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | PRIMARY | def | INFS1200_RELEASE | Customer | CustomerID | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | PRIMARY | def | INFS1200_RELEASE | Policy | PolicyID | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | PRIMARY | def | INFS1200_RELEASE | Vehicle | VehicleID | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | Make | def | INFS1200_RELEASE | VehicleCodeMapping | Make | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | Make | def | INFS1200_RELEASE | VehicleCodeMapping | Model | 2 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | Make | def | INFS1200_RELEASE | VehicleCodeMapping | Year | 3 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | PRIMARY | def | INFS1200_RELEASE | VehicleCodeMapping | VehicleCode | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | PRIMARY | def | INFS1200_RELEASE | VehicleExcessRange | VehicleCode | 1 | NULL | NULL | NULL | NULL | |
def | INFS1200_RELEASE | PRIMARY | def | INFS1200_RELEASE | VehicleValue | VehicleCode | 1 | NULL | NULL | NULL | NULL | |
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_voiture | 2 | 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_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 |
|