public function getTables()
{
$tables = [];
foreach ($this->connection->query('SHOW FULL TABLES') as $row) {
$tables[] = ['name' => $row[0], 'view' => isset($row[1]) && $row[1] === 'VIEW'];
}
return $tables;
}