| ... | @@ -64,20 +64,26 @@ user ||--|{ submission |
... | @@ -64,20 +64,26 @@ user ||--|{ submission |
|
|
### Submission
|
|
### Submission
|
|
|
|
|
|
|
|
> Players' photo submissions to the challenge room tasks. Submission table contains the photo's information as well as tasks completion status.
|
|
> Players' photo submissions to the challenge room tasks. Submission table contains the photo's information as well as tasks completion status.
|
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| submissionId \<PK\> | UUID | Submission's id. | Yes |
|
|
| submissionId | UUID | Submission's id. | Yes |
|
|
|
| userId \<FK\> | UUID | User who submitted the submission. | Yes |
|
|
| userId | UUID | User who submitted the submission. | Yes |
|
|
|
| taskId \<FK\> | UUID | Task which the submission was submitted to. | Yes |
|
|
| taskId | UUID | Task which the submission was submitted to. | Yes |
|
|
|
| status | string | Submission's status. Value can be <span dir="">`"Not reviewed"`</span>, <span dir="">`"Approved"`</span>, <span dir="">`"Rejected"`</span> or <span dir="">`"Not submitted"`</span> | Yes |
|
|
| status | string | Submission's status. Value can be <span dir="">`"Not reviewed"`</span>, <span dir="">`"Approved"`</span>, <span dir="">`"Rejected"`</span> or <span dir="">`"Not submitted"`</span> | Yes |
|
|
|
| fileName | string | Submission file's name. | Yes |
|
|
| fileName | string | Submission file's name. | Yes |
|
|
|
| mimeType | string | Submission photo's file format. | No |
|
|
| mimeType | string | Submission photo's file format. | No |
|
|
|
|
|
|
|
|
|
|
|
|
|
### User
|
|
### User
|
|
|
|
|
|
|
|
> User that will be created when the player joins a challenge room. User will always be in a room, and user can be only in one room. Players and gamemasters are in the same User table, separated by the isGameMaster boolean value.
|
|
> User that will be created when the player joins a challenge room. User will always be in a room, and user can be only in one room. Players and gamemasters are in the same User table, separated by the isGameMaster boolean value.
|
|
|
|
| Field | Type | Description | Required |
|
|
|
|
|-------|------|-------------|----------|
|
|
|
|
| userId | UUID | User's id. | Yes |
|
|
|
|
| challengeRoomId | UUID | The challenge room the player is in. | Yes |
|
|
|
|
| userName | string | User's name. | Yes |
|
|
|
|
| isGameMaster | boolean | User's role in challenge room. | Yes |
|
|
|
|
| userAvatar | number | User avatar index number. | No |
|
|
|
|
|
|
|
| Table | Description |
|
|
| Table | Description |
|
|
|
|-------|-------------|
|
|
|-------|-------------|
|
|
|
| User | User that will be created when the player joins a challenge room. User will always be in a room, and user can be only in one room. Players and gamemasters are in the same User table, separated by the isGameMaster boolean value. |
|
|
| User | User that will be created when the player joins a challenge room. User will always be in a room, and user can be only in one room. Players and gamemasters are in the same User table, separated by the isGameMaster boolean value. |
|
| ... | |
... | |
| ... | | ... | |