drh_author

Column	Type
author_id	TEXT
name	TEXT
email	TEXT
investigator_id	TEXT
study_id	TEXT
tenant_id	VARCHAR

SQL DDL

CREATE VIEW drh_author AS
SELECT
    author_id, name, email, investigator_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_author