Xqlite.Schema.IndexColumnInfo (Xqlite v0.7.0)
View SourceInformation about a specific column within an index, corresponding to PRAGMA index_xinfo.
Summary
Types
@type t() :: %Xqlite.Schema.IndexColumnInfo{ collation: String.t(), index_column_sequence: integer(), is_key_column: boolean(), name: String.t() | nil, sort_order: Xqlite.Schema.Types.sort_order(), table_column_id: integer() }
Struct definition.
:index_column_sequence- 0-based position of this column within the index key/definition.:table_column_id- The ID (0-based index) of the column in the base table definition, corresponding to thecidfromPRAGMA table_info. A value of-1indicates that the indexed item is an expression, not a direct table column.:name- Name of the table column included in the index, ornilif the index is on an expression.:sort_order- Sort order for this column (:ascor:desc).:collation- Name of the collation sequence used for this column (e.g., "BINARY", "NOCASE", "RTRIM").:is_key_column-trueif this column is part of the primary index key used for lookups.falseif it's an "included" column (only stored in the index, part of covering indexes, SQLite >= 3.9.0).