Merge pull request #11780 from annando/untrusted

[friendica.git] / doc / database / db_diaspora-interaction.md

diff --git a/doc/database/db_diaspora-interaction.md b/doc/database/db_diaspora-interaction.md
index 503c846fd96da8ea73d985dc37653e4aea152410..4ac432590976cb2d03d3c0255661e944420e582b 100644 (file)
--- a/doc/database/db_diaspora-interaction.md
+++ b/doc/database/db_diaspora-interaction.md
@@ -3,9 +3,26 @@ Table diaspora-interaction
 
 Signed Diaspora Interaction
 
+Fields
+------
+
 | Field       | Description                                               | Type         | Null | Key | Default | Extra |
 | ----------- | --------------------------------------------------------- | ------------ | ---- | --- | ------- | ----- |
 | uri-id      | Id of the item-uri table entry that contains the item uri | int unsigned | NO   | PRI | NULL    |       |
 | interaction | The Diaspora interaction                                  | mediumtext   | YES  |     | NULL    |       |
 
+Indexes
+------------
+
+| Name    | Fields |
+| ------- | ------ |
+| PRIMARY | uri-id |
+
+Foreign Keys
+------------
+
+| Field | Target Table | Target Field |
+|-------|--------------|--------------|
+| uri-id | [item-uri](help/database/db_item-uri) | id |
+
 Return to [database documentation](help/database)