Table notification
notifications
Fields
Field |
Description |
Type |
Null |
Key |
Default |
Extra |
id |
sequential ID |
int unsigned |
NO |
PRI |
NULL |
auto_increment |
uid |
Owner User id |
mediumint unsigned |
YES |
|
NULL |
|
vid |
Id of the verb table entry that contains the activity verbs |
smallint unsigned |
YES |
|
NULL |
|
type |
|
smallint unsigned |
YES |
|
NULL |
|
actor-id |
Link to the contact table with uid=0 of the actor that caused the notification |
int unsigned |
YES |
|
NULL |
|
target-uri-id |
Item-uri id of the related post |
int unsigned |
YES |
|
NULL |
|
parent-uri-id |
Item-uri id of the parent of the related post |
int unsigned |
YES |
|
NULL |
|
created |
|
datetime |
YES |
|
NULL |
|
seen |
Seen on the desktop |
boolean |
YES |
|
0 |
|
dismissed |
Dismissed via the API |
boolean |
YES |
|
0 |
|
Indexes
Name |
Fields |
PRIMARY |
id |
uid_vid_type_actor-id_target-uri-id |
UNIQUE, uid, vid, type, actor-id, target-uri-id |
vid |
vid |
actor-id |
actor-id |
target-uri-id |
target-uri-id |
parent-uri-id |
parent-uri-id |
seen_uid |
seen, uid |
uid_type_parent-uri-id_actor-id |
uid, type, parent-uri-id, actor-id |
Foreign Keys
Return to database documentation