What Tillyard Résumé holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| workbench_docs | member_id, cid, kind, title, body_json, bytes, due_at | The copy of your résumés, letters, stories, pitch and checklist that you asked us to keep, so you can reach them from another device. A tracker row also holds the names you typed for your contacts. | Until you delete the copy, turn copies off or close your account, or after 24 months without a sign-in. A deleted copy leaves an empty marker for 30 days so your other devices hear of it. | Row G3 |
| workbench_swap_entries | member_id, school_id, snapshot_json, ask, field | The anonymised copy of your résumé that is shown to one swap partner at a time, what you asked them to look at and the field you named. | The copy is removed 30 days after the entry closes. The emptied row stays with the pair history for 12 months. | Row G4 |
| workbench_swap_notes | writer_id, marks_json, item_notes_json, keep_note, change_note, seconds | The notes one member wrote on another's résumé: six answers in words, and two short notes. How long the writer spent is kept so that empty notes can be told from real ones. | 12 months once delivered; 30 days when they were never delivered. Notes you wrote stay with the member they were written for, without your name, if you close your account first. | Row G5 |
| workbench_swaps | lo_member_id, hi_member_id, lo_accepted_at, hi_accepted_at | So that the same two members are not offered each other again, and so that a swap can be ended on time. Neither member is shown who the other is. | 12 months after the swap closes. | Row G6 |
| workbench_swap_bars | member_id, reason, case_ticket, staff_id | Records that staff closed the swap to a member after a report, with the reason key and the case it came from. | Until staff lift it. | Row G7 |