study_wise_csv_file_names

Column	Type
tenant_id	VARCHAR
study_id	TEXT
name	TEXT

SQL DDL

CREATE VIEW study_wise_csv_file_names AS
SELECT (
        select
            party_id
        from
            party
        limit
            1
    ) as tenant_id,
    (
        select
            study_id
        from
            uniform_resource_study
        limit
            1
    ) as study_id,name 
FROM sqlite_master
WHERE type = 'table' AND name LIKE 'uniform_resource_%' and name !='uniform_resource_transform'