What team projects hold

In plain words Technical detail

Where each kind is stored, and the details it holds
Stored in	Details	Why	Kept for	Schedule row
projects_projects	pub, name, summary, kind, is_business, tags, team_size, lead_id, status, text_state, thread_href, created_at	Shows the project on the board and to its team, and says whether it is a business.	While anyone on the team holds a line on The Record from it; otherwise 12 months after it is closed.	Row E14
projects_members	project_id, member_id, seat, state, role, agreed_at, statement, line, confirmers, joined_at, left_at	Records who is on a team, in what part, and the statement you wrote when it was finished, with how many teammates confirmed it.	With the project. If you delete your account your seat is kept without your name and your statement is deleted.	Row E15
projects_requests	project_id, member_id, direction, seat, role, note, help_kind, minutes, term, state, created_at	Holds a request to join, an invitation, or a quick-help note until the team or you answer it.	30 days after it is answered or lapses.	Row E15
projects_cards	project_id, kind, role, line, state, posted_by, expires_at	Tells other members what a team is looking for.	90 days after the card comes down.	Row E17
projects_log	project_id, member_id, body, text_state, created_at	Keeps the team's short dated notes about what happened.	With the project. Deleted if you delete your account.	Row E20
projects_milestones	project_id, title, text_state, state, sort, done_by, done_at, created_at	Lists the steps a team set itself and who ticked them off.	With the project.	Row E14
projects_checks	project_id, item, by_member_id, at	Shows which items on the founding-team checklist the team has ticked, and who ticked them.	With the project.	Row E14
projects_confirms	about_pm_id, by_pm_id, verdict, created_at	Records which teammates confirmed which statement, so a line on The Record can say who checked it.	With the project.	Row E18