]> 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 96a5f02f491f36acc945ab9c17c652131346b198..82b0ccc881898371965fd675bb4dc179ea552bdc 100644 (file)
@@ -1,10 +1,29 @@
 Table gserver-tag
 ===========
+
 Tags that the server has subscribed
 
-| Field | Description | Type | Null | Key | Default | Extra |
-| ----- | ----------- | ---- | ---- | --- | ------- | ----- |
-| gserver-id | The id of the gserver | int unsigned | YES | PRI | 0 |  |    
-| tag | Tag that the server has subscribed | varchar(100) | YES | PRI |  |  |    
+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)