Block item transactions, table, step index, sort order

[paul-griffith]

@dis

One of these fields is the recipe step number. However, this field is not unique and it’s also not an integer (float).

JOINing two tables in an INSERT INTO

Is it actually a REAL? That's almost certainly not what you want. Just because a reason code happens to be something like digits.digits, doesn't mean you should represent it with REAL. If you do, then how do you distinguish between 123.1 and 123.10 and 123.100?

This should probably be a string (if your intention is to store basically a top level + sublevel key)... though, really, there's an argument for two columns - step and substep or whatever. That also makes ordering trivial in either SQL or Python.