Table 1.
Data structure of a table of the Gateway database. (Data in the table are an example and not from study participants.)
| Consecutive counter, id | 9-digit secret | Participant group (0–6)a, enrollment_type | REDCap Record ID, survey_record_id | Open Humans Project Member ID, project_member_id | Access token, access_token |
Refresh token, refresh_token |
Unix timestamp (milliseconds), expires_at |
| 1 | 5DBJ4D9R7 | 2 | 2 | NULLb | NULL | NULL | NULL |
| 2 | G253LY4VC | 1 | 1 | 79565297 | YmtpPHHCug8FgVkQBvmszyP4nmXu6c | ZPhUY2pK85vvYuvhTr8qbEAtaCGAks | 1606799777655 |
| 3 | 290FA1D9B | 0 | 3 | NULL | NULL | NULL | NULL |
a0 indicates an adult using open-source automated insulin delivery,1 a nonuser adult, 2 a parent of a child user, 3 a parent of a child nonuser, 4 a teenage user, 5 a partner of an adult user, and 6 a partner of an adult nonuser.
bNULL indicates that there are no entry data.