tem_tenant

Column	Type
organization_id	ULID
tenant_id	TEXT
device_id	TEXT
tenant_name	TEXT

SQL DDL

CREATE VIEW tem_tenant AS
SELECT
  org.organization_id,
  org.party_id AS tenant_id,
  dpr.device_id,
  org.name AS tenant_name
FROM organization org INNER JOIN device_party_relationship dpr ON dpr.party_id=org.party_id