]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_gserver-tag.md
Merge pull request #12407 from HankG/friendica-api-photo-endpoint-updates
[friendica.git] / doc / database / db_gserver-tag.md
index dba65c45aba5d220e95bc566f6d42d851f6fdaa8..82b0ccc881898371965fd675bb4dc179ea552bdc 100644 (file)
@@ -3,9 +3,27 @@ Table gserver-tag
 
 Tags that the server has subscribed
 
+Fields
+------
+
 | Field      | Description                        | Type         | Null | Key | Default | Extra |
 | ---------- | ---------------------------------- | ------------ | ---- | --- | ------- | ----- |
 | gserver-id | The id of the gserver              | int unsigned | NO   | PRI | 0       |       |
 | tag        | Tag that the server has subscribed | varchar(100) | NO   | PRI |         |       |
 
+Indexes
+------------
+
+| Name    | Fields          |
+| ------- | --------------- |
+| PRIMARY | gserver-id, tag |
+| tag     | tag             |
+
+Foreign Keys
+------------
+
+| Field | Target Table | Target Field |
+|-------|--------------|--------------|
+| gserver-id | [gserver](help/database/db_gserver) | id |
+
 Return to [database documentation](help/database)