Database.md

@@ -61,9 +61,26 @@ task ||--|{ submission
 user ||--|{ submission
 ```
 
+### Submission
+
+> 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 |
+|-------|------|-------------|----------|
+| submissionId <<PK>> | UUID | Submission's id. | Yes |
+| userId <<FK>> | UUID | Foreign key. User who submitted the submission. | Yes |
+| taskId <<FK>> | UUID | Foreign key. 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 |
+| fileName | string | Submission file's name. | Yes |
+| mimeType | string | Submission photo's file format. | No |
+
+
+### 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.
 | 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. |
 | ChallengeRoom | Game room's information. |
 | Task | Challenge room's task. |
 | Submission | Players' photo submissions to the challenge room tasks. Submission table contains the photo's information as well as tasks completion status. |
+