Ask someone to tell me how the messaging board in the QQ space is designed.

How is the database designed for the message board in the QQ space? I don't know the database design of the QQ space? Can any friend reply infinitely ?, Reply ID & nbsp; reply_id?
I don't know the database design of the QQ space? Can any friend receive an unlimited number of replies?



------ Solution --------------------
Reply ID reply_id,
Post ID note_id,
Parent ID parent_id of the reply ID

Not afraid of buildings in the building, as long as the ownership is marked clear
------ Solution --------------------
The adjacent list and the pre-order traversal can all be modified.
------ Solution --------------------
Id, whether posted or replied, each post must be uniquely identified.
Id of the pid to be replied

The link is complete. just traverse the number.

Extension:
Mid Post id, which can narrow the search range

Pre-order: pre-order traversal, also known as left and right values, records the start and end IDs of a post.
Median sorting: it is derived from the "one-foot-length" of Zhuangzi, which takes half a day and is inexhaustible. However, because a computer can only represent a limited number, it cannot be "unlimited"