67
edits
Development whiteboard: Difference between revisions
→Content
| Line 307: | Line 307: | ||
|FK UUID | |FK UUID | ||
|Creator ID | |Creator ID | ||
| | |||
|- | |||
|parent_id | |||
|FK int 10 | |||
|Parent content ID | |||
| | | | ||
|- | |- | ||
| Line 326: | Line 331: | ||
|type* | |type* | ||
|enum | |enum | ||
|Content type | |Content type. | ||
* Generic: content | |||
* Character items: character, hat, accessory, front, back, tool | |||
* Creator items: mesh, texture, gameobject, sound, animation | |||
* Comments: comment | |||
* Games: game, world | |||
|content | |content | ||
|- | |- | ||
| Line 422: | Line 433: | ||
| | | | ||
| | | | ||
|- | |||
| colspan="4" |M2M relation with bans | |||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
| Line 633: | Line 646: | ||
Some items could be purchased for a certain amount of time only. | Some items could be purchased for a certain amount of time only. | ||
| | | | ||
|} | |||
{| class="wikitable" | |||
|+Content vote | |||
!Key | |||
!Type | |||
!Description | |||
!Default | |||
|- | |||
|id* | |||
|PK int 10 | |||
|Relation ID | |||
| | |||
|- | |||
|content_id* | |||
|FK int 10 | |||
|Content ID | |||
| | |||
|- | |||
|user_id* | |||
|FK UUID | |||
|User ID | |||
| | |||
|- | |||
|vote* | |||
|enum (up, down) | |||
|Up or down vote | |||
| | |||
|- | |||
|created_at | |||
|datetime | |||
| | |||
| | |||
|- | |||
|updated_at | |||
|datetime | |||
| | |||
| | |||
|} | |||
{| class="wikitable" | |||
|+Content report | |||
!Key | |||
!Type | |||
!Description | |||
!Default | |||
|- | |||
|id* | |||
|PK int 10 | |||
|Relation ID | |||
| | |||
|- | |||
|content_id* | |||
|FK int 10 | |||
|Content ID | |||
| | |||
|- | |||
|user_id* | |||
|FK UUID | |||
|User ID | |||
| | |||
|- | |||
|moderator_id | |||
|FK UUID | |||
|Moderator ID | |||
| | |||
|- | |||
|reason* | |||
|text | |||
|Report reason | |||
| | |||
|- | |||
|description* | |||
|text | |||
|Report description | |||
| | |||
|- | |||
|status* | |||
|enum (open, closed, invalid, resolved) | |||
|Moderator's resolution | |||
|open | |||
|- | |||
|notes | |||
|text | |||
|Moderator's notes | |||
| | |||
|- | |||
|created_at | |||
|datetime | |||
| | |||
| | |||
|- | |||
|updated_at | |||
|datetime | |||
| | |||
| | |||
|- | |||
|resolved_at | |||
|datetime | |||
| | |||
| | |||
|- | |||
| colspan="4" |M2M relation with moderator action | |||
|} | |} | ||