when a user reactions to a message, if another user has already reacted with that same emoji, the new reaction is assigned the same created_at as the original reaction. this preserves order if the original reacter removes their reaction, but the actual creation time of all but the first reaction is destroyed. this would be easy enough to resolve by adding another column to the table, but i should decided if the additional storage and logic is worth the benefit
will i ever need to know when a second emoji was actually created, or who the first user to react with a specific emoji to a reaction was.
when a user reactions to a message, if another user has already reacted with that same emoji, the new reaction is assigned the same created_at as the original reaction. this preserves order if the original reacter removes their reaction, but the actual creation time of all but the first reaction is destroyed. this would be easy enough to resolve by adding another column to the table, but i should decided if the additional storage and logic is worth the benefit
will i ever need to know when a second emoji was actually created, or who the first user to react with a specific emoji to a reaction was.