| ... | @@ -69,7 +69,7 @@ user ||--|{ submission |
... | @@ -69,7 +69,7 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| userId (PK) | UUID | User's id. | Yes |
|
|
| :key: userId (PK) | UUID | User's id. | Yes |
|
|
|
| challengeRoomChallengeRoomId (FK) | UUID | The challenge room the player is in. | Yes |
|
|
| 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 |
|
| ... | @@ -82,7 +82,7 @@ user ||--|{ submission |
... | @@ -82,7 +82,7 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| challengeRoomId (PK) | UUID | Challenge room's id. | Yes |
|
|
| :key: challengeRoomId (PK) | 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,7 +98,7 @@ user ||--|{ submission |
... | @@ -98,7 +98,7 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| taskId(PK) | UUID | Task's id. | Yes |
|
|
| :key: taskId(PK) | UUID | Task's id. | Yes |
|
|
|
| challengeRoomChallengeRoomId (FK) | UUID | Task's challenge room's id. | Yes |
|
|
| challengeRoomChallengeRoomId (FK) | 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,7 +110,7 @@ user ||--|{ submission |
... | @@ -110,7 +110,7 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| submissionId (PK) | UUID | Submission's id. | Yes |
|
|
| :key: submissionId (PK) | UUID | Submission's id. | Yes |
|
|
|
| userUserId (FK) | UUID | User who submitted the submission. | Yes |
|
|
| userUserId (FK) | UUID | User who submitted the submission. | Yes |
|
|
|
| taskTaskId (FK) | UUID | Task which the submission was submitted to. | Yes |
|
|
| taskTaskId (FK) | 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 |
|
| ... | |
... | |
| ... | | ... | |