SELECT * FROM `PARTITIONS`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 24 | 682 | 16384 | 0 | 0 | 0 | 2019-12-02 18:31:20 | NULL | NULL | NULL | NULL | |||
def | ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 0 | 2019-12-02 18:19:20 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | cantidad_vehiculos | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:06 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | facciones | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:11 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | info | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:11 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | log_baneos | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-08-24 00:48:12 | 2024-08-24 00:48:12 | 2024-08-24 00:48:12 | NULL | NULL | |||
def | ONE WAY | log_ingresos | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:12 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | log_nombres | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:12 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | log_propiedades | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:13 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | log_transacciones | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:13 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | log_vehiculos | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:13 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | log_ventas | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:14 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | prendas | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:14 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | propiedades | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-08-24 00:48:14 | 2024-08-24 00:48:14 | NULL | NULL | NULL | |||
def | ONE WAY | registros | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:15 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | usuarios | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-24 00:48:15 | NULL | NULL | NULL | NULL | |||
def | ONE WAY | vehicles | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 185 | 44 | 8140 | 281474976710655 | 4096 | 0 | 2024-08-24 00:48:16 | 2024-08-24 00:48:16 | NULL | NULL | NULL | |||
def | PRUEBA | MATERIAL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2019-12-02 18:37:29 | NULL | NULL | NULL | NULL | |||
def | StdMdDB | course | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2019-12-02 17:50:29 | NULL | NULL | NULL | NULL | |||
def | StdMdDB | score | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2019-12-02 17:52:45 | NULL | NULL | NULL | NULL | |||
def | StdMdDB | student | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2019-12-02 17:46:21 | NULL | NULL | NULL | NULL | |||
def | StdMdDB | user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2019-12-02 17:56:47 | NULL | NULL | NULL | NULL | |||
def | Stefano | vulcano | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 0 | 0 | 2019-12-02 18:35:48 | NULL | NULL | NULL | NULL | |||
def | Table_insertion | RK | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2019-12-02 17:52:26 | NULL | NULL | NULL | NULL | |||
def | Table_insertion | cours | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2019-12-02 17:52:26 | NULL | NULL | NULL | NULL |
|