src/Model/Dao/MysqlSchemaDao.php
public function getColumnsSchema(string $db, string $table): array
    {
        $query   = Query::table('information_schema.`columns`')->where('TABLE_SCHEMA', $db)->where('TABLE_NAME', $table);
        $columns = [
            'COLUMN_NAME'              => 'name',
            'DATA_TYPE'                => 'type',
            'COLUMN_DEFAULT'           => 'default',
            'COLUMN_KEY'               => 'key',
            'IS_NULLABLE'              => 'nullable',
            'COLUMN_TYPE'              => 'columnType',
            'COLUMN_COMMENT'           => 'columnComment',
            'CHARACTER_MAXIMUM_LENGTH' => 'length',
        ];

        return $query->get($columns)->getResult();
    }
public function getColumnsSchema(string $db, string $table): array
    {
        $query   = Query::table('information_schema.`columns`')->where('TABLE_SCHEMA', $db)->where('TABLE_NAME', $table);
        $columns = [
            'COLUMN_NAME'              => 'name',
            'DATA_TYPE'                => 'type',
            'COLUMN_DEFAULT'           => 'default',
            'COLUMN_KEY'               => 'key',
            'IS_NULLABLE'              => 'nullable',
            'COLUMN_TYPE'              => 'columnType',
            'COLUMN_COMMENT'           => 'columnComment',
            'CHARACTER_MAXIMUM_LENGTH' => 'length',
        ];

        return $query->get($columns)->getResult();
    }
@param string $db
@param string $table

@return array