How can I arrange database structure for ranking card in a list in a Kanban Board?

thank you for helping me. I got a problem when I design my database structure for kanban board application. How can I design kanban board to rank card in a list for sorting,drag and drop,.. Currently this is my design 1. cards table -id (P) -list_id -name -title ??? (How to design for ranking cards in list for sorting, drag and drop in list) 2. card_lists table -id (P) -board_id -name ?? (How to design for ranking status card list in boards for sorting, drag and drop in board) 3. boards table -id -name Imagine I am doing the card movement function in the kanban board, (move in the list or move from one list to another). I'm having a problem using a weight as an metric that determines the order of cards in a list. The more we move the card, the more number of decimal digits of the weight => Leads to the data type: FLOAT or DOUBLE cannot be saved correctly (divide and divide and divide,... ) So is there any way to overcome this problem and is there a better way to calculate the weight to store in the database? Thank you so much for your help