X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_post-collection.md;h=a0197e66bc39fb4d39a5ee2d2ebf0960408a1e43;hb=a275f0a719c605e358334833a3a9d49a310f2389;hp=3018067c8dc351e4877cfa014803c954c6e073ba;hpb=9339d4e53b8ce18031d488504a03bba662057dec;p=friendica.git diff --git a/doc/database/db_post-collection.md b/doc/database/db_post-collection.md index 3018067c8d..a0197e66bc 100644 --- a/doc/database/db_post-collection.md +++ b/doc/database/db_post-collection.md @@ -6,18 +6,20 @@ Collection of posts 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 | | -| type | 0 - Featured | tinyint unsigned | NO | PRI | 0 | | +| 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 | | +| type | 0 - Featured | tinyint unsigned | NO | PRI | 0 | | +| author-id | Author of the featured post | int unsigned | YES | | NULL | | Indexes ------------ -| Name | Fields | -| ------- | ------------ | -| PRIMARY | uri-id, type | -| type | type | +| Name | Fields | +| --------- | ------------ | +| PRIMARY | uri-id, type | +| type | type | +| author-id | author-id | Foreign Keys ------------ @@ -25,5 +27,6 @@ Foreign Keys | Field | Target Table | Target Field | |-------|--------------|--------------| | uri-id | [item-uri](help/database/db_item-uri) | id | +| author-id | [contact](help/database/db_contact) | id | Return to [database documentation](help/database)