X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_intro.md;h=da0cbe26ab033a1ac5ec40a50d7398ce8f9ede36;hb=6a7fc07cbfb3d088891b90a873947d31e56d73fc;hp=ed4dd54b690ba9b5eb4365d98957b50470ab0fa0;hpb=96f07c7288a0b9a2433ad66ee6cef21612d90264;p=friendica.git diff --git a/doc/database/db_intro.md b/doc/database/db_intro.md index ed4dd54b69..da0cbe26ab 100644 --- a/doc/database/db_intro.md +++ b/doc/database/db_intro.md @@ -6,28 +6,30 @@ Table intro Fields ------ -| Field | Description | Type | Null | Key | Default | Extra | -| ---------- | ------------- | ------------------ | ---- | --- | ------------------- | -------------- | -| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | -| uid | User id | mediumint unsigned | NO | | 0 | | -| fid | | int unsigned | YES | | NULL | | -| contact-id | | int unsigned | NO | | 0 | | -| knowyou | | boolean | NO | | 0 | | -| duplex | | boolean | NO | | 0 | | -| note | | text | YES | | NULL | | -| hash | | varchar(255) | NO | | | | -| datetime | | datetime | NO | | 0001-01-01 00:00:00 | | -| blocked | | boolean | NO | | 1 | | -| ignore | | boolean | NO | | 0 | | +| Field | Description | Type | Null | Key | Default | Extra | +| ----------- | ----------------- | ------------------ | ---- | --- | ------------------- | -------------- | +| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | +| uid | User id | mediumint unsigned | NO | | 0 | | +| fid | deprecated | int unsigned | YES | | NULL | | +| contact-id | | int unsigned | NO | | 0 | | +| suggest-cid | Suggested contact | int unsigned | YES | | NULL | | +| knowyou | | boolean | NO | | 0 | | +| duplex | | boolean | NO | | 0 | | +| note | | text | YES | | NULL | | +| hash | | varchar(255) | NO | | | | +| datetime | | datetime | NO | | 0001-01-01 00:00:00 | | +| blocked | | boolean | NO | | 1 | | +| ignore | | boolean | NO | | 0 | | Indexes ------------ -| Name | Fields | -|------|---------| -| PRIMARY | id | -| contact-id | contact-id | -| uid | uid | +| Name | Fields | +| ----------- | ----------- | +| PRIMARY | id | +| contact-id | contact-id | +| suggest-cid | suggest-cid | +| uid | uid | Foreign Keys ------------ @@ -36,5 +38,6 @@ Foreign Keys |-------|--------------|--------------| | uid | [user](help/database/db_user) | uid | | contact-id | [contact](help/database/db_contact) | id | +| suggest-cid | [contact](help/database/db_contact) | id | Return to [database documentation](help/database)