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 | Az | Ragister | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-20 05:34:27 | NULL | NULL | NULL | NULL | |||
def | FlightBooking | Aircraft_Model | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | 1638 | 16384 | 0 | 0 | 0 | 2024-08-20 05:33:46 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Airline | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | 1638 | 16384 | 0 | 0 | 0 | 2024-08-20 05:33:46 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Airport | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | 1638 | 16384 | 0 | 0 | 0 | 2024-08-20 05:33:46 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Booking | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 30 | 546 | 16384 | 0 | 49152 | 0 | 2024-08-20 05:33:49 | 2024-08-20 05:33:50 | NULL | NULL | NULL | |||
def | FlightBooking | Booking_History | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 30 | 546 | 16384 | 0 | 32768 | 0 | 2024-08-20 05:33:48 | 2024-08-20 05:33:50 | NULL | NULL | NULL | |||
def | FlightBooking | Booking_Notification | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 30 | 546 | 16384 | 0 | 49152 | 0 | 2024-08-20 05:33:49 | 2024-08-20 05:33:50 | NULL | NULL | NULL | |||
def | FlightBooking | Booking_Status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-08-20 05:33:48 | 2024-08-20 05:33:50 | NULL | NULL | NULL | |||
def | FlightBooking | Customer | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 78 | 210 | 16384 | 0 | 0 | 0 | 2024-08-20 05:33:48 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Direction | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | 1638 | 16384 | 0 | 49152 | 0 | 2024-08-20 05:33:46 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Flight | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 40 | 409 | 16384 | 0 | 49152 | 0 | 2024-08-20 05:33:47 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Schedule | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 40 | 409 | 16384 | 0 | 16384 | 0 | 2024-08-20 05:33:47 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Seat | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 117 | 140 | 16384 | 0 | 32768 | 0 | 2024-08-20 05:33:49 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | FlightBooking | Seat_Class | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 0 | 0 | 2024-08-20 05:33:47 | 2024-08-20 05:33:49 | NULL | NULL | NULL | |||
def | HS_2021_0984 | Course_Table | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-08-20 05:38:15 | NULL | 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 |
|