-
Notifications
You must be signed in to change notification settings - Fork 2
BD Table: pvmsg
Cedric AUDRIT edited this page Dec 9, 2020
·
2 revisions
| COLUMN | TYPE (MYSQL) | CONTENT |
|---|---|---|
| pvmsg_id | int | primary key |
| pvmsg_action | varchar(32) | SEND or REC |
| pvmsg_content | text | message content |
| pvmsg_from | int | author/sender of the message (user ID) |
| pvmsg_to | int | receiver of the message (user ID) |
| pvmsg_read | int | 0=unread, 1=read |
| pvmsg_disc | varchar(32) | id of discussion between 2 persons |
| pvmsg_date | datetime | CURRENT_TIMESTAMP |
| pvmsg_inbox | int | user_id inbox |