Development whiteboard: Difference between revisions

Jump to navigation Jump to search
→‎Content: More tables
(→‎Content: More tables)
Line 309: Line 309:
|
|
|-
|-
|moderated*
|restricted*
|boolean
|boolean
|If true, asset has been restricted by a moderator.
|If true, asset has been restricted by a moderator.
|false
|-
|onsale*
|boolean
|If true, asset is available for sale. If no prices defined, is free
|false
|-
|published*
|boolean
|If false, only visible to the creator (and moderators)
|false
|false
|-
|-
Line 318: Line 328:
|Content type
|Content type
|content
|content
|-
|opensource*
|boolean
|Content is open source - can be downloaded / reused
|false
|-
|license
|text
|Optional license text
|
|-
|-
|created_by
|created_by
Line 327: Line 347:
|FK UUID
|FK UUID
|User id
|User id
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|}
{| class="wikitable"
|+Moderator action
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|Moderation ID
|
|-
|content_id*
|FK int 10
|Content ID
|
|-
|action*
|enum (approve, reject, forward)
|Moderator action
|
|-
|user_id*
|FK UUID
|Moderator user ID
|
|-
|penalty*
|boolean
|Moderator penalized the content author.
For example, banned for illegal content.
|false
|-
|asset_delete*
|boolean
|Moderator ordered the deletion of related assets
from the system.
|true
|-
|rejection_reason
|enum (tos, illegal, dmca, other)
|Rejection reason
|
|-
|description
|text
|Additional information regarding moderator action
|
|
|-
|-
Line 347: Line 426:
|-
|-
|id*
|id*
|PK int 10
|Relation ID
|
|-
|content_id*
|FK int 10
|FK int 10
|Content ID
|Content ID
Line 357: Line 441:
|-
|-
|type*
|type*
|enum <code>(texture, texture3d,</code>  
|enum <code>(image, texture, texture3d,</code>  
<code>mesh, animation, gameobject,</code>
<code>mesh, animation, gameobject,</code>


<code>world, sound)</code>
<code>world, sound)</code>
|Asset ID this content references
|Type of asset
|
|
|-
|type_name
|varchar 255
|Sub-type (preview, icon, etc)
|
|-
|index*
|int 10
|Asset index
|0
|}
|}
{| class="wikitable"
{| class="wikitable"
Line 372: Line 466:
|-
|-
|id*
|id*
|PK int 10
|Relation ID
|
|-
|content_id*
|FK int 10
|FK int 10
|Content ID
|Content ID
Line 384: Line 483:
|enum (whole, denom)
|enum (whole, denom)
|Two-currency system choice
|Two-currency system choice
|
|-
|created_by
|FK UUID
|User id
|
|-
|updated_by
|FK UUID
|User id
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|
|}
|}
Line 403: Line 522:
|private
|private
|-
|-
|published*
|boolean
|
|
|false
|
|
|
|-
|-
|
|
Line 428: Line 547:
|
|
|
|
|
|}
{| class="wikitable"
|+Content ownership relation
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|Relation ID
|
|-
|content_id*
|FK int 10
|Content ID
|
|-
|source*
|enum (author, purchase, trade, gift)
|Obtained by action
|author
|-
|user_id*
|FK UUID
|User ID
|
|-
|previous_ownership_id
|FK int 10
|Previous ownership ID. This is used by the system to track the ownership of items and trace trades.
The previous ownership entity must have its ended_at date set.
|
|-
|purchase_price
|float
|Purchase price
|
|-
|purchase_currency
|enum (whole, denom)
|Purchase price currency
|
|-
|created_by
|FK UUID
|User id
|
|-
|updated_by
|FK UUID
|User id
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|-
|ended_at
|datetime
|Ownership end date and time.
If this is not null, the related user does not own this item anymore.
|
|-
|expires_at
|datetime
|Ownership expiry date and time.
Some items could be purchased for a certain amount of time only.
|
|
|}
|}

Navigation menu