Development whiteboard: Difference between revisions

Jump to navigation Jump to search
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
|}
|}

Navigation menu