# ORM Client
## Setup
```typescript
import { createClient } from './orm';
const db = createClient({
endpoint: 'https://api.example.com/graphql',
headers: { Authorization: 'Bearer ' },
});
```
## Models
| Model | Operations |
|-------|------------|
| `appAdminGrant` | findMany, findOne, create, update, delete |
| `appCapabilityDefaultCapability` | findMany, findOne, create, update, delete |
| `appCapabilityDefaultGrant` | findMany, findOne, create, update, delete |
| `appClaimedInvite` | findMany, findOne, create, update, delete |
| `appGrant` | findMany, findOne, create, update, delete |
| `appInvite` | findMany, findOne, create, update, delete |
| `appMembership` | findMany, findOne, create, update, delete |
| `appMembershipDefault` | findMany, findOne, create, update, delete |
| `appOwnerGrant` | findMany, findOne, create, update, delete |
| `membershipType` | findMany, findOne, create, update, delete |
| `myPendingAppInvitesRecord` | findMany, findOne, update, delete |
| `myPendingOrgInvitesRecord` | findMany, findOne, update, delete |
| `orgAdminGrant` | findMany, findOne, create, update, delete |
| `orgCapabilityDefaultCapability` | findMany, findOne, create, update, delete |
| `orgCapabilityDefaultGrant` | findMany, findOne, create, update, delete |
| `orgChartEdge` | findMany, findOne, create, update, delete |
| `orgChartEdgeGrant` | findMany, findOne, create, update, delete |
| `orgClaimedInvite` | findMany, findOne, create, update, delete |
| `orgGetManagersRecord` | findMany, findOne, update, delete |
| `orgGetSubordinatesRecord` | findMany, findOne, update, delete |
| `orgGrant` | findMany, findOne, create, update, delete |
| `orgInvite` | findMany, findOne, create, update, delete |
| `orgMember` | findMany, findOne, create, update, delete |
| `orgMemberProfile` | findMany, findOne, create, update, delete |
| `orgMembership` | findMany, findOne, create, update, delete |
| `orgMembershipDefault` | findMany, findOne, create, update, delete |
| `orgMembershipSetting` | findMany, findOne, create, update, delete |
| `orgOwnerGrant` | findMany, findOne, create, update, delete |
## Table Operations
### `db.appAdminGrant`
CRUD operations for AppAdminGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all appAdminGrant records
const items = await db.appAdminGrant.findMany({ select: { actorId: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.appAdminGrant.findOne({ id: '', select: { actorId: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Create
const created = await db.appAdminGrant.create({ data: { actorId: '', grantorId: '', isGrant: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appAdminGrant.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appAdminGrant.delete({ where: { id: '' } }).execute();
```
### `db.appCapabilityDefaultCapability`
CRUD operations for AppCapabilityDefaultCapability records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `capabilityId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `id` | UUID | No |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all appCapabilityDefaultCapability records
const items = await db.appCapabilityDefaultCapability.findMany({ select: { capabilityId: true, createdAt: true, id: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.appCapabilityDefaultCapability.findOne({ id: '', select: { capabilityId: true, createdAt: true, id: true, updatedAt: true } }).execute();
// Create
const created = await db.appCapabilityDefaultCapability.create({ data: { capabilityId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appCapabilityDefaultCapability.update({ where: { id: '' }, data: { capabilityId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appCapabilityDefaultCapability.delete({ where: { id: '' } }).execute();
```
### `db.appCapabilityDefaultGrant`
CRUD operations for AppCapabilityDefaultGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `capabilityId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all appCapabilityDefaultGrant records
const items = await db.appCapabilityDefaultGrant.findMany({ select: { capabilityId: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.appCapabilityDefaultGrant.findOne({ id: '', select: { capabilityId: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Create
const created = await db.appCapabilityDefaultGrant.create({ data: { capabilityId: '', grantorId: '', isGrant: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appCapabilityDefaultGrant.update({ where: { id: '' }, data: { capabilityId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appCapabilityDefaultGrant.delete({ where: { id: '' } }).execute();
```
### `db.appClaimedInvite`
CRUD operations for AppClaimedInvite records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `data` | JSON | Yes |
| `id` | UUID | No |
| `receiverId` | UUID | Yes |
| `senderId` | UUID | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all appClaimedInvite records
const items = await db.appClaimedInvite.findMany({ select: { createdAt: true, data: true, id: true, receiverId: true, senderId: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.appClaimedInvite.findOne({ id: '', select: { createdAt: true, data: true, id: true, receiverId: true, senderId: true, updatedAt: true } }).execute();
// Create
const created = await db.appClaimedInvite.create({ data: { data: '', receiverId: '', senderId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appClaimedInvite.update({ where: { id: '' }, data: { data: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appClaimedInvite.delete({ where: { id: '' } }).execute();
```
### `db.appGrant`
CRUD operations for AppGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `capabilities` | BitString | Yes |
| `createdAt` | Datetime | No |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all appGrant records
const items = await db.appGrant.findMany({ select: { actorId: true, capabilities: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.appGrant.findOne({ id: '', select: { actorId: true, capabilities: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Create
const created = await db.appGrant.create({ data: { actorId: '', capabilities: '', grantorId: '', isGrant: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appGrant.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appGrant.delete({ where: { id: '' } }).execute();
```
### `db.appInvite`
CRUD operations for AppInvite records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `channel` | String | Yes |
| `createdAt` | Datetime | No |
| `data` | JSON | Yes |
| `email` | ConstructiveInternalTypeEmail | Yes |
| `expiresAt` | Datetime | Yes |
| `id` | UUID | No |
| `inviteCount` | Int | Yes |
| `inviteLimit` | Int | Yes |
| `inviteToken` | String | Yes |
| `inviteValid` | Boolean | Yes |
| `multiple` | Boolean | Yes |
| `phone` | String | Yes |
| `profileId` | UUID | Yes |
| `senderId` | UUID | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all appInvite records
const items = await db.appInvite.findMany({ select: { channel: true, createdAt: true, data: true, email: true, expiresAt: true, id: true, inviteCount: true, inviteLimit: true, inviteToken: true, inviteValid: true, multiple: true, phone: true, profileId: true, senderId: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.appInvite.findOne({ id: '', select: { channel: true, createdAt: true, data: true, email: true, expiresAt: true, id: true, inviteCount: true, inviteLimit: true, inviteToken: true, inviteValid: true, multiple: true, phone: true, profileId: true, senderId: true, updatedAt: true } }).execute();
// Create
const created = await db.appInvite.create({ data: { channel: '', data: '', email: '', expiresAt: '', inviteCount: '', inviteLimit: '', inviteToken: '', inviteValid: '', multiple: '', phone: '', profileId: '', senderId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appInvite.update({ where: { id: '' }, data: { channel: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appInvite.delete({ where: { id: '' } }).execute();
```
### `db.appMembership`
CRUD operations for AppMembership records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `capabilities` | BitString | Yes |
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `granted` | BitString | Yes |
| `id` | UUID | No |
| `isActive` | Boolean | Yes |
| `isAdmin` | Boolean | Yes |
| `isApproved` | Boolean | Yes |
| `isBanned` | Boolean | Yes |
| `isDisabled` | Boolean | Yes |
| `isOwner` | Boolean | Yes |
| `isVerified` | Boolean | Yes |
| `profileId` | UUID | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all appMembership records
const items = await db.appMembership.findMany({ select: { actorId: true, capabilities: true, createdAt: true, createdBy: true, createdByPrincipal: true, granted: true, id: true, isActive: true, isAdmin: true, isApproved: true, isBanned: true, isDisabled: true, isOwner: true, isVerified: true, profileId: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.appMembership.findOne({ id: '', select: { actorId: true, capabilities: true, createdAt: true, createdBy: true, createdByPrincipal: true, granted: true, id: true, isActive: true, isAdmin: true, isApproved: true, isBanned: true, isDisabled: true, isOwner: true, isVerified: true, profileId: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.appMembership.create({ data: { actorId: '', capabilities: '', createdBy: '', createdByPrincipal: '', granted: '', isActive: '', isAdmin: '', isApproved: '', isBanned: '', isDisabled: '', isOwner: '', isVerified: '', profileId: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appMembership.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appMembership.delete({ where: { id: '' } }).execute();
```
### `db.appMembershipDefault`
CRUD operations for AppMembershipDefault records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `id` | UUID | No |
| `isApproved` | Boolean | Yes |
| `isVerified` | Boolean | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all appMembershipDefault records
const items = await db.appMembershipDefault.findMany({ select: { createdAt: true, createdBy: true, createdByPrincipal: true, id: true, isApproved: true, isVerified: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.appMembershipDefault.findOne({ id: '', select: { createdAt: true, createdBy: true, createdByPrincipal: true, id: true, isApproved: true, isVerified: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.appMembershipDefault.create({ data: { createdBy: '', createdByPrincipal: '', isApproved: '', isVerified: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appMembershipDefault.update({ where: { id: '' }, data: { createdBy: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appMembershipDefault.delete({ where: { id: '' } }).execute();
```
### `db.appOwnerGrant`
CRUD operations for AppOwnerGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all appOwnerGrant records
const items = await db.appOwnerGrant.findMany({ select: { actorId: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.appOwnerGrant.findOne({ id: '', select: { actorId: true, createdAt: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Create
const created = await db.appOwnerGrant.create({ data: { actorId: '', grantorId: '', isGrant: '' }, select: { id: true } }).execute();
// Update
const updated = await db.appOwnerGrant.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.appOwnerGrant.delete({ where: { id: '' } }).execute();
```
### `db.membershipType`
CRUD operations for MembershipType records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `description` | String | Yes |
| `hasUsersTableEntry` | Boolean | Yes |
| `id` | Int | No |
| `name` | String | Yes |
| `parentMembershipType` | Int | Yes |
| `scope` | String | Yes |
**Operations:**
```typescript
// List all membershipType records
const items = await db.membershipType.findMany({ select: { description: true, hasUsersTableEntry: true, id: true, name: true, parentMembershipType: true, scope: true } }).execute();
// Get one by id
const item = await db.membershipType.findOne({ id: '', select: { description: true, hasUsersTableEntry: true, id: true, name: true, parentMembershipType: true, scope: true } }).execute();
// Create
const created = await db.membershipType.create({ data: { description: '', hasUsersTableEntry: '', name: '', parentMembershipType: '', scope: '' }, select: { id: true } }).execute();
// Update
const updated = await db.membershipType.update({ where: { id: '' }, data: { description: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.membershipType.delete({ where: { id: '' } }).execute();
```
### `db.myPendingAppInvitesRecord`
CRUD operations for MyPendingAppInvitesRecord records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `channel` | String | Yes |
| `createdAt` | Datetime | No |
| `expiresAt` | Datetime | Yes |
| `id` | UUID | No |
| `senderId` | UUID | Yes |
**Operations:**
```typescript
// List all myPendingAppInvitesRecord records
const items = await db.myPendingAppInvitesRecord.findMany({ select: { channel: true, createdAt: true, expiresAt: true, id: true, senderId: true } }).execute();
// Get one by id
const item = await db.myPendingAppInvitesRecord.findOne({ id: '', select: { channel: true, createdAt: true, expiresAt: true, id: true, senderId: true } }).execute();
// Update
const updated = await db.myPendingAppInvitesRecord.update({ where: { id: '' }, data: { channel: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.myPendingAppInvitesRecord.delete({ where: { id: '' } }).execute();
```
### `db.myPendingOrgInvitesRecord`
CRUD operations for MyPendingOrgInvitesRecord records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `channel` | String | Yes |
| `createdAt` | Datetime | No |
| `entityId` | UUID | Yes |
| `expiresAt` | Datetime | Yes |
| `id` | UUID | No |
| `senderId` | UUID | Yes |
**Operations:**
```typescript
// List all myPendingOrgInvitesRecord records
const items = await db.myPendingOrgInvitesRecord.findMany({ select: { channel: true, createdAt: true, entityId: true, expiresAt: true, id: true, senderId: true } }).execute();
// Get one by id
const item = await db.myPendingOrgInvitesRecord.findOne({ id: '', select: { channel: true, createdAt: true, entityId: true, expiresAt: true, id: true, senderId: true } }).execute();
// Update
const updated = await db.myPendingOrgInvitesRecord.update({ where: { id: '' }, data: { channel: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.myPendingOrgInvitesRecord.delete({ where: { id: '' } }).execute();
```
### `db.orgAdminGrant`
CRUD operations for OrgAdminGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `entityId` | UUID | Yes |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgAdminGrant records
const items = await db.orgAdminGrant.findMany({ select: { actorId: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgAdminGrant.findOne({ id: '', select: { actorId: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Create
const created = await db.orgAdminGrant.create({ data: { actorId: '', entityId: '', grantorId: '', isGrant: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgAdminGrant.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgAdminGrant.delete({ where: { id: '' } }).execute();
```
### `db.orgCapabilityDefaultCapability`
CRUD operations for OrgCapabilityDefaultCapability records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `capabilityId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `entityId` | UUID | Yes |
| `id` | UUID | No |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgCapabilityDefaultCapability records
const items = await db.orgCapabilityDefaultCapability.findMany({ select: { capabilityId: true, createdAt: true, entityId: true, id: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgCapabilityDefaultCapability.findOne({ id: '', select: { capabilityId: true, createdAt: true, entityId: true, id: true, updatedAt: true } }).execute();
// Create
const created = await db.orgCapabilityDefaultCapability.create({ data: { capabilityId: '', entityId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgCapabilityDefaultCapability.update({ where: { id: '' }, data: { capabilityId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgCapabilityDefaultCapability.delete({ where: { id: '' } }).execute();
```
### `db.orgCapabilityDefaultGrant`
CRUD operations for OrgCapabilityDefaultGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `capabilityId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `entityId` | UUID | Yes |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgCapabilityDefaultGrant records
const items = await db.orgCapabilityDefaultGrant.findMany({ select: { capabilityId: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgCapabilityDefaultGrant.findOne({ id: '', select: { capabilityId: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Create
const created = await db.orgCapabilityDefaultGrant.create({ data: { capabilityId: '', entityId: '', grantorId: '', isGrant: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgCapabilityDefaultGrant.update({ where: { id: '' }, data: { capabilityId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgCapabilityDefaultGrant.delete({ where: { id: '' } }).execute();
```
### `db.orgChartEdge`
CRUD operations for OrgChartEdge records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `childId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `entityId` | UUID | Yes |
| `id` | UUID | No |
| `parentId` | UUID | Yes |
| `positionLevel` | Int | Yes |
| `positionTitle` | String | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgChartEdge records
const items = await db.orgChartEdge.findMany({ select: { childId: true, createdAt: true, entityId: true, id: true, parentId: true, positionLevel: true, positionTitle: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgChartEdge.findOne({ id: '', select: { childId: true, createdAt: true, entityId: true, id: true, parentId: true, positionLevel: true, positionTitle: true, updatedAt: true } }).execute();
// Create
const created = await db.orgChartEdge.create({ data: { childId: '', entityId: '', parentId: '', positionLevel: '', positionTitle: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgChartEdge.update({ where: { id: '' }, data: { childId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgChartEdge.delete({ where: { id: '' } }).execute();
```
### `db.orgChartEdgeGrant`
CRUD operations for OrgChartEdgeGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `childId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `entityId` | UUID | Yes |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `parentId` | UUID | Yes |
| `positionLevel` | Int | Yes |
| `positionTitle` | String | Yes |
**Operations:**
```typescript
// List all orgChartEdgeGrant records
const items = await db.orgChartEdgeGrant.findMany({ select: { childId: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, parentId: true, positionLevel: true, positionTitle: true } }).execute();
// Get one by id
const item = await db.orgChartEdgeGrant.findOne({ id: '', select: { childId: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, parentId: true, positionLevel: true, positionTitle: true } }).execute();
// Create
const created = await db.orgChartEdgeGrant.create({ data: { childId: '', entityId: '', grantorId: '', isGrant: '', parentId: '', positionLevel: '', positionTitle: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgChartEdgeGrant.update({ where: { id: '' }, data: { childId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgChartEdgeGrant.delete({ where: { id: '' } }).execute();
```
### `db.orgClaimedInvite`
CRUD operations for OrgClaimedInvite records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `data` | JSON | Yes |
| `entityId` | UUID | Yes |
| `id` | UUID | No |
| `receiverId` | UUID | Yes |
| `senderId` | UUID | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgClaimedInvite records
const items = await db.orgClaimedInvite.findMany({ select: { createdAt: true, data: true, entityId: true, id: true, receiverId: true, senderId: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgClaimedInvite.findOne({ id: '', select: { createdAt: true, data: true, entityId: true, id: true, receiverId: true, senderId: true, updatedAt: true } }).execute();
// Create
const created = await db.orgClaimedInvite.create({ data: { data: '', entityId: '', receiverId: '', senderId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgClaimedInvite.update({ where: { id: '' }, data: { data: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgClaimedInvite.delete({ where: { id: '' } }).execute();
```
### `db.orgGetManagersRecord`
CRUD operations for OrgGetManagersRecord records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `depth` | Int | Yes |
| `userId` | UUID | Yes |
**Operations:**
```typescript
// List all orgGetManagersRecord records
const items = await db.orgGetManagersRecord.findMany({ select: { depth: true, userId: true } }).execute();
// Get one by id
const item = await db.orgGetManagersRecord.findOne({ id: '', select: { depth: true, userId: true } }).execute();
// Update
const updated = await db.orgGetManagersRecord.update({ where: { id: '' }, data: { depth: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgGetManagersRecord.delete({ where: { id: '' } }).execute();
```
### `db.orgGetSubordinatesRecord`
CRUD operations for OrgGetSubordinatesRecord records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `depth` | Int | Yes |
| `userId` | UUID | Yes |
**Operations:**
```typescript
// List all orgGetSubordinatesRecord records
const items = await db.orgGetSubordinatesRecord.findMany({ select: { depth: true, userId: true } }).execute();
// Get one by id
const item = await db.orgGetSubordinatesRecord.findOne({ id: '', select: { depth: true, userId: true } }).execute();
// Update
const updated = await db.orgGetSubordinatesRecord.update({ where: { id: '' }, data: { depth: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgGetSubordinatesRecord.delete({ where: { id: '' } }).execute();
```
### `db.orgGrant`
CRUD operations for OrgGrant records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `capabilities` | BitString | Yes |
| `createdAt` | Datetime | No |
| `entityId` | UUID | Yes |
| `grantorId` | UUID | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgGrant records
const items = await db.orgGrant.findMany({ select: { actorId: true, capabilities: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgGrant.findOne({ id: '', select: { actorId: true, capabilities: true, createdAt: true, entityId: true, grantorId: true, id: true, isGrant: true, updatedAt: true } }).execute();
// Create
const created = await db.orgGrant.create({ data: { actorId: '', capabilities: '', entityId: '', grantorId: '', isGrant: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgGrant.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgGrant.delete({ where: { id: '' } }).execute();
```
### `db.orgInvite`
CRUD operations for OrgInvite records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `channel` | String | Yes |
| `createdAt` | Datetime | No |
| `data` | JSON | Yes |
| `email` | ConstructiveInternalTypeEmail | Yes |
| `entityId` | UUID | Yes |
| `expiresAt` | Datetime | Yes |
| `id` | UUID | No |
| `inviteCount` | Int | Yes |
| `inviteLimit` | Int | Yes |
| `inviteToken` | String | Yes |
| `inviteValid` | Boolean | Yes |
| `isReadOnly` | Boolean | Yes |
| `multiple` | Boolean | Yes |
| `phone` | String | Yes |
| `profileId` | UUID | Yes |
| `receiverId` | UUID | Yes |
| `senderId` | UUID | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgInvite records
const items = await db.orgInvite.findMany({ select: { channel: true, createdAt: true, data: true, email: true, entityId: true, expiresAt: true, id: true, inviteCount: true, inviteLimit: true, inviteToken: true, inviteValid: true, isReadOnly: true, multiple: true, phone: true, profileId: true, receiverId: true, senderId: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgInvite.findOne({ id: '', select: { channel: true, createdAt: true, data: true, email: true, entityId: true, expiresAt: true, id: true, inviteCount: true, inviteLimit: true, inviteToken: true, inviteValid: true, isReadOnly: true, multiple: true, phone: true, profileId: true, receiverId: true, senderId: true, updatedAt: true } }).execute();
// Create
const created = await db.orgInvite.create({ data: { channel: '', data: '', email: '', entityId: '', expiresAt: '', inviteCount: '', inviteLimit: '', inviteToken: '', inviteValid: '', isReadOnly: '', multiple: '', phone: '', profileId: '', receiverId: '', senderId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgInvite.update({ where: { id: '' }, data: { channel: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgInvite.delete({ where: { id: '' } }).execute();
```
### `db.orgMember`
CRUD operations for OrgMember records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `entityId` | UUID | Yes |
| `id` | UUID | No |
| `isAdmin` | Boolean | Yes |
**Operations:**
```typescript
// List all orgMember records
const items = await db.orgMember.findMany({ select: { actorId: true, entityId: true, id: true, isAdmin: true } }).execute();
// Get one by id
const item = await db.orgMember.findOne({ id: '', select: { actorId: true, entityId: true, id: true, isAdmin: true } }).execute();
// Create
const created = await db.orgMember.create({ data: { actorId: '', entityId: '', isAdmin: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgMember.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgMember.delete({ where: { id: '' } }).execute();
```
### `db.orgMemberProfile`
CRUD operations for OrgMemberProfile records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `bio` | String | Yes |
| `createdAt` | Datetime | No |
| `displayName` | String | Yes |
| `email` | String | Yes |
| `entityId` | UUID | Yes |
| `id` | UUID | No |
| `membershipId` | UUID | Yes |
| `profilePicture` | ConstructiveInternalTypeImage | Yes |
| `profilePictureUrl` | String | No |
| `profilePictureVersions` | FileVersion | No |
| `title` | String | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all orgMemberProfile records
const items = await db.orgMemberProfile.findMany({ select: { actorId: true, bio: true, createdAt: true, displayName: true, email: true, entityId: true, id: true, membershipId: true, profilePicture: true, title: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.orgMemberProfile.findOne({ id: '', select: { actorId: true, bio: true, createdAt: true, displayName: true, email: true, entityId: true, id: true, membershipId: true, profilePicture: true, title: true, updatedAt: true } }).execute();
// Create
const created = await db.orgMemberProfile.create({ data: { actorId: '', bio: '', displayName: '', email: '', entityId: '', membershipId: '', profilePicture: '', title: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgMemberProfile.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgMemberProfile.delete({ where: { id: '' } }).execute();
```
### `db.orgMembership`
CRUD operations for OrgMembership records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `capabilities` | BitString | Yes |
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `entityId` | UUID | Yes |
| `granted` | BitString | Yes |
| `id` | UUID | No |
| `isActive` | Boolean | Yes |
| `isAdmin` | Boolean | Yes |
| `isApproved` | Boolean | Yes |
| `isBanned` | Boolean | Yes |
| `isDisabled` | Boolean | Yes |
| `isExternal` | Boolean | Yes |
| `isOwner` | Boolean | Yes |
| `isReadOnly` | Boolean | Yes |
| `profileId` | UUID | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all orgMembership records
const items = await db.orgMembership.findMany({ select: { actorId: true, capabilities: true, createdAt: true, createdBy: true, createdByPrincipal: true, entityId: true, granted: true, id: true, isActive: true, isAdmin: true, isApproved: true, isBanned: true, isDisabled: true, isExternal: true, isOwner: true, isReadOnly: true, profileId: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.orgMembership.findOne({ id: '', select: { actorId: true, capabilities: true, createdAt: true, createdBy: true, createdByPrincipal: true, entityId: true, granted: true, id: true, isActive: true, isAdmin: true, isApproved: true, isBanned: true, isDisabled: true, isExternal: true, isOwner: true, isReadOnly: true, profileId: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.orgMembership.create({ data: { actorId: '', capabilities: '', createdBy: '', createdByPrincipal: '', entityId: '', granted: '', isActive: '', isAdmin: '', isApproved: '', isBanned: '', isDisabled: '', isExternal: '', isOwner: '', isReadOnly: '', profileId: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgMembership.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgMembership.delete({ where: { id: '' } }).execute();
```
### `db.orgMembershipDefault`
CRUD operations for OrgMembershipDefault records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `entityId` | UUID | Yes |
| `id` | UUID | No |
| `isApproved` | Boolean | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all orgMembershipDefault records
const items = await db.orgMembershipDefault.findMany({ select: { createdAt: true, createdBy: true, createdByPrincipal: true, entityId: true, id: true, isApproved: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.orgMembershipDefault.findOne({ id: '', select: { createdAt: true, createdBy: true, createdByPrincipal: true, entityId: true, id: true, isApproved: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.orgMembershipDefault.create({ data: { createdBy: '', createdByPrincipal: '', entityId: '', isApproved: '', updatedBy: '', updatedByPrincipal: '' }, select: { id: true } }).execute();
// Update
const updated = await db.orgMembershipDefault.update({ where: { id: '' }, data: { createdBy: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.orgMembershipDefault.delete({ where: { id: '' } }).execute();
```
### `db.orgMembershipSetting`
CRUD operations for OrgMembershipSetting records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `allowExternalMembers` | Boolean | Yes |
| `allowPrincipalOwnedApiKeys` | Boolean | Yes |
| `apiKeyMaxDuration` | Interval | Yes |
| `createChildCascadeAdmins` | Boolean | Yes |
| `createChildCascadeMembers` | Boolean | Yes |
| `createChildCascadeOwners` | Boolean | Yes |
| `createdAt` | Datetime | No |
| `createdBy` | UUID | Yes |
| `createdByPrincipal` | UUID | Yes |
| `deleteMemberCascadeChildren` | Boolean | Yes |
| `entityId` | UUID | Yes |
| `id` | UUID | No |
| `inviteProfileAssignmentMode` | String | Yes |
| `limitAllocationMode` | String | Yes |
| `populateMemberEmail` | Boolean | Yes |
| `updatedAt` | Datetime | No |
| `updatedBy` | UUID | Yes |
| `updatedByPrincipal` | UUID | Yes |
**Operations:**
```typescript
// List all orgMembershipSetting records
const items = await db.orgMembershipSetting.findMany({ select: { allowExternalMembers: true, allowPrincipalOwnedApiKeys: true, apiKeyMaxDuration: true, createChildCascadeAdmins: true, createChildCascadeMembers: true, createChildCascadeOwners: true, createdAt: true, createdBy: true, createdByPrincipal: true, deleteMemberCascadeChildren: true, entityId: true, id: true, inviteProfileAssignmentMode: true, limitAllocationMode: true, populateMemberEmail: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Get one by id
const item = await db.orgMembershipSetting.findOne({ id: '', select: { allowExternalMembers: true, allowPrincipalOwnedApiKeys: true, apiKeyMaxDuration: true, createChildCascadeAdmins: true, createChildCascadeMembers: true, createChildCascadeOwners: true, createdAt: true, createdBy: true, createdByPrincipal: true, deleteMemberCascadeChildren: true, entityId: true, id: true, inviteProfileAssignmentMode: true, limitAllocationMode: true, populateMemberEmail: true, updatedAt: true, updatedBy: true, updatedByPrincipal: true } }).execute();
// Create
const created = await db.orgMembershipSetting.create({ data: { allowExternalMembers: '', allowPrincipalOwnedApiKeys: '', apiKeyMaxDuration: '', createChildCascadeAdmins: '', createChildCascadeMembers: '', createChildCascadeOwners: '', createdBy: '', createdByPrincipal: '', deleteMemberCascadeChildren: '', entityId: '', inviteProfileAssignmentMode: '', limitAllocationMode: '', populateMemberEmail: '', updatedBy: '