participant_dashboard_cached
| Column |
Type |
PK |
Required |
Default |
| tenant_id |
TEXT |
No |
No |
|
| study_id |
TEXT |
No |
No |
|
| participant_id |
TEXT |
No |
No |
|
| gender |
TEXT |
No |
No |
|
| age |
TEXT |
No |
No |
|
| study_arm |
TEXT |
No |
No |
|
| baseline_hba1c |
TEXT |
No |
No |
|
| cgm_devices |
|
No |
No |
|
| cgm_files |
|
No |
No |
|
| tir |
|
No |
No |
|
| tar_vh |
|
No |
No |
|
| tar_h |
|
No |
No |
|
| tbr_l |
|
No |
No |
|
| tbr_vl |
|
No |
No |
|
| tar |
|
No |
No |
|
| tbr |
|
No |
No |
|
| gmi |
|
No |
No |
|
| percent_gv |
|
No |
No |
|
| gri |
|
No |
No |
|
| days_of_wear |
|
No |
No |
|
| data_start_date |
|
No |
No |
|
| data_end_date |
|
No |
No |
|
| wear_time_percentage |
|
No |
No |
|
Foreign Keys
Indexes
SQL DDL
CREATE TABLE participant_dashboard_cached(
tenant_id TEXT,
study_id TEXT,
participant_id TEXT,
gender TEXT,
age TEXT,
study_arm TEXT,
baseline_hba1c TEXT,
cgm_devices,
cgm_files,
tir,
tar_vh,
tar_h,
tbr_l,
tbr_vl,
tar,
tbr,
gmi,
percent_gv,
gri,
days_of_wear,
data_start_date,
data_end_date,
wear_time_percentage
)