]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_inbox-entry.md
Merge pull request #12593 from nupplaphil/feat/node.config.php
[friendica.git] / doc / database / db_inbox-entry.md
index 91126919e919871904211eda86cb7207692e58c0..834d4bfd647279706160f32569452f578ceaae6d 100644 (file)
@@ -6,20 +6,22 @@ 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(255) | YES  |     | NULL    |                |
-| object-id          |                                      | varbinary(255) | YES  |     | NULL    |                |
-| in-reply-to-id     |                                      | varbinary(255) | 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               |                                      | boolean        | NO   |     | 0       |                |
-| wid                | Workerqueue id                       | int unsigned   | YES  |     | NULL    |                |
+| 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
 ------------