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 | PROJECT | AeroPlane_Maintenance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:35 | NULL | NULL | NULL | NULL | |||
def | PROJECT | AirLine_lounge | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:37 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airline | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:34 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airline_Airplanes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:35 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airline_Maintenance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:35 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airline_Refund | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:37 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airline_Salary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:34 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airplane_pilot | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:36 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airplanes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:35 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airplanes_crewstaff | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:36 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airport | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:37 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Airport_Runways | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:37 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Cabin_CrewStaff | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:35 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Employee_Airline | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:34 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Employee_Flight | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:33 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Employees | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:31 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Flight | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:32 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Flight_Passenger | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 16384 | 0 | 2024-07-03 11:46:33 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Inflight_Entertainment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:38 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Passenger | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:32 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Passenger_Reschedule | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:33 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Passenger_tickets | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 32768 | 0 | 2024-07-03 11:46:32 | NULL | NULL | NULL | NULL | |||
def | PROJECT | Pilot | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-07-03 11:46:36 | NULL | NULL | NULL | NULL |
|