X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_intro.md;h=da6dc849eaea146ba2c0fbf40c9f6f6526d40206;hb=d26b0ed5a2b5cd66954816096ba87c05043826f0;hp=426d8579ddb00cf181eb8a1ce5c2815d03c71025;hpb=2b95a7e7cd76c573b82b2dbcc5ad08b1501ee89b;p=friendica.git diff --git a/doc/database/db_intro.md b/doc/database/db_intro.md index 426d8579dd..da6dc849ea 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 | deprecated | boolean | NO | | 0 | | +| note | | text | YES | | NULL | | +| hash | | varbinary(255) | NO | | | | +| datetime | | datetime | NO | | 0001-01-01 00:00:00 | | +| blocked | deprecated | boolean | NO | | 0 | | +| 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)