X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_apcontact.md;h=578df57bfdaddfb5057375facf69410ea1dfdcfb;hb=a145712f042f54c1e4ce657be1ab8c649ea2f6f8;hp=ede71d1d0c8f2e1f43da4b853b8d926ba8087d6d;hpb=2b95a7e7cd76c573b82b2dbcc5ad08b1501ee89b;p=friendica.git diff --git a/doc/database/db_apcontact.md b/doc/database/db_apcontact.md index ede71d1d0c..578df57bfd 100644 --- a/doc/database/db_apcontact.md +++ b/doc/database/db_apcontact.md @@ -9,6 +9,7 @@ Fields | Field | Description | Type | Null | Key | Default | Extra | | ---------------- | ------------------------------------------------------------------- | -------------- | ---- | --- | ------------------- | ----- | | url | URL of the contact | varbinary(255) | NO | PRI | NULL | | +| uri-id | Id of the item-uri table entry that contains the apcontact url | int unsigned | YES | | NULL | | | uuid | | varchar(255) | YES | | NULL | | | type | | varchar(20) | NO | | NULL | | | following | | varchar(255) | YES | | NULL | | @@ -16,11 +17,16 @@ Fields | inbox | | varchar(255) | NO | | NULL | | | outbox | | varchar(255) | YES | | NULL | | | sharedinbox | | varchar(255) | YES | | NULL | | +| featured | Address for the collection of featured posts | varchar(255) | YES | | NULL | | +| featured-tags | Address for the collection of featured tags | varchar(255) | YES | | NULL | | | manually-approve | | boolean | YES | | NULL | | | discoverable | Mastodon extension: true if profile is published in their directory | boolean | YES | | NULL | | +| suspended | Mastodon extension: true if profile is suspended | boolean | YES | | NULL | | | nick | | varchar(255) | NO | | | | | name | | varchar(255) | YES | | NULL | | | about | | text | YES | | NULL | | +| xmpp | XMPP address | varchar(255) | YES | | NULL | | +| matrix | Matrix address | varchar(255) | YES | | NULL | | | photo | | varchar(255) | YES | | NULL | | | header | Header picture | varchar(255) | YES | | NULL | | | addr | | varchar(255) | YES | | NULL | | @@ -47,12 +53,14 @@ Indexes | baseurl | baseurl(190) | | sharedinbox | sharedinbox(190) | | gsid | gsid | +| uri-id | UNIQUE, uri-id | Foreign Keys ------------ | Field | Target Table | Target Field | |-------|--------------|--------------| +| uri-id | [item-uri](help/database/db_item-uri) | id | | gsid | [gserver](help/database/db_gserver) | id | Return to [database documentation](help/database)