mina icon indicating copy to clipboard operation
mina copied to clipboard

Review archive schema, strengthen constraints

Open georgeee opened this issue 1 year ago • 0 comments

Schema doesn't strictly reflect Mina's specifics

For example:

"blocks_user_commands_pkey" PRIMARY KEY, btree (block_id, user_command_id, sequence_no)

This primary key allows same user command to be associated with the same block a few times (whereas in practice it's at most once).

There are a few more constraints like that which could be strengthened

georgeee avatar Feb 14 '24 21:02 georgeee