What campus pages and sharing hold
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| growth_founding | school_id, number, member_id, act, act_at, granted, withdrawn_at, created_at | Records the order in which early members at a college were numbered, so a number is never given twice. | While your account lives; then the number alone, without your name. | Row E40 |
| growth_placements | code, format, spot, spot_no, list, school_id, created_by, state, printed_day, expires_at, joined_n, created_at | Tells a sheet's code apart from another, so one that is put up in the wrong place can be ended. | 400 days after the sheet ends; your name comes off if you delete your account. | Row E12 |
| growth_invites | code, member_id, table_key, show_name, state, created_at | Points an invitation at one table, and lets you end it. Nothing is kept about the people who open it. | Until you end it or the table has met, and no more than 90 days after. | Row E41 |
| growth_waitlist | email_mac, email, domain, school_id, kind, state, confirmed_at, told_at | Writes to an address once, when its college opens, and then deletes the address. | Until that one letter, and never more than 12 months. The keyed hash stays only for someone who asked not to be written to. | Row K7 |
| growth_early | list, email_mac, email_sealed, domain, created_at, told_at, left_at | Writes to an address once, when Tillyard opens to students or when it can accept donations, and then deletes the address. The address is kept encrypted. | Until that one letter, and never more than 12 months. The keyed hash stays only for someone who asked to be taken off. | Row K11 |
| growth_campuses | school_id, slug, page, members_n, counted_at, opened_at, f_cap, f_days, f_opens_at, f_closes_at, f_issued | Counts members at each college and keeps the founding window's rules as they were when it opened. Totals only. | While the college has members. | Row E42 |