php Programming Glossary: erd

Need help understanding Doctrine many to many self referencing code

http://stackoverflow.com/questions/3290319/need-help-understanding-doctrine-many-to-many-self-referencing-code

you are a teacher. when u ask u are a student the ERD will look like some code to select students of teachers teachers..

Bulletin board - Database optimisation

http://stackoverflow.com/questions/4310769/bulletin-board-database-optimisation

Nil Data Model Ok assuming you do not have issues with the ERD and implementing all Closed Issues I have modelled the data..

Creating a threaded private messaging system like facebook and gmail

http://stackoverflow.com/questions/6420264/creating-a-threaded-private-messaging-system-like-facebook-and-gmail

it can do double duty as your read status table. EDIT ERD Sketch Here is a quick sketch of what I'm talking about... Whether.. when the recipient reads the message. EDIT 2 Alternate ERD and Querying for Most Recent Message @OP asked how to query.. specific parent unless it's the root of the thread. In the ERD above the reply_to_message_id field could be used either way...