# ORM Client
## Setup
```typescript
import { createClient } from './orm';
const db = createClient({
endpoint: 'https://api.example.com/graphql',
headers: { Authorization: 'Bearer ' },
});
```
## Models
| Model | Operations |
|-------|------------|
| `api` | findMany, findOne, create, update, delete |
| `apiSchema` | findMany, findOne, create, update, delete |
| `apiSetting` | findMany, findOne, create, update, delete |
| `astMigration` | findMany, findOne, update, delete |
| `checkConstraint` | findMany, findOne, create, update, delete |
| `compositeType` | findMany, findOne, create, update, delete |
| `corsSetting` | findMany, findOne, create, update, delete |
| `database` | findMany, findOne, create, update, delete |
| `databaseSetting` | findMany, findOne, create, update, delete |
| `databaseTransfer` | findMany, findOne, create, update, delete |
| `defaultPrivilege` | findMany, findOne, create, update, delete |
| `derive` | findMany, findOne, create, update, delete |
| `domain` | findMany, findOne, create, update, delete |
| `domainEvent` | findMany, findOne, create, update, delete |
| `domainType` | findMany, findOne, create, update, delete |
| `domainVerification` | findMany, findOne, create, update, delete |
| `emailIdentity` | findMany, findOne, create, update, delete |
| `emailProviderAccount` | findMany, findOne, create, update, delete |
| `emailSiteIdentity` | findMany, findOne, create, update, delete |
| `embeddingChunk` | findMany, findOne, create, update, delete |
| `enum` | findMany, findOne, create, update, delete |
| `exclusionConstraint` | findMany, findOne, create, update, delete |
| `fieldBehavior` | findMany, findOne, create, update, delete |
| `field` | findMany, findOne, create, update, delete |
| `foreignKeyConstraintBehavior` | findMany, findOne, create, update, delete |
| `foreignKeyConstraint` | findMany, findOne, create, update, delete |
| `fullTextSearch` | findMany, findOne, create, update, delete |
| `function` | findMany, findOne, create, update, delete |
| `getSitePreviewsRecord` | findMany, findOne, update, delete |
| `identityProviderRegistry` | findMany, findOne, create, update, delete |
| `index` | findMany, findOne, create, update, delete |
| `listSuspendedDatabasesRecord` | findMany, findOne, update, delete |
| `managedDomain` | findMany, findOne, create, update, delete |
| `nodeTypeRegistry` | findMany, findOne, create, update, delete |
| `page` | findMany, findOne, create, update, delete |
| `partition` | findMany, findOne, create, update, delete |
| `platformApi` | findMany, findOne, create, update, delete |
| `platformApiSchema` | findMany, findOne, create, update, delete |
| `platformApiSetting` | findMany, findOne, create, update, delete |
| `platformCorsSetting` | findMany, findOne, create, update, delete |
| `platformDomain` | findMany, findOne, create, update, delete |
| `platformDomainEvent` | findMany, findOne, create, update, delete |
| `platformDomainVerification` | findMany, findOne, create, update, delete |
| `platformEmailIdentity` | findMany, findOne, create, update, delete |
| `platformEmailProviderAccount` | findMany, findOne, create, update, delete |
| `platformEmailSiteIdentity` | findMany, findOne, create, update, delete |
| `platformGetSitePreviewsRecord` | findMany, findOne, update, delete |
| `platformManagedDomain` | findMany, findOne, create, update, delete |
| `platformPage` | findMany, findOne, create, update, delete |
| `platformReservedSubdomain` | findMany, findOne, create, update, delete |
| `platformSiteAppLink` | findMany, findOne, create, update, delete |
| `platformSite` | findMany, findOne, create, update, delete |
| `platformSiteDeepLink` | findMany, findOne, create, update, delete |
| `platformSiteErrorPage` | findMany, findOne, create, update, delete |
| `platformSiteMetadatum` | findMany, findOne, create, update, delete |
| `platformSiteModule` | findMany, findOne, create, update, delete |
| `platformSiteRelease` | findMany, findOne, create, update, delete |
| `platformSiteTheme` | findMany, findOne, create, update, delete |
| `platformSiteWebConfig` | findMany, findOne, create, update, delete |
| `policy` | findMany, findOne, create, update, delete |
| `primaryKeyConstraint` | findMany, findOne, create, update, delete |
| `pubkeySetting` | findMany, findOne, create, update, delete |
| `redirect` | findMany, findOne, create, update, delete |
| `rlsSetting` | findMany, findOne, create, update, delete |
| `route` | findMany, findOne, create, update, delete |
| `schema` | findMany, findOne, create, update, delete |
| `schemaGrant` | findMany, findOne, create, update, delete |
| `siteAppLink` | findMany, findOne, create, update, delete |
| `site` | findMany, findOne, create, update, delete |
| `siteDeepLink` | findMany, findOne, create, update, delete |
| `siteErrorPage` | findMany, findOne, create, update, delete |
| `siteMetadatum` | findMany, findOne, create, update, delete |
| `siteModule` | findMany, findOne, create, update, delete |
| `siteRelease` | findMany, findOne, create, update, delete |
| `siteTheme` | findMany, findOne, create, update, delete |
| `siteWebConfig` | findMany, findOne, create, update, delete |
| `spatialRelation` | findMany, findOne, create, update, delete |
| `sqlAction` | findMany, findOne, update, delete |
| `tableBehavior` | findMany, findOne, create, update, delete |
| `table` | findMany, findOne, create, update, delete |
| `tableGrant` | findMany, findOne, create, update, delete |
| `trigger` | findMany, findOne, create, update, delete |
| `triggerFunction` | findMany, findOne, create, update, delete |
| `uniqueConstraintBehavior` | findMany, findOne, create, update, delete |
| `uniqueConstraint` | findMany, findOne, create, update, delete |
| `viewBehavior` | findMany, findOne, create, update, delete |
| `view` | findMany, findOne, create, update, delete |
| `viewGrant` | findMany, findOne, create, update, delete |
| `viewRule` | findMany, findOne, create, update, delete |
| `viewTable` | findMany, findOne, create, update, delete |
| `webauthnSetting` | findMany, findOne, create, update, delete |
## Table Operations
### `db.api`
CRUD operations for Api records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `anonRole` | String | Yes |
| `config` | JSON | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `id` | UUID | No |
| `isPublished` | Boolean | Yes |
| `name` | String | Yes |
| `roleName` | String | Yes |
| `serviceHostname` | String | No |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all api records
const items = await db.api.findMany({ select: { anonRole: true, config: true, createdAt: true, databaseId: true, id: true, isPublished: true, name: true, roleName: true, serviceHostname: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.api.findOne({ id: '', select: { anonRole: true, config: true, createdAt: true, databaseId: true, id: true, isPublished: true, name: true, roleName: true, serviceHostname: true, updatedAt: true } }).execute();
// Create
const created = await db.api.create({ data: { anonRole: '', config: '', databaseId: '', isPublished: '', name: '', roleName: '' }, select: { id: true } }).execute();
// Update
const updated = await db.api.update({ where: { id: '' }, data: { anonRole: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.api.delete({ where: { id: '' } }).execute();
```
### `db.apiSchema`
CRUD operations for ApiSchema records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `apiId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `id` | UUID | No |
| `schemaId` | UUID | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all apiSchema records
const items = await db.apiSchema.findMany({ select: { apiId: true, createdAt: true, databaseId: true, id: true, schemaId: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.apiSchema.findOne({ id: '', select: { apiId: true, createdAt: true, databaseId: true, id: true, schemaId: true, updatedAt: true } }).execute();
// Create
const created = await db.apiSchema.create({ data: { apiId: '', databaseId: '', schemaId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.apiSchema.update({ where: { id: '' }, data: { apiId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.apiSchema.delete({ where: { id: '' } }).execute();
```
### `db.apiSetting`
CRUD operations for ApiSetting records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `apiId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `enableAggregates` | Boolean | Yes |
| `enableBulk` | Boolean | Yes |
| `enableConnectionFilter` | Boolean | Yes |
| `enableI18N` | Boolean | Yes |
| `enableIntrospection` | Boolean | Yes |
| `enableLlm` | Boolean | Yes |
| `enableLtree` | Boolean | Yes |
| `enableManyToMany` | Boolean | Yes |
| `enablePostgis` | Boolean | Yes |
| `enablePresignedUploads` | Boolean | Yes |
| `enableRealtime` | Boolean | Yes |
| `enableSearch` | Boolean | Yes |
| `id` | UUID | No |
| `idleInTransactionTimeoutMs` | BigInt | Yes |
| `lockTimeoutMs` | BigInt | Yes |
| `maxConcurrentRequests` | Int | Yes |
| `maxPageSize` | Int | Yes |
| `maxQueryCost` | Int | Yes |
| `maxQueryDepth` | Int | Yes |
| `maxQueueWaitMs` | Int | Yes |
| `maxRequestBytes` | Int | Yes |
| `options` | JSON | Yes |
| `rateLimitBurst` | Int | Yes |
| `rateLimitRpm` | Int | Yes |
| `statementTimeoutMs` | BigInt | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all apiSetting records
const items = await db.apiSetting.findMany({ select: { apiId: true, createdAt: true, databaseId: true, enableAggregates: true, enableBulk: true, enableConnectionFilter: true, enableI18N: true, enableIntrospection: true, enableLlm: true, enableLtree: true, enableManyToMany: true, enablePostgis: true, enablePresignedUploads: true, enableRealtime: true, enableSearch: true, id: true, idleInTransactionTimeoutMs: true, lockTimeoutMs: true, maxConcurrentRequests: true, maxPageSize: true, maxQueryCost: true, maxQueryDepth: true, maxQueueWaitMs: true, maxRequestBytes: true, options: true, rateLimitBurst: true, rateLimitRpm: true, statementTimeoutMs: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.apiSetting.findOne({ id: '', select: { apiId: true, createdAt: true, databaseId: true, enableAggregates: true, enableBulk: true, enableConnectionFilter: true, enableI18N: true, enableIntrospection: true, enableLlm: true, enableLtree: true, enableManyToMany: true, enablePostgis: true, enablePresignedUploads: true, enableRealtime: true, enableSearch: true, id: true, idleInTransactionTimeoutMs: true, lockTimeoutMs: true, maxConcurrentRequests: true, maxPageSize: true, maxQueryCost: true, maxQueryDepth: true, maxQueueWaitMs: true, maxRequestBytes: true, options: true, rateLimitBurst: true, rateLimitRpm: true, statementTimeoutMs: true, updatedAt: true } }).execute();
// Create
const created = await db.apiSetting.create({ data: { apiId: '', databaseId: '', enableAggregates: '', enableBulk: '', enableConnectionFilter: '', enableI18N: '', enableIntrospection: '', enableLlm: '', enableLtree: '', enableManyToMany: '', enablePostgis: '', enablePresignedUploads: '', enableRealtime: '', enableSearch: '', idleInTransactionTimeoutMs: '', lockTimeoutMs: '', maxConcurrentRequests: '', maxPageSize: '', maxQueryCost: '', maxQueryDepth: '', maxQueueWaitMs: '', maxRequestBytes: '', options: '', rateLimitBurst: '', rateLimitRpm: '', statementTimeoutMs: '' }, select: { id: true } }).execute();
// Update
const updated = await db.apiSetting.update({ where: { id: '' }, data: { apiId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.apiSetting.delete({ where: { id: '' } }).execute();
```
### `db.astMigration`
CRUD operations for AstMigration records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actionId` | UUID | Yes |
| `actionName` | String | Yes |
| `actorId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `deploy` | JSON | Yes |
| `deploys` | String | Yes |
| `id` | Int | No |
| `name` | String | Yes |
| `payload` | JSON | Yes |
| `requires` | String | Yes |
| `revert` | JSON | Yes |
| `verify` | JSON | Yes |
**Operations:**
```typescript
// List all astMigration records
const items = await db.astMigration.findMany({ select: { actionId: true, actionName: true, actorId: true, createdAt: true, databaseId: true, deploy: true, deploys: true, id: true, name: true, payload: true, requires: true, revert: true, verify: true } }).execute();
// Get one by id
const item = await db.astMigration.findOne({ id: '', select: { actionId: true, actionName: true, actorId: true, createdAt: true, databaseId: true, deploy: true, deploys: true, id: true, name: true, payload: true, requires: true, revert: true, verify: true } }).execute();
// Update
const updated = await db.astMigration.update({ where: { id: '' }, data: { actionId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.astMigration.delete({ where: { id: '' } }).execute();
```
### `db.checkConstraint`
CRUD operations for CheckConstraint records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `category` | ObjectCategory | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `expr` | JSON | Yes |
| `fieldIds` | UUID | Yes |
| `id` | UUID | No |
| `initiallyDeferred` | Boolean | Yes |
| `isDeferrable` | Boolean | Yes |
| `name` | String | Yes |
| `smartTags` | JSON | Yes |
| `tableId` | UUID | Yes |
| `tags` | String | Yes |
| `type` | String | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all checkConstraint records
const items = await db.checkConstraint.findMany({ select: { category: true, createdAt: true, databaseId: true, expr: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.checkConstraint.findOne({ id: '', select: { category: true, createdAt: true, databaseId: true, expr: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true } }).execute();
// Create
const created = await db.checkConstraint.create({ data: { category: '', databaseId: '', expr: '', fieldIds: '', initiallyDeferred: '', isDeferrable: '', name: '', smartTags: '', tableId: '', tags: '', type: '' }, select: { id: true } }).execute();
// Update
const updated = await db.checkConstraint.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.checkConstraint.delete({ where: { id: '' } }).execute();
```
### `db.compositeType`
CRUD operations for CompositeType records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `attributes` | JSON | Yes |
| `category` | ObjectCategory | Yes |
| `databaseId` | UUID | Yes |
| `description` | String | Yes |
| `id` | UUID | No |
| `label` | String | Yes |
| `name` | String | Yes |
| `schemaId` | UUID | Yes |
| `smartTags` | JSON | Yes |
| `tags` | String | Yes |
**Operations:**
```typescript
// List all compositeType records
const items = await db.compositeType.findMany({ select: { attributes: true, category: true, databaseId: true, description: true, id: true, label: true, name: true, schemaId: true, smartTags: true, tags: true } }).execute();
// Get one by id
const item = await db.compositeType.findOne({ id: '', select: { attributes: true, category: true, databaseId: true, description: true, id: true, label: true, name: true, schemaId: true, smartTags: true, tags: true } }).execute();
// Create
const created = await db.compositeType.create({ data: { attributes: '', category: '', databaseId: '', description: '', label: '', name: '', schemaId: '', smartTags: '', tags: '' }, select: { id: true } }).execute();
// Update
const updated = await db.compositeType.update({ where: { id: '' }, data: { attributes: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.compositeType.delete({ where: { id: '' } }).execute();
```
### `db.corsSetting`
CRUD operations for CorsSetting records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `allowedOrigins` | String | Yes |
| `apiId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `id` | UUID | No |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all corsSetting records
const items = await db.corsSetting.findMany({ select: { allowedOrigins: true, apiId: true, createdAt: true, databaseId: true, id: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.corsSetting.findOne({ id: '', select: { allowedOrigins: true, apiId: true, createdAt: true, databaseId: true, id: true, updatedAt: true } }).execute();
// Create
const created = await db.corsSetting.create({ data: { allowedOrigins: '', apiId: '', databaseId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.corsSetting.update({ where: { id: '' }, data: { allowedOrigins: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.corsSetting.delete({ where: { id: '' } }).execute();
```
### `db.database`
CRUD operations for Database records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `hash` | UUID | Yes |
| `id` | UUID | No |
| `label` | String | Yes |
| `name` | String | Yes |
| `ownerId` | UUID | Yes |
| `platform` | Boolean | Yes |
| `suspendedAt` | Datetime | No |
| `suspendedReason` | String | No |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all database records
const items = await db.database.findMany({ select: { createdAt: true, hash: true, id: true, label: true, name: true, ownerId: true, platform: true, suspendedAt: true, suspendedReason: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.database.findOne({ id: '', select: { createdAt: true, hash: true, id: true, label: true, name: true, ownerId: true, platform: true, suspendedAt: true, suspendedReason: true, updatedAt: true } }).execute();
// Create
const created = await db.database.create({ data: { hash: '', label: '', name: '', ownerId: '', platform: '' }, select: { id: true } }).execute();
// Update
const updated = await db.database.update({ where: { id: '' }, data: { hash: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.database.delete({ where: { id: '' } }).execute();
```
### `db.databaseSetting`
CRUD operations for DatabaseSetting records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `annotations` | JSON | Yes |
| `createdAt` | Datetime | No |
| `creditsPerCent` | Int | Yes |
| `databaseId` | UUID | Yes |
| `enableAggregates` | Boolean | Yes |
| `enableBilling` | Boolean | Yes |
| `enableBulk` | Boolean | Yes |
| `enableConnectionFilter` | Boolean | Yes |
| `enableI18N` | Boolean | Yes |
| `enableIntrospection` | Boolean | Yes |
| `enableLlm` | Boolean | Yes |
| `enableLtree` | Boolean | Yes |
| `enableManyToMany` | Boolean | Yes |
| `enablePostgis` | Boolean | Yes |
| `enablePresignedUploads` | Boolean | Yes |
| `enableRealtime` | Boolean | Yes |
| `enableSearch` | Boolean | Yes |
| `id` | UUID | No |
| `idleInTransactionTimeoutMs` | BigInt | Yes |
| `labels` | JSON | Yes |
| `lockTimeoutMs` | BigInt | Yes |
| `maxConcurrentRequests` | Int | Yes |
| `maxPageSize` | Int | Yes |
| `maxQueryCost` | Int | Yes |
| `maxQueryDepth` | Int | Yes |
| `maxQueueWaitMs` | Int | Yes |
| `maxRequestBytes` | Int | Yes |
| `options` | JSON | Yes |
| `rateLimitBurst` | Int | Yes |
| `rateLimitRpm` | Int | Yes |
| `statementTimeoutMs` | BigInt | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all databaseSetting records
const items = await db.databaseSetting.findMany({ select: { annotations: true, createdAt: true, creditsPerCent: true, databaseId: true, enableAggregates: true, enableBilling: true, enableBulk: true, enableConnectionFilter: true, enableI18N: true, enableIntrospection: true, enableLlm: true, enableLtree: true, enableManyToMany: true, enablePostgis: true, enablePresignedUploads: true, enableRealtime: true, enableSearch: true, id: true, idleInTransactionTimeoutMs: true, labels: true, lockTimeoutMs: true, maxConcurrentRequests: true, maxPageSize: true, maxQueryCost: true, maxQueryDepth: true, maxQueueWaitMs: true, maxRequestBytes: true, options: true, rateLimitBurst: true, rateLimitRpm: true, statementTimeoutMs: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.databaseSetting.findOne({ id: '', select: { annotations: true, createdAt: true, creditsPerCent: true, databaseId: true, enableAggregates: true, enableBilling: true, enableBulk: true, enableConnectionFilter: true, enableI18N: true, enableIntrospection: true, enableLlm: true, enableLtree: true, enableManyToMany: true, enablePostgis: true, enablePresignedUploads: true, enableRealtime: true, enableSearch: true, id: true, idleInTransactionTimeoutMs: true, labels: true, lockTimeoutMs: true, maxConcurrentRequests: true, maxPageSize: true, maxQueryCost: true, maxQueryDepth: true, maxQueueWaitMs: true, maxRequestBytes: true, options: true, rateLimitBurst: true, rateLimitRpm: true, statementTimeoutMs: true, updatedAt: true } }).execute();
// Create
const created = await db.databaseSetting.create({ data: { annotations: '', creditsPerCent: '', databaseId: '', enableAggregates: '', enableBilling: '', enableBulk: '', enableConnectionFilter: '', enableI18N: '', enableIntrospection: '', enableLlm: '', enableLtree: '', enableManyToMany: '', enablePostgis: '', enablePresignedUploads: '', enableRealtime: '', enableSearch: '', idleInTransactionTimeoutMs: '', labels: '', lockTimeoutMs: '', maxConcurrentRequests: '', maxPageSize: '', maxQueryCost: '', maxQueryDepth: '', maxQueueWaitMs: '', maxRequestBytes: '', options: '', rateLimitBurst: '', rateLimitRpm: '', statementTimeoutMs: '' }, select: { id: true } }).execute();
// Update
const updated = await db.databaseSetting.update({ where: { id: '' }, data: { annotations: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.databaseSetting.delete({ where: { id: '' } }).execute();
```
### `db.databaseTransfer`
CRUD operations for DatabaseTransfer records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `completedAt` | Datetime | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `expiresAt` | Datetime | Yes |
| `id` | UUID | No |
| `initiatedBy` | UUID | Yes |
| `notes` | String | Yes |
| `sourceApproved` | Boolean | Yes |
| `sourceApprovedAt` | Datetime | Yes |
| `status` | String | Yes |
| `targetApproved` | Boolean | Yes |
| `targetApprovedAt` | Datetime | Yes |
| `targetOwnerId` | UUID | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all databaseTransfer records
const items = await db.databaseTransfer.findMany({ select: { completedAt: true, createdAt: true, databaseId: true, expiresAt: true, id: true, initiatedBy: true, notes: true, sourceApproved: true, sourceApprovedAt: true, status: true, targetApproved: true, targetApprovedAt: true, targetOwnerId: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.databaseTransfer.findOne({ id: '', select: { completedAt: true, createdAt: true, databaseId: true, expiresAt: true, id: true, initiatedBy: true, notes: true, sourceApproved: true, sourceApprovedAt: true, status: true, targetApproved: true, targetApprovedAt: true, targetOwnerId: true, updatedAt: true } }).execute();
// Create
const created = await db.databaseTransfer.create({ data: { completedAt: '', databaseId: '', expiresAt: '', initiatedBy: '', notes: '', sourceApproved: '', sourceApprovedAt: '', status: '', targetApproved: '', targetApprovedAt: '', targetOwnerId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.databaseTransfer.update({ where: { id: '' }, data: { completedAt: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.databaseTransfer.delete({ where: { id: '' } }).execute();
```
### `db.defaultPrivilege`
CRUD operations for DefaultPrivilege records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `databaseId` | UUID | Yes |
| `granteeName` | String | Yes |
| `id` | UUID | No |
| `isGrant` | Boolean | Yes |
| `objectType` | String | Yes |
| `privilege` | String | Yes |
| `schemaId` | UUID | Yes |
**Operations:**
```typescript
// List all defaultPrivilege records
const items = await db.defaultPrivilege.findMany({ select: { databaseId: true, granteeName: true, id: true, isGrant: true, objectType: true, privilege: true, schemaId: true } }).execute();
// Get one by id
const item = await db.defaultPrivilege.findOne({ id: '', select: { databaseId: true, granteeName: true, id: true, isGrant: true, objectType: true, privilege: true, schemaId: true } }).execute();
// Create
const created = await db.defaultPrivilege.create({ data: { databaseId: '', granteeName: '', isGrant: '', objectType: '', privilege: '', schemaId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.defaultPrivilege.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.defaultPrivilege.delete({ where: { id: '' } }).execute();
```
### `db.derive`
CRUD operations for Derive records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `id` | UUID | No |
| `includeGrants` | Boolean | Yes |
| `includeMutations` | Boolean | Yes |
| `kind` | String | Yes |
| `policyPrefix` | String | Yes |
| `sourceTableId` | UUID | Yes |
| `tableId` | UUID | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all derive records
const items = await db.derive.findMany({ select: { createdAt: true, databaseId: true, id: true, includeGrants: true, includeMutations: true, kind: true, policyPrefix: true, sourceTableId: true, tableId: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.derive.findOne({ id: '', select: { createdAt: true, databaseId: true, id: true, includeGrants: true, includeMutations: true, kind: true, policyPrefix: true, sourceTableId: true, tableId: true, updatedAt: true } }).execute();
// Create
const created = await db.derive.create({ data: { databaseId: '', includeGrants: '', includeMutations: '', kind: '', policyPrefix: '', sourceTableId: '', tableId: '' }, select: { id: true } }).execute();
// Update
const updated = await db.derive.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.derive.delete({ where: { id: '' } }).execute();
```
### `db.domain`
CRUD operations for Domain records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `config` | JSON | Yes |
| `createdAt` | Datetime | No |
| `createdByPrincipal` | UUID | Yes |
| `databaseId` | UUID | Yes |
| `hostname` | String | Yes |
| `id` | UUID | No |
| `isPublished` | Boolean | Yes |
| `isWildcard` | Boolean | Yes |
| `managed` | Boolean | Yes |
| `parentHostname` | String | Yes |
| `tlsReadyAt` | Datetime | Yes |
| `tlsSecretName` | String | Yes |
| `tlsStatus` | String | Yes |
| `updatedAt` | Datetime | No |
| `updatedByPrincipal` | UUID | Yes |
| `verificationStatus` | String | Yes |
| `verifiedAt` | Datetime | Yes |
**Operations:**
```typescript
// List all domain records
const items = await db.domain.findMany({ select: { config: true, createdAt: true, createdByPrincipal: true, databaseId: true, hostname: true, id: true, isPublished: true, isWildcard: true, managed: true, parentHostname: true, tlsReadyAt: true, tlsSecretName: true, tlsStatus: true, updatedAt: true, updatedByPrincipal: true, verificationStatus: true, verifiedAt: true } }).execute();
// Get one by id
const item = await db.domain.findOne({ id: '', select: { config: true, createdAt: true, createdByPrincipal: true, databaseId: true, hostname: true, id: true, isPublished: true, isWildcard: true, managed: true, parentHostname: true, tlsReadyAt: true, tlsSecretName: true, tlsStatus: true, updatedAt: true, updatedByPrincipal: true, verificationStatus: true, verifiedAt: true } }).execute();
// Create
const created = await db.domain.create({ data: { config: '', createdByPrincipal: '', databaseId: '', hostname: '', isPublished: '', isWildcard: '', managed: '', parentHostname: '', tlsReadyAt: '', tlsSecretName: '', tlsStatus: '', updatedByPrincipal: '', verificationStatus: '', verifiedAt: '' }, select: { id: true } }).execute();
// Update
const updated = await db.domain.update({ where: { id: '' }, data: { config: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.domain.delete({ where: { id: '' } }).execute();
```
### `db.domainEvent`
CRUD operations for DomainEvent records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `actorId` | UUID | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `domainId` | UUID | Yes |
| `domainVerificationId` | UUID | Yes |
| `eventType` | String | Yes |
| `id` | UUID | No |
| `managedDomainId` | UUID | Yes |
| `message` | String | Yes |
| `metadata` | JSON | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all domainEvent records
const items = await db.domainEvent.findMany({ select: { actorId: true, createdAt: true, databaseId: true, domainId: true, domainVerificationId: true, eventType: true, id: true, managedDomainId: true, message: true, metadata: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.domainEvent.findOne({ id: '', select: { actorId: true, createdAt: true, databaseId: true, domainId: true, domainVerificationId: true, eventType: true, id: true, managedDomainId: true, message: true, metadata: true, updatedAt: true } }).execute();
// Create
const created = await db.domainEvent.create({ data: { actorId: '', databaseId: '', domainId: '', domainVerificationId: '', eventType: '', managedDomainId: '', message: '', metadata: '' }, select: { id: true } }).execute();
// Update
const updated = await db.domainEvent.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.domainEvent.delete({ where: { id: '' } }).execute();
```
### `db.domainType`
CRUD operations for DomainType records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `baseType` | JSON | Yes |
| `category` | ObjectCategory | Yes |
| `checkExpr` | JSON | Yes |
| `databaseId` | UUID | Yes |
| `defaultExpr` | JSON | Yes |
| `description` | String | Yes |
| `id` | UUID | No |
| `label` | String | Yes |
| `name` | String | Yes |
| `notNull` | Boolean | Yes |
| `schemaId` | UUID | Yes |
| `smartTags` | JSON | Yes |
| `tags` | String | Yes |
**Operations:**
```typescript
// List all domainType records
const items = await db.domainType.findMany({ select: { baseType: true, category: true, checkExpr: true, databaseId: true, defaultExpr: true, description: true, id: true, label: true, name: true, notNull: true, schemaId: true, smartTags: true, tags: true } }).execute();
// Get one by id
const item = await db.domainType.findOne({ id: '', select: { baseType: true, category: true, checkExpr: true, databaseId: true, defaultExpr: true, description: true, id: true, label: true, name: true, notNull: true, schemaId: true, smartTags: true, tags: true } }).execute();
// Create
const created = await db.domainType.create({ data: { baseType: '', category: '', checkExpr: '', databaseId: '', defaultExpr: '', description: '', label: '', name: '', notNull: '', schemaId: '', smartTags: '', tags: '' }, select: { id: true } }).execute();
// Update
const updated = await db.domainType.update({ where: { id: '' }, data: { baseType: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.domainType.delete({ where: { id: '' } }).execute();
```
### `db.domainVerification`
CRUD operations for DomainVerification records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `attempts` | Int | Yes |
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `domainId` | UUID | Yes |
| `error` | String | Yes |
| `expiresAt` | Datetime | Yes |
| `id` | UUID | No |
| `lastCheckedAt` | Datetime | Yes |
| `managedDomainId` | UUID | Yes |
| `method` | String | Yes |
| `recordName` | String | Yes |
| `recordType` | String | Yes |
| `recordValue` | String | Yes |
| `status` | String | Yes |
| `updatedAt` | Datetime | No |
| `verifiedAt` | Datetime | Yes |
**Operations:**
```typescript
// List all domainVerification records
const items = await db.domainVerification.findMany({ select: { attempts: true, createdAt: true, databaseId: true, domainId: true, error: true, expiresAt: true, id: true, lastCheckedAt: true, managedDomainId: true, method: true, recordName: true, recordType: true, recordValue: true, status: true, updatedAt: true, verifiedAt: true } }).execute();
// Get one by id
const item = await db.domainVerification.findOne({ id: '', select: { attempts: true, createdAt: true, databaseId: true, domainId: true, error: true, expiresAt: true, id: true, lastCheckedAt: true, managedDomainId: true, method: true, recordName: true, recordType: true, recordValue: true, status: true, updatedAt: true, verifiedAt: true } }).execute();
// Create
const created = await db.domainVerification.create({ data: { attempts: '', databaseId: '', domainId: '', error: '', expiresAt: '', lastCheckedAt: '', managedDomainId: '', method: '', recordName: '', recordType: '', recordValue: '', status: '', verifiedAt: '' }, select: { id: true } }).execute();
// Update
const updated = await db.domainVerification.update({ where: { id: '' }, data: { attempts: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.domainVerification.delete({ where: { id: '' } }).execute();
```
### `db.emailIdentity`
CRUD operations for EmailIdentity records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `databaseId` | UUID | Yes |
| `fromAddress` | String | Yes |
| `fromName` | String | Yes |
| `id` | UUID | No |
| `isActive` | Boolean | Yes |
| `isDefault` | Boolean | Yes |
| `name` | String | Yes |
| `providerAccountId` | UUID | Yes |
| `replyToAddress` | String | Yes |
| `supportAddress` | String | Yes |
| `transportMode` | String | Yes |
| `updatedAt` | Datetime | No |
**Operations:**
```typescript
// List all emailIdentity records
const items = await db.emailIdentity.findMany({ select: { createdAt: true, databaseId: true, fromAddress: true, fromName: true, id: true, isActive: true, isDefault: true, name: true, providerAccountId: true, replyToAddress: true, supportAddress: true, transportMode: true, updatedAt: true } }).execute();
// Get one by id
const item = await db.emailIdentity.findOne({ id: '', select: { createdAt: true, databaseId: true, fromAddress: true, fromName: true, id: true, isActive: true, isDefault: true, name: true, providerAccountId: true, replyToAddress: true, supportAddress: true, transportMode: true, updatedAt: true } }).execute();
// Create
const created = await db.emailIdentity.create({ data: { databaseId: '', fromAddress: '', fromName: '', isActive: '', isDefault: '', name: '', providerAccountId: '', replyToAddress: '', supportAddress: '', transportMode: '' }, select: { id: true } }).execute();
// Update
const updated = await db.emailIdentity.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute();
// Delete
const deleted = await db.emailIdentity.delete({ where: { id: '' } }).execute();
```
### `db.emailProviderAccount`
CRUD operations for EmailProviderAccount records.
**Fields:**
| Field | Type | Editable |
|-------|------|----------|
| `createdAt` | Datetime | No |
| `credentialsSecretName` | String | Yes |
| `databaseId` | UUID | Yes |
| `id` | UUID | No |
| `isActive` | Boolean | Yes |
| `name` | String | Yes |
| `provider` | String | Yes |
| `providerAccountName` | String | Yes |
| `region` | String | Yes |
| `smtpHost` | String | Yes |
| `smtpPort` | Int | Yes |
| `smtpSecure` | Boolean | Yes |
| `smtpUser` | String | Yes |
| `updatedAt` | Datetime | No |
| `webhookSigningSecretName` | String | Yes |
**Operations:**
```typescript
// List all emailProviderAccount records
const items = await db.emailProviderAccount.findMany({ select: { createdAt: true, credentialsSecretName: true, databaseId: true, id: true, isActive: true, name: true, provider: true, providerAccountName: true, region: true, smtpHost: true, smtpPort: true, smtpSecure: true, smtpUser: true, updatedAt: true, webhookSigningSecretName: true } }).execute();
// Get one by id
const item = await db.emailProviderAccount.findOne({ id: '', select: { createdAt: true, credentialsSecretName: true, databaseId: true, id: true, isActive: true, name: true, provider: true, providerAccountName: true, region: true, smtpHost: true, smtpPort: true, smtpSecure: true, smtpUser: true, updatedAt: true, webhookSigningSecretName: true } }).execute();
// Create
const created = await db.emailProviderAccount.create({ data: { credentialsSecretName: '', databaseId: '', isActive: '', name: '', provider: '', providerAccountName: '', region: '', smtpHost: '', smtpPort: '', smtpSecure: '', smtpUser: '', webhookSigningSecretName: '