Article From:https://segmentfault.com/q/1010000012146580
Question:
Now we need to develop an article classification function. At present, there is a tentative three level classification. Considering the scalability of the classification, the table structure is designed as follows:
| field | type |
|---|---|
| id | char(32) |
| name | varcahr(50) |
| parentId | char(32) |
The question now is whether we need to save another hierarchical relationship, that is, to save the path, or to keep the depth of the tree.
Answer 0:
The article table:
id name type_id
Article ID name is classified as IDClassification table:
id name parent_id
Classified ID classification name classification of parent IDAnother way is to pull the type_id out of a table in the article to make a relational table.
art_id type_id Personal comparison recommends second ways to store the relationship separately and facilitate maintenance.
Link of this Article: How to design the data table structure of the classification table