querymonitor.pl - Table ID format in tables and tablecol

[eugeneckim]

• Request to adjust table format to be consistent on tables and tablecol.

https://yugabyte.slack.com/archives/C06SS4M0XBJ/p1711904060926739

sqlite>  Select tables.name as tbl, isPartitionKey,  isClusteringKey , columnOrder , sortOrder ,tablecol.name as col   FROM tables left join tablecol on id=replace(tableid,'-','') WHERE tbl like 'custacctrole%';
tbl           isPartitionKey  isClusteringKey  columnOrder  sortOrder  col
------------  --------------  ---------------  -----------  ---------  --------------------
custacctrole  1                                             NONE       custid
custacctrole                  1                1            ASC        acctid
custacctrole                  1                2            ASC        roletitle
custacctrole                                   3            NONE       preferredcontact
custacctrole                                   4            NONE       sequencenumber
custacctrole                                   5            NONE       reportingtaxpayer
custacctrole                                   6            NONE       roledetails
custacctrole                                   7            NONE       lastupdatedtimestamp