combined_cgm_tracing

Column	Type
tenant_id	VARCHAR
study_id	TEXT
participant_id	TEXT
Date_Time
CGM_Value	REAL

SQL DDL

CREATE VIEW combined_cgm_tracing AS
select 
    (
        select
            party_id
        from
            party
        limit
            1
    ) as tenant_id,
        (
        select
            study_id
        from
            uniform_resource_study
        limit
            1
    ) as study_id,
    SID as participant_id, 
    strftime('%Y-%m-%d %H:%M:%S', Date_Time) as Date_Time, 
    CAST(CGM_Value as REAL) as CGM_Value 
from uniform_resource_cgm_tracing