X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_delayed-post.md;h=b792f2f00575ba4cd58bd1a6cd8bdbdb4c39586e;hb=a2532ad7554602d631d9caabb5c74564328d1fff;hp=0f1c2f5cf11e769238ec95fb7272705c0bc1e364;hpb=2cd0c1d30d237806e9c3853aa0645f786e31855c;p=friendica.git diff --git a/doc/database/db_delayed-post.md b/doc/database/db_delayed-post.md index 0f1c2f5cf1..b792f2f005 100644 --- a/doc/database/db_delayed-post.md +++ b/doc/database/db_delayed-post.md @@ -3,11 +3,32 @@ Table delayed-post Posts that are about to be distributed at a later time +Fields +------ + | Field | Description | Type | Null | Key | Default | Extra | | ------- | ---------------------------------------------- | ------------------ | ---- | --- | ------- | -------------- | | id | | int unsigned | NO | PRI | NULL | auto_increment | | uri | URI of the post that will be distributed later | varchar(255) | YES | | NULL | | | uid | Owner User id | mediumint unsigned | YES | | NULL | | | delayed | delay time | datetime | YES | | NULL | | +| wid | Workerqueue id | int unsigned | YES | | NULL | | + +Indexes +------------ + +| Name | Fields | +| ------- | --------------------- | +| PRIMARY | id | +| uid_uri | UNIQUE, uid, uri(190) | +| wid | wid | + +Foreign Keys +------------ + +| Field | Target Table | Target Field | +|-------|--------------|--------------| +| uid | [user](help/database/db_user) | uid | +| wid | [workerqueue](help/database/db_workerqueue) | id | Return to [database documentation](help/database)