Skip to content

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

Foreign Keys#

Field Target Table Target Field
uid user uid
vid verb id
actor-id contact id
target-uri-id item-uri id
parent-uri-id item-uri id

Return to database documentation