Merge pull request #12407 from HankG/friendica-api-photo-endpoint-updates

[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 80bd5f196bcdf55262f2d76e46a8e60ec2c818e7..4ac432590976cb2d03d3c0255661e944420e582b 100644 (file)
--- a/doc/database/db_diaspora-interaction.md
+++ b/doc/database/db_diaspora-interaction.md
@@ -1,10 +1,28 @@
 Table diaspora-interaction
 ===========
+
 Signed Diaspora Interaction
 
-| 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 |  |    
+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)