| ... | @@ -67,9 +67,9 @@ user ||--|{ submission |
... | @@ -67,9 +67,9 @@ user ||--|{ submission |
|
|
|
|
|
|
|
| Field | Type | Description | Required |
|
|
| Field | Type | Description | Required |
|
|
|
|-------|------|-------------|----------|
|
|
|-------|------|-------------|----------|
|
|
|
| submissionId \<\<PK\>\> | UUID | Submission's id. | Yes |
|
|
| submissionId \<PK\> | UUID | Submission's id. | Yes |
|
|
|
| userId \<\<FK\>\> | UUID | Foreign key. User who submitted the submission. | Yes |
|
|
| userId \<FK\> | UUID | User who submitted the submission. | Yes |
|
|
|
| taskId \<\<FK\>\> | UUID | Foreign key. Task which the submission was submitted to. | Yes |
|
|
| taskId \<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 |
|
|
|
| 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 |
|
| ... | |
... | |
| ... | | ... | |