sql - Why should i use 1 table instead of two? -


I have two tables (up | down), you can lift and down the two, so it There is a table bool People suggest that I should use a table in the name of the votes and a field type should be typed.

Why should I do this? I think it is easy to type unique table names, then vote, then enter additional statement where (type & amp; upOrDownTypeBit) & lt; & Gt; 0 .

Note:) Voting Table PK ID, FK User ID

Does a person both a UPvote and a DOWNvote? If not, two tables do not have meaning. Apart from this, you have to write two questions to remove votes; Is it still worth it for each table?


Comments