X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_report.md;h=7157224314e9498ca46467565d3fa7046cb8ba03;hb=4e3302ea0d157c6921de9d73f8b00e2ebd08e845;hp=d143839990d4dd149d9eda89469f48b98ed9c7d7;hpb=c822d5fa945e9b323f28c776c51fa4635ce5f04c;p=friendica.git diff --git a/doc/database/db_report.md b/doc/database/db_report.md index d143839990..7157224314 100644 --- a/doc/database/db_report.md +++ b/doc/database/db_report.md @@ -6,24 +6,24 @@ Table report Fields ------ -| Field | Description | Type | Null | Key | Default | Extra | -| --------------- | ------------------------------------------------------------ | ------------------ | ---- | --- | ------------------- | -------------- | -| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | -| uid | Reporting user | mediumint unsigned | YES | | NULL | | -| reporter-id | Reporting contact | int unsigned | YES | | NULL | | -| cid | Reported contact | int unsigned | NO | | NULL | | -| gsid | Reported contact server | int unsigned | NO | | NULL | | -| comment | Report | text | YES | | NULL | | -| category-id | Report category, one of Entity\Report::CATEGORY_* | int unsigned | NO | | 1 | | -| forward | Forward the report to the remote server | boolean | YES | | NULL | | -| public-remarks | Remarks shared with the reporter | text | YES | | NULL | | -| private-remarks | Remarks shared with the moderation team | text | YES | | NULL | | -| last-editor-uid | Last editor user | mediumint unsigned | YES | | NULL | | -| assigned-uid | Assigned moderator user | mediumint unsigned | YES | | NULL | | -| status | Status of the report, one of Entity\Report::STATUS_* | tinyint unsigned | NO | | NULL | | -| resolution | Resolution of the report, one of Entity\Report::RESOLUTION_* | tinyint unsigned | YES | | NULL | | -| created | | datetime(6) | NO | | 0001-01-01 00:00:00 | | -| edited | Last time the report has been edited | datetime(6) | YES | | NULL | | +| Field | Description | Type | Null | Key | Default | Extra | +| --------------- | ------------------------------------------------------------ | ------------------ | ---- | --- | -------------------------- | -------------- | +| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment | +| uid | Reporting user | mediumint unsigned | YES | | NULL | | +| reporter-id | Reporting contact | int unsigned | YES | | NULL | | +| cid | Reported contact | int unsigned | NO | | NULL | | +| gsid | Reported contact server | int unsigned | YES | | NULL | | +| comment | Report | text | YES | | NULL | | +| category-id | Report category, one of Entity Report::CATEGORY_* | int unsigned | NO | | 1 | | +| forward | Forward the report to the remote server | boolean | YES | | NULL | | +| public-remarks | Remarks shared with the reporter | text | YES | | NULL | | +| private-remarks | Remarks shared with the moderation team | text | YES | | NULL | | +| last-editor-uid | Last editor user | mediumint unsigned | YES | | NULL | | +| assigned-uid | Assigned moderator user | mediumint unsigned | YES | | NULL | | +| status | Status of the report, one of Entity Report::STATUS_* | tinyint unsigned | NO | | NULL | | +| resolution | Resolution of the report, one of Entity Report::RESOLUTION_* | tinyint unsigned | YES | | NULL | | +| created | | datetime(6) | NO | | 0001-01-01 00:00:00.000000 | | +| edited | Last time the report has been edited | datetime(6) | YES | | NULL | | Indexes ------------