select table_name from information_schema.columns where column_name='TENANT_ID' and TABLE_SCHEMA='construction_progress';

SELECT table_name from information_schema.`TABLES` where TABLE_SCHEMA='construction_progress'
and TABLE_NAME not in (
select table_name from information_schema.columns where column_name='TENANT_ID' and TABLE_SCHEMA='construction_progress'
)
;