What Sponsors holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| sponsors_links | staff_id, kind, ref_id | Which sponsored projects and grant rounds a sponsor's account may see on its own page. Set by the president. | Kept while the sponsor account exists; removed with it. | Row L5 |
| sponsors_keys | key_hash, hint, label, last_used_at | Checking the API key a sponsor's own server sends. Only a keyed hash of the key is kept, and its last four characters so the sponsor can tell keys apart. | Kept until the sponsor revokes the key or the account is deleted. | Row L6 |
| sponsors_payments | giver_name, amount_cents, fee_cents, total_cents, purpose, round_id, stripe_session, status | Recording a gift started through a sponsor's page or the payments API, and matching Stripe's notice that it was paid. Card details go to Stripe on Stripe's own page and never reach Tillyard. | Kept with the nonprofit's financial records, for at least seven years after the gift. | Row L7 |