X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_conv.md;h=69815fae7db6e11408b9b464f21406975700f539;hb=0ba111d99ca06c523cedf8aa1609ef328ef0428a;hp=f53918291e7c50dd3929b499f09881d418136d28;hpb=3d74d0a49c07162f6745e9576139a4823bb2af9d;p=friendica.git diff --git a/doc/database/db_conv.md b/doc/database/db_conv.md index f53918291e..69815fae7d 100644 --- a/doc/database/db_conv.md +++ b/doc/database/db_conv.md @@ -9,7 +9,7 @@ Fields | Field | Description | Type | Null | Key | Default | Extra | | ------- | ----------------------------------------- | ------------------ | ---- | --- | ------------------- | -------------- | | id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | -| guid | A unique identifier for this conversation | varchar(255) | NO | | | | +| guid | A unique identifier for this conversation | varbinary(255) | NO | | | | | recips | sender_handle;recipient_handle | text | YES | | NULL | | | uid | Owner User id | mediumint unsigned | NO | | 0 | | | creator | handle of creator | varchar(255) | NO | | | | @@ -20,10 +20,10 @@ Fields Indexes ------------ -| Name | Fields | -|------|--------| -| PRIMARY | id | -| uid | uid | +| Name | Fields | +| ------- | ------ | +| PRIMARY | id | +| uid | uid | Foreign Keys ------------