X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_conv.md;h=bcea6012d6f3dcfe30e858b2a68fe9d5c55e7c2e;hb=84ab5d61594ed92e0e28415d6c33df267a3636c5;hp=f70191b88e5e1df42c8d1e62c58ddd467e5f2172;hpb=29f7ebe307c22b275466390937b82ccb3820fb1c;p=friendica.git diff --git a/doc/database/db_conv.md b/doc/database/db_conv.md index f70191b88e..bcea6012d6 100644 --- a/doc/database/db_conv.md +++ b/doc/database/db_conv.md @@ -1,15 +1,16 @@ Table conv -========== +=========== +private messages -| Field | Description | Type | Null | Key | Default | Extra | -| ------- | ----------------------------------------- | ---------------- | ---- | --- | ------------------- | --------------- | -| id | sequential ID | int(10) unsigned | NO | PRI | NULL | auto_increment | -| guid | A unique identifier for this conversation | varchar(64) | NO | | | | -| recips | sender_handle;recipient_handle | mediumtext | NO | | NULL | | -| uid | user_id of the owner of this data | int(11) | NO | MUL | 0 | | -| creator | handle of creator | varchar(255) | NO | | | | -| created | creation timestamp | datetime | NO | | 0001-01-01 00:00:00 | | -| updated | edited timestamp | datetime | NO | | 0001-01-01 00:00:00 | | -| subject | subject of initial message | mediumtext | NO | | NULL | | +| Field | Description | Type | Null | Key | Default | Extra | +| ----- | ----------- | ---- | ---- | --- | ------- | ----- | +| id | sequential ID | int unsigned | YES | PRI | | auto_increment | +| guid | A unique identifier for this conversation | varchar(255) | YES | | | | +| recips | sender_handle;recipient_handle | text | NO | | | | +| uid | Owner User id | mediumint unsigned | YES | | 0 | | +| creator | handle of creator | varchar(255) | YES | | | | +| created | creation timestamp | datetime | YES | | 0001-01-01 00:00:00 | | +| updated | edited timestamp | datetime | YES | | 0001-01-01 00:00:00 | | +| subject | subject of initial message | text | NO | | | | Return to [database documentation](help/database)