Sample Header Ad - 728x90

Create a category column or a table for each category?

-1 votes
1 answer
178 views
Which is better?
Table: Words
Columns: ID, Word, ParentWordID, CatID

Table: Categories
Columns: CatID, Category
Or:
Table: Words
Columns: ID, Word

Table: Categories
Columns: CatID, Categories

Table: Cat1
Columns: WordID
...
Table: CatN
Columns: WordID
One possible advantage for the 2nd option is that not all
need to have a
. But the same could be said for
, which is empty most of the time. Maybe that too could be replaced with a
table and a table for each
?
Asked by simpatico (99 rep)
Apr 5, 2024, 07:07 PM
Last activity: Apr 5, 2024, 07:54 PM