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.