X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_conversation.md;h=504b0dd4ae1c96bc125dc2865d1cec57ae03d939;hb=7224c0fc38d340447cd79ad6b7ebebc722d9627c;hp=212d2a76e35f076c237919fcd9fe6ed78bf550b4;hpb=4095e6c9be01943c3b074d9a9061a01ff5fafcee;p=friendica.git diff --git a/doc/database/db_conversation.md b/doc/database/db_conversation.md index 212d2a76e3..504b0dd4ae 100644 --- a/doc/database/db_conversation.md +++ b/doc/database/db_conversation.md @@ -1,16 +1,30 @@ Table conversation =========== + Raw data and structure information for messages -| Field | Description | Type | Null | Key | Default | Extra | -| ----- | ----------- | ---- | ---- | --- | ------- | ----- | -| item-uri | Original URI of the item - unrelated to the table with the same name | varbinary(255) | NO | PRI | NULL | | -| reply-to-uri | URI to which this item is a reply | varbinary(255) | NO | | | | -| conversation-uri | GNU Social conversation URI | varbinary(255) | NO | | | | -| conversation-href | GNU Social conversation link | varbinary(255) | NO | | | | -| protocol | The protocol of the item | tinyint unsigned | NO | | 255 | | -| direction | How the message arrived here: 1=push, 2=pull | tinyint unsigned | NO | | 0 | | -| source | Original source | mediumtext | YES | | NULL | | -| received | Receiving date | datetime | NO | | 0001-01-01 00:00:00 | | +Fields +------ + +| Field | Description | Type | Null | Key | Default | Extra | +| ----------------- | -------------------------------------------------------------------- | ---------------- | ---- | --- | ------------------- | ----- | +| item-uri | Original URI of the item - unrelated to the table with the same name | varbinary(255) | NO | PRI | NULL | | +| reply-to-uri | URI to which this item is a reply | varbinary(255) | NO | | | | +| conversation-uri | GNU Social conversation URI | varbinary(255) | NO | | | | +| conversation-href | GNU Social conversation link | varbinary(255) | NO | | | | +| protocol | The protocol of the item | tinyint unsigned | NO | | 255 | | +| direction | How the message arrived here: 1=push, 2=pull | tinyint unsigned | NO | | 0 | | +| source | Original source | mediumtext | YES | | NULL | | +| received | Receiving date | datetime | NO | | 0001-01-01 00:00:00 | | + +Indexes +------------ + +| Name | Fields | +| ---------------- | ---------------- | +| PRIMARY | item-uri | +| conversation-uri | conversation-uri | +| received | received | + Return to [database documentation](help/database)