The last table is a bit more complicated. It has many rows and many columns.
Select all the information from the last table: project. Note that you won't see all the rows present in the table – our platform displays only a limited number of rows for readability.
You can find the project_id, client_id and translator_id, of course. These columns should be clear. Then, you can also see:
- the
start – that is, when the client commissioned the project.
- the
deadline – when the project is due.
Afterward, we can see the price the client paid, the number of words for translation and two languages:
- the source language (
lang_from),
- the target language (
lang_to).
The final column (feedback) provides the client's feedback. Positive numbers mean that the client was very satisfied, negative ones mean that the client complained to some extent about the quality.