public $Column_name; // Column_name - The column name. See also the description for the Expression column.
10
public $Seq_in_index; // The column sequence number in the index, starting with 1.
11
public $Collation; // How the column is sorted in the index. This can have values A (ascending), D (descending), or NULL (not sorted).
12
public $Cardinality; // An estimate of the number of unique values in the index. To update this number, run ANALYZE TABLE or (for MyISAM tables) myisamchk -a.
13
public $Sub_part; // The index prefix. That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed.
14
public $Null; // Contains YES if the column may contain NULL values and '' if not.
15
public $Expression; // MySQL 8.0.13 and higher supports functional key parts (see Functional Key Parts), which affects both the Column_name and Expression columns: