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 | Empresa | empleados | 0 | Empresa | PRIMARY | 1 | id_empleado | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Events | events | 0 | Events | PRIMARY | 1 | event_id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Events | participants | 0 | Events | PRIMARY | 1 | participants_id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Events | ticket | 0 | Events | PRIMARY | 1 | ticket_id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | INFS1200_RELEASE | Address | 0 | INFS1200_RELEASE | PRIMARY | 1 | AddressID | A | 1 | NULL | NULL | BTREE | YES | NULL | ||||
def | INFS1200_RELEASE | Customer | 1 | INFS1200_RELEASE | FK_Customer_AddressID | 1 | AddressID | A | 1 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | INFS1200_RELEASE | Customer | 0 | INFS1200_RELEASE | PRIMARY | 1 | CustomerID | A | 1 | NULL | NULL | BTREE | YES | NULL | ||||
def | INFS1200_RELEASE | Policy | 1 | INFS1200_RELEASE | FK_Policy_CustomerID | 1 | CustomerID | A | 1 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | INFS1200_RELEASE | Policy | 1 | INFS1200_RELEASE | FK_Policy_VehicleID | 1 | VehicleID | A | 1 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | INFS1200_RELEASE | Policy | 0 | INFS1200_RELEASE | PRIMARY | 1 | PolicyID | A | 1 | NULL | NULL | BTREE | YES | NULL | ||||
def | INFS1200_RELEASE | Vehicle | 1 | INFS1200_RELEASE | FK_Vehicle_VehicleCode | 1 | VehicleCode | A | 1 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | INFS1200_RELEASE | Vehicle | 0 | INFS1200_RELEASE | PRIMARY | 1 | VehicleID | A | 1 | NULL | NULL | BTREE | YES | NULL | ||||
def | INFS1200_RELEASE | VehicleCodeMapping | 0 | INFS1200_RELEASE | Make | 1 | Make | A | 4 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | INFS1200_RELEASE | VehicleCodeMapping | 0 | INFS1200_RELEASE | Make | 2 | Model | A | 5 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | INFS1200_RELEASE | VehicleCodeMapping | 0 | INFS1200_RELEASE | Make | 3 | Year | A | 5 | NULL | NULL | YES | BTREE | YES | NULL | |||
def | INFS1200_RELEASE | VehicleCodeMapping | 0 | INFS1200_RELEASE | PRIMARY | 1 | VehicleCode | A | 5 | NULL | NULL | BTREE | YES | NULL | ||||
def | INFS1200_RELEASE | VehicleExcessRange | 0 | INFS1200_RELEASE | PRIMARY | 1 | VehicleCode | A | 19 | NULL | NULL | BTREE | YES | NULL | ||||
def | INFS1200_RELEASE | VehicleValue | 0 | INFS1200_RELEASE | PRIMARY | 1 | VehicleCode | A | 19 | NULL | NULL | BTREE | YES | NULL | ||||
def | StdMdDB | course | 0 | StdMdDB | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | StdMdDB | student | 0 | StdMdDB | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | StdMdDB | user | 0 | StdMdDB | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Stefano | vulcano | 0 | Stefano | PRIMARY | 1 | codice | A | 4 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | RK | 0 | Table_insertion | PRIMARY | 1 | Id_speciale | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | RK | 0 | Table_insertion | PRIMARY | 2 | Id_saison | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | Table_insertion | RK | 0 | Table_insertion | PRIMARY | 3 | Id_pilote | A | 0 | NULL | NULL | BTREE | YES | NULL |
|