drh_institution

Column	Type
institution_id	TEXT
institution_name	TEXT
city	TEXT
state	TEXT
country	TEXT
tenant_id	VARCHAR

SQL DDL

CREATE VIEW drh_institution AS
SELECT
    institution_id, institution_name, city, state, country,(
        select
            party_id
        from
            party
        limit
            1
    ) as tenant_id
FROM uniform_resource_institution