participant_cgm_date_range_cached
| Column |
Type |
PK |
Required |
Default |
| tenant_id |
TEXT |
No |
No |
|
| study_id |
TEXT |
No |
No |
|
| participant_id |
TEXT |
No |
No |
|
| participant_cgm_start_date |
TEXT |
No |
No |
|
| participant_cgm_end_date |
TEXT |
No |
No |
|
| end_date_minus_1_day |
TEXT |
No |
No |
|
| end_date_minus_7_days |
TEXT |
No |
No |
|
| end_date_minus_14_days |
TEXT |
No |
No |
|
| end_date_minus_30_days |
TEXT |
No |
No |
|
| end_date_minus_90_days |
TEXT |
No |
No |
|
Foreign Keys
Indexes
SQL DDL
CREATE TABLE participant_cgm_date_range_cached(
tenant_id TEXT,
study_id TEXT,
participant_id TEXT,
participant_cgm_start_date TEXT,
participant_cgm_end_date TEXT,
end_date_minus_1_day TEXT,
end_date_minus_7_days TEXT,
end_date_minus_14_days TEXT,
end_date_minus_30_days TEXT,
end_date_minus_90_days TEXT
)