CodingForums.com - View Single Post

Fou-Lu · 10-04-2012, 03:27 PM

That's the easy part, it can be as simple as:

Code:

+-----------------------+
| PrivateMessage        |
+-----------------------+
| fromUser [PK][FK]     |
| toUser [PK][FK]       |
| sentDateTime [PK]     |
| message               |
+-----------------------+

Where fromUser and toUser are foreign keys to the user table. Then you simply select based on the current user. toUser would be in, and fromUser would be sent.

10-04-2012, 03:27 PM	PM User \| #2
Fou-Lu God Emperor Join Date: Sep 2002 Location: Saskatoon, Saskatchewan Posts: 15,662 Thanks: 4 Thanked 2,452 Times in 2,421 Posts	That's the easy part, it can be as simple as: Code: +-----------------------+ \| PrivateMessage \| +-----------------------+ \| fromUser [PK][FK] \| \| toUser [PK][FK] \| \| sentDateTime [PK] \| \| message \| +-----------------------+ Where fromUser and toUser are foreign keys to the user table. Then you simply select based on the current user. toUser would be in, and fromUser would be sent.