drh_device

Column	Type
tenant_id	VARCHAR
study_id	TEXT
device_id	VARCHAR
name	TEXT
created_at	TIMESTAMPTZ

SQL DDL

CREATE VIEW drh_device AS
SELECT (
    select
            party_id
        from
            party
        limit
            1
    ) as tenant_id,
    (select
            study_id
        from
            uniform_resource_study
        limit
            1
    ) as study_id,
    device_id, name, created_at
FROM device d