SELECT * FROM `x$schema_flattened_keys`
|
table_schema | table_name | index_name | non_unique | subpart_exists | index_columns | |
---|---|---|---|---|---|---|
INFS1200_RELEASE | Address | PRIMARY | 0 | 0 | AddressID | |
INFS1200_RELEASE | Customer | FK_Customer_AddressID | 1 | 0 | AddressID | |
INFS1200_RELEASE | Customer | PRIMARY | 0 | 0 | CustomerID | |
INFS1200_RELEASE | Policy | FK_Policy_CustomerID | 1 | 0 | CustomerID | |
INFS1200_RELEASE | Policy | FK_Policy_VehicleID | 1 | 0 | VehicleID | |
INFS1200_RELEASE | Policy | PRIMARY | 0 | 0 | PolicyID | |
INFS1200_RELEASE | Vehicle | FK_Vehicle_VehicleCode | 1 | 0 | VehicleCode | |
INFS1200_RELEASE | Vehicle | PRIMARY | 0 | 0 | VehicleID | |
INFS1200_RELEASE | VehicleCodeMapping | Make | 0 | 0 | Make,Model,Year | |
INFS1200_RELEASE | VehicleCodeMapping | PRIMARY | 0 | 0 | VehicleCode | |
INFS1200_RELEASE | VehicleExcessRange | PRIMARY | 0 | 0 | VehicleCode | |
INFS1200_RELEASE | VehicleValue | PRIMARY | 0 | 0 | VehicleCode | |
StdMdDB | course | PRIMARY | 0 | 0 | id | |
StdMdDB | student | PRIMARY | 0 | 0 | id | |
StdMdDB | user | PRIMARY | 0 | 0 | id | |
Stefano | vulcano | PRIMARY | 0 | 0 | codice | |
Table_insertion | RK | PRIMARY | 0 | 0 | Id_speciale,Id_saison,Id_pilote | |
Table_insertion | cours | PRIMARY | 0 | 0 | Id_saison,Id_voiture,Id_rallye,Id_pilote | |
Table_insertion | ecurie | PRIMARY | 0 | 0 | Id_ecurie | |
Table_insertion | pilote | PRIMARY | 0 | 0 | Id_pilote | |
Table_insertion | rallye | PRIMARY | 0 | 0 | Id_rallye | |
Table_insertion | speciale | Id_rallye | 1 | 0 | Id_rallye | |
Table_insertion | speciale | PRIMARY | 0 | 0 | Id_speciale | |
Table_insertion | voiture | Id_ecurie | 1 | 0 | Id_ecurie | |
Table_insertion | voiture | PRIMARY | 0 | 0 | Id_voiture |
|