drh_lab

Column	Type
lab_id	TEXT
lab_name	TEXT
lab_pi	TEXT
institution_id	TEXT
study_id	TEXT
tenant_id	VARCHAR

SQL DDL

CREATE VIEW drh_lab AS
SELECT
    lab_id, lab_name, lab_pi, institution_id, (select
            study_id
        from
            uniform_resource_study
        limit
            1
    ) as study_id,(
        select
            party_id
        from
            party
        limit
            1
    ) as tenant_id
FROM uniform_resource_lab