Development whiteboard: Difference between revisions

Jump to navigation Jump to search

Development whiteboard (view source)

Revision as of 10:50, 14 July 2023

2,059 bytes added ,  14 July 2023
no edit summary
(→‎Content: comments)
No edit summary
Line 348: Line 348:
* Character items: character, hat, accessory, front, back, tool
* Character items: character, hat, accessory, front, back, tool
* Creator items: mesh, texture, gameobject, sound, animation
* Creator items: mesh, texture, gameobject, sound, animation
* Comments: comment
* Comments: comment, status
* Games: game, world
* Games: game, world
|content
|content
Line 650: Line 650:
|Ownership expiry date and time.
|Ownership expiry date and time.
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"
|+Favorite
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|Relation ID
|
|-
|content_id*
|FK int 10
|Content ID
|
|-
|user_id*
|FK UUID
|User ID
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|
|}
|}
Line 755: Line 787:


=== Game microservice ===
=== Game microservice ===
Game feature flags.
{| class="wikitable"
{| class="wikitable"
|+Game
|+Game
Line 813: Line 846:
|
|
|}
|}
=== Server microservice ===
Manages servers.
{| class="wikitable"
{| class="wikitable"
|+Hosted game server
|+Hosted game server
Line 997: Line 1,033:


=== Session microservice ===
=== Session microservice ===
Manages sessions.


==== Session ====
==== Session ====
Line 1,055: Line 1,092:
|datetime
|datetime
|Session keepalive ping
|Session keepalive ping
|
|}
=== Player microservice ===
==== Character ====
{| class="wikitable"
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|
|
|-
|user_id*
|FK UUID
|User ID
|
|-
|content_id*
|FK int 10
|Character content type ID
|
|-
|name
|text
|Character name
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|}
{| class="wikitable"
|+Character properties
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|
|
|-
|character_id
|FK int 10
|Character ID
|
|-
|property*
|varchar 255
|Character Property
|
|-
|value*
|text
|Property Value
|
|-
|value_type*
|enum
|Property Value type
|
|-
|related_content_id
|FK int 10
|Content ID
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|}
{| class="wikitable"
|+Character worn item
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|
|
|-
|character_id
|FK int 10
|Character ID
|
|-
|content_id
|FK int 10
|Content ID
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|}
==== Friends ====
{| class="wikitable"
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|
|
|-
|user_id*
|FK UUID
|User ID (Requester)
|
|-
|target_id*
|FK UUID
|Second user ID
|
|-
|pending*
|boolean
|Is pending request
|true
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|}
==== Follow ====
{| class="wikitable"
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|
|
|-
|user_id*
|FK UUID
|User ID (Follower)
|
|-
|target_id*
|FK UUID
|Second user ID  (Followee)
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|}
==== Block ====
{| class="wikitable"
!Key
!Type
!Description
!Default
|-
|id*
|PK int 10
|
|
|-
|user_id*
|FK UUID
|User ID (Blocker)
|
|-
|target_id*
|FK UUID
|Second user ID  (Blockee)
|
|-
|created_at
|datetime
|
|
|-
|updated_at
|datetime
|
|
|
|}
|}
Retrieved from "https://wiki.freeblox.icynet.eu/index.php/Special:MobileDiff/44"

Navigation menu