I am just doing some testing and I have created a table called "users" with id, name and email columns where the email column is set to unique. I have tested that insertion of data into the database, indeed. follows the unique constraint correctly and SQLite Browsers shows in the code view that UNIQUE"email") is set but the checkbox does not reflect that constraint.

Here is a screenshot for reference:

Is this a bug or is this how the interface should work? I wanted to check my understanding of what is going on before digging in further.

Thanks.