Table inbox-entry
Incoming activity
Fields
Field |
Description |
Type |
Null |
Key |
Default |
Extra |
id |
sequential ID |
int unsigned |
NO |
PRI |
NULL |
auto_increment |
activity-id |
id of the incoming activity |
varbinary(383) |
YES |
|
NULL |
|
object-id |
|
varbinary(383) |
YES |
|
NULL |
|
in-reply-to-id |
|
varbinary(383) |
YES |
|
NULL |
|
conversation |
|
varbinary(383) |
YES |
|
NULL |
|
type |
Type of the activity |
varchar(64) |
YES |
|
NULL |
|
object-type |
Type of the object activity |
varchar(64) |
YES |
|
NULL |
|
object-object-type |
Type of the object's object activity |
varchar(64) |
YES |
|
NULL |
|
received |
Receiving date |
datetime |
YES |
|
NULL |
|
activity |
The JSON activity |
mediumtext |
YES |
|
NULL |
|
signer |
|
varchar(255) |
YES |
|
NULL |
|
push |
Is the entry pushed or have pulled it? |
boolean |
YES |
|
NULL |
|
trust |
Do we trust this entry? |
boolean |
YES |
|
NULL |
|
wid |
Workerqueue id |
int unsigned |
YES |
|
NULL |
|
Indexes
Name |
Fields |
PRIMARY |
id |
activity-id |
UNIQUE, activity-id |
object-id |
object-id |
received |
received |
wid |
wid |
Foreign Keys
Return to database documentation