It’s a join on three underlying tables, Users, Org...

# exposed

[mkporwit]

It’s a join on three underlying tables, Users, Orgs, and Roles. Here’s the DAO for Orgs:

object Orgs : IntIdTable() {
    val uid = varchar("uid", 36).uniqueIndex().entityId()
    val name = varchar("name", 256, collate = "utf8mb4_general_ci")
}

class Org(id: EntityID<Int>) : IntEntity(id) {
    companion object : IntEntityClass<Org>(Orgs)

    var uid by Orgs.uid
    var name by Orgs.name
}