X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_fsuggest.md;h=6ccf732971366dd3494fb5b3be2306c37fc97eb7;hb=6d0f6babe3387d16c768fa0f779ee65acde1b5d1;hp=d3a8e21ab58f40b7a1ccc9818b9d6ce589fd270a;hpb=2cd0c1d30d237806e9c3853aa0645f786e31855c;p=friendica.git diff --git a/doc/database/db_fsuggest.md b/doc/database/db_fsuggest.md index d3a8e21ab5..6ccf732971 100644 --- a/doc/database/db_fsuggest.md +++ b/doc/database/db_fsuggest.md @@ -3,6 +3,9 @@ Table fsuggest friend suggestion stuff +Fields +------ + | Field | Description | Type | Null | Key | Default | Extra | | ------- | ----------- | ------------------ | ---- | --- | ------------------- | -------------- | | id | | int unsigned | NO | PRI | NULL | auto_increment | @@ -15,4 +18,21 @@ friend suggestion stuff | note | | text | YES | | NULL | | | created | | datetime | NO | | 0001-01-01 00:00:00 | | +Indexes +------------ + +| Name | Fields | +| ------- | ------ | +| PRIMARY | id | +| cid | cid | +| uid | uid | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uid | [user](help/database/db_user) | uid | +| cid | [contact](help/database/db_contact) | id | + Return to [database documentation](help/database)