from app.models import Base


def test_workspace_owned_tables_have_workspace_scope():
    global_tables = {
        "workspaces", "users", "mfa_recovery_codes", "permissions", "installation_state",
    }
    for table in Base.metadata.sorted_tables:
        if table.name not in global_tables:
            assert "workspace_id" in table.columns, f"{table.name} is missing workspace_id"