drh_investigator

Column	Type
investigator_id	TEXT
investigator_name	TEXT
email	TEXT
institution_id	TEXT
study_id	TEXT
tenant_id	VARCHAR

SQL DDL

CREATE VIEW drh_investigator AS
SELECT
    investigator_id, investigator_name, email, 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_investigator