What Surveys holds
In plain wordsTechnical detail
| Stored in | Details | Why | Kept for | Schedule row |
|---|---|---|---|---|
| surveys_surveys | creator_member_id, title, intro, consent_json, ethics_summary, hold_case_id | A survey you made: its title, the note before the questions, the consent page (with any names and email address you chose to put on it) and, if you saved it, the ethics checklist summary. Once the survey is open, anyone with its link can read the consent page and the questions. | Kept until you delete the survey or your account. A draft you haven't changed for 12 months is deleted. | Not listed yet |
| surveys_sections | title, intro, show_q, show_op, show_val | The sections of your survey and the rule that decides when a section is skipped. | Deleted with the survey. | Not listed yet |
| surveys_questions | prompt, hint, options_json, low_label, high_label, show_q, show_op, show_val | The questions you wrote, their choices and skip rules. | Deleted with the survey. | Not listed yet |
| surveys_owners | member_id, role | Which members run a survey, so only they can change it and read its answers. | Deleted when you leave the survey or delete your account. If you started a survey and others run it too, it passes to the one who joined first. | Not listed yet |
| surveys_invites | created_by, used_by, expires_at, used_at | An invitation link you made so another member can help run a survey. It works once and runs out after 7 days. | Deleted when you cancel it, and 30 days after it was used or ran out. | Not listed yet |
| surveys_responses | day, answers_json | What people answered in a survey, and the day they sent it. Nothing in it says who they were: no name, email address, network address, device or time of day, unless a question the survey's owners wrote asks for one. Only the owners of the survey can read the answers. | Deleted 12 months after the survey closes, or sooner when an owner deletes them. | Not listed yet |