column_numbering.txt

CREATE TABLE test.table1 (key1 text PRIMARY KEY , value1 text);

 keyspace_name | table_name | column_name | position
---------------+------------+-------------+----------
          test |     table1 |        key1 |       -1
          test |     table1 |      value1 |       -1
          

CREATE TABLE test.table3 (key1 text, value1 text, value2 text, PRIMARY KEY(key1, value1));

 keyspace_name | table_name | column_name | position
---------------+------------+-------------+----------
          test |     table3 |        key1 |       -1
          test |     table3 |      value1 |        0
          test |     table3 |      value2 |       -1
          
 
 CREATE TABLE test.table4 (key1 text, value1 text, value2 text, PRIMARY KEY((key1, value1)));
 
  keyspace_name | table_name | column_name | position
---------------+------------+-------------+----------
          test |     table4 |        key1 |        0
          test |     table4 |      value1 |        1
          test |     table4 |      value2 |       -1