2019-02-05 01:49:38 UTC
For our application, we now want to introduce the concept of "Do Not
Show This Again" tickboxes on popup dialogs. I need to store and
retrieve these from the database. I am looking for suggestions on how
they should be stored.
The values will need to be stored against a user, for which we have a
foreign key. I will provide stored procs for accessing these values -
read and update. Options I had were: -
1. Single table, dual PK of Flag ID and User ID, with a single bit
field to hold the value - non-existance will be considered as false. We
could also have a string field to provide a description of what the
flag is. Or perhaps better would be a linked table for the flag
2. Single table, PKID of User ID, with a lot of bit fields for the
values - I hold a manual spreadsheet of what column is what flag, and
simply tell the developers which column to use when they request a new
3. Single table, PKID of User ID, with a bit-masked long integer for
values - I hold a manual spreadsheet of what column is what bitmask,
and simply tell the developers which number to pass when they request a
Obviously, the number of flags is uncertain, and will increment as the
developers request new flags for new functionality, but the table
itself does not need to be that clear in its operation, and it is
purely a behind-the-scenes operation.
Has anyone done this before, and what basic structure did you use?