| ... | @@ -69,8 +69,8 @@ user ||--|{ submission |
... | @@ -69,8 +69,8 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| :key: userId (PK) | UUID | User's id. | Yes |
|
|
| :key: userId | UUID | User's id. | Yes |
|
|
|
| challengeRoomChallengeRoomId (FK) | UUID | The challenge room the player is in. | Yes |
|
|
| :key2: challengeRoomChallengeRoomId (FK) | UUID | The challenge room the player is in. | Yes |
|
|
|
| userName | string | User's name. | Yes |
|
|
| userName | string | User's name. | Yes |
|
|
|
| isGameMaster | boolean | User's role in challenge room. | Yes |
|
|
| isGameMaster | boolean | User's role in challenge room. | Yes |
|
|
|
| userAvatar | number | User avatar index number. | No |
|
|
| userAvatar | number | User avatar index number. | No |
|
| ... | @@ -82,7 +82,7 @@ user ||--|{ submission |
... | @@ -82,7 +82,7 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| :key: challengeRoomId (PK) | UUID | Challenge room's id. | Yes |
|
|
| :key: challengeRoomId | UUID | Challenge room's id. | Yes |
|
|
|
| roomName | string | Challenge room's name | Yes |
|
|
| roomName | string | Challenge room's name | Yes |
|
|
|
| roomCode | string | 4 characters long passcode. | Yes |
|
|
| roomCode | string | 4 characters long passcode. | Yes |
|
|
|
| roomDescription | string | Challenge room's description | No |
|
|
| roomDescription | string | Challenge room's description | No |
|
| ... | @@ -98,8 +98,8 @@ user ||--|{ submission |
... | @@ -98,8 +98,8 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| :key: taskId(PK) | UUID | Task's id. | Yes |
|
|
| :key: taskId | UUID | Task's id. | Yes |
|
|
|
| challengeRoomChallengeRoomId (FK) | UUID | Task's challenge room's id. | Yes |
|
|
| :key2: challengeRoomChallengeRoomId | UUID | Task's challenge room's id. | Yes |
|
|
|
| taskDescription | string | Task's description. | Yes |
|
|
| taskDescription | string | Task's description. | Yes |
|
|
|
| taskNumber | number | Task's number in the challenge room. Starts from 1 | Yes |
|
|
| taskNumber | number | Task's number in the challenge room. Starts from 1 | Yes |
|
|
|
|
|
|
| ... | @@ -110,9 +110,9 @@ user ||--|{ submission |
... | @@ -110,9 +110,9 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| :key: submissionId (PK) | UUID | Submission's id. | Yes |
|
|
| :key: submissionId | UUID | Submission's id. | Yes |
|
|
|
| userUserId (FK) | UUID | User who submitted the submission. | Yes |
|
|
| :key2: userUserId | UUID | User who submitted the submission. | Yes |
|
|
|
| taskTaskId (FK) | UUID | Task which the submission was submitted to. | Yes |
|
|
| :key2: taskTaskId | 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 |
|
| ... | |
... | |
| ... | | ... | |