X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_conv.md;h=c1d50b5de587feeca1a4db8f4969d8b85e05c268;hb=1138abe9237b9db1cf8a0ac7925de9bb55923cdb;hp=11bd7ac13d4548feb0d21be5037b906684b01897;hpb=2cd0c1d30d237806e9c3853aa0645f786e31855c;p=friendica.git diff --git a/doc/database/db_conv.md b/doc/database/db_conv.md index 11bd7ac13d..c1d50b5de5 100644 --- a/doc/database/db_conv.md +++ b/doc/database/db_conv.md @@ -3,6 +3,9 @@ Table conv private messages +Fields +------ + | Field | Description | Type | Null | Key | Default | Extra | | ------- | ----------------------------------------- | ------------------ | ---- | --- | ------------------- | -------------- | | id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | @@ -14,4 +17,19 @@ private messages | updated | edited timestamp | datetime | NO | | 0001-01-01 00:00:00 | | | subject | subject of initial message | text | YES | | NULL | | +Indexes +------------ + +| Name | Fields | +| ------- | ------ | +| PRIMARY | id | +| uid | uid | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uid | [user](help/database/db_user) | uid | + Return to [database documentation](help/database)