# 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: '' }, select: { id: true } }).execute(); // Update const updated = await db.emailProviderAccount.update({ where: { id: '' }, data: { credentialsSecretName: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.emailProviderAccount.delete({ where: { id: '' } }).execute(); ``` ### `db.emailSiteIdentity` CRUD operations for EmailSiteIdentity records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `emailIdentityId` | UUID | Yes | | `id` | UUID | No | | `siteId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all emailSiteIdentity records const items = await db.emailSiteIdentity.findMany({ select: { createdAt: true, databaseId: true, emailIdentityId: true, id: true, siteId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.emailSiteIdentity.findOne({ id: '', select: { createdAt: true, databaseId: true, emailIdentityId: true, id: true, siteId: true, updatedAt: true } }).execute(); // Create const created = await db.emailSiteIdentity.create({ data: { databaseId: '', emailIdentityId: '', siteId: '' }, select: { id: true } }).execute(); // Update const updated = await db.emailSiteIdentity.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.emailSiteIdentity.delete({ where: { id: '' } }).execute(); ``` ### `db.embeddingChunk` CRUD operations for EmbeddingChunk records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `chunkOverlap` | Int | Yes | | `chunkSize` | Int | Yes | | `chunkStrategy` | String | Yes | | `chunkingTaskName` | String | Yes | | `chunksTableId` | UUID | Yes | | `chunksTableName` | String | Yes | | `contentFieldName` | String | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `dimensions` | Int | Yes | | `embeddingFieldId` | UUID | Yes | | `embeddingModel` | String | Yes | | `embeddingProvider` | String | Yes | | `enqueueChunkingJob` | Boolean | Yes | | `id` | UUID | No | | `metadataFields` | JSON | Yes | | `metric` | String | Yes | | `parentFkFieldId` | UUID | Yes | | `searchIndexes` | JSON | Yes | | `sourceFields` | JSON | Yes | | `tableId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all embeddingChunk records const items = await db.embeddingChunk.findMany({ select: { chunkOverlap: true, chunkSize: true, chunkStrategy: true, chunkingTaskName: true, chunksTableId: true, chunksTableName: true, contentFieldName: true, createdAt: true, databaseId: true, dimensions: true, embeddingFieldId: true, embeddingModel: true, embeddingProvider: true, enqueueChunkingJob: true, id: true, metadataFields: true, metric: true, parentFkFieldId: true, searchIndexes: true, sourceFields: true, tableId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.embeddingChunk.findOne({ id: '', select: { chunkOverlap: true, chunkSize: true, chunkStrategy: true, chunkingTaskName: true, chunksTableId: true, chunksTableName: true, contentFieldName: true, createdAt: true, databaseId: true, dimensions: true, embeddingFieldId: true, embeddingModel: true, embeddingProvider: true, enqueueChunkingJob: true, id: true, metadataFields: true, metric: true, parentFkFieldId: true, searchIndexes: true, sourceFields: true, tableId: true, updatedAt: true } }).execute(); // Create const created = await db.embeddingChunk.create({ data: { chunkOverlap: '', chunkSize: '', chunkStrategy: '', chunkingTaskName: '', chunksTableId: '', chunksTableName: '', contentFieldName: '', databaseId: '', dimensions: '', embeddingFieldId: '', embeddingModel: '', embeddingProvider: '', enqueueChunkingJob: '', metadataFields: '', metric: '', parentFkFieldId: '', searchIndexes: '', sourceFields: '', tableId: '' }, select: { id: true } }).execute(); // Update const updated = await db.embeddingChunk.update({ where: { id: '' }, data: { chunkOverlap: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.embeddingChunk.delete({ where: { id: '' } }).execute(); ``` ### `db.enum` CRUD operations for Enum records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `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 | | `values` | String | Yes | **Operations:** ```typescript // List all enum records const items = await db.enum.findMany({ select: { category: true, databaseId: true, description: true, id: true, label: true, name: true, schemaId: true, smartTags: true, tags: true, values: true } }).execute(); // Get one by id const item = await db.enum.findOne({ id: '', select: { category: true, databaseId: true, description: true, id: true, label: true, name: true, schemaId: true, smartTags: true, tags: true, values: true } }).execute(); // Create const created = await db.enum.create({ data: { category: '', databaseId: '', description: '', label: '', name: '', schemaId: '', smartTags: '', tags: '', values: '' }, select: { id: true } }).execute(); // Update const updated = await db.enum.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.enum.delete({ where: { id: '' } }).execute(); ``` ### `db.exclusionConstraint` CRUD operations for ExclusionConstraint records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `accessMethod` | String | Yes | | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `elementExpr` | JSON | Yes | | `fieldIds` | UUID | Yes | | `id` | UUID | No | | `name` | String | Yes | | `operators` | String | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `type` | String | Yes | | `updatedAt` | Datetime | No | | `whereClause` | JSON | Yes | **Operations:** ```typescript // List all exclusionConstraint records const items = await db.exclusionConstraint.findMany({ select: { accessMethod: true, category: true, createdAt: true, databaseId: true, elementExpr: true, fieldIds: true, id: true, name: true, operators: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true, whereClause: true } }).execute(); // Get one by id const item = await db.exclusionConstraint.findOne({ id: '', select: { accessMethod: true, category: true, createdAt: true, databaseId: true, elementExpr: true, fieldIds: true, id: true, name: true, operators: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true, whereClause: true } }).execute(); // Create const created = await db.exclusionConstraint.create({ data: { accessMethod: '', category: '', databaseId: '', elementExpr: '', fieldIds: '', name: '', operators: '', smartTags: '', tableId: '', tags: '', type: '', whereClause: '' }, select: { id: true } }).execute(); // Update const updated = await db.exclusionConstraint.update({ where: { id: '' }, data: { accessMethod: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.exclusionConstraint.delete({ where: { id: '' } }).execute(); ``` ### `db.fieldBehavior` CRUD operations for FieldBehavior records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `fieldId` | UUID | Yes | | `id` | UUID | No | | `modifier` | String | Yes | | `scope` | String | Yes | | `sortOrder` | Int | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all fieldBehavior records const items = await db.fieldBehavior.findMany({ select: { createdAt: true, databaseId: true, fieldId: true, id: true, modifier: true, scope: true, sortOrder: true, updatedAt: true } }).execute(); // Get one by id const item = await db.fieldBehavior.findOne({ id: '', select: { createdAt: true, databaseId: true, fieldId: true, id: true, modifier: true, scope: true, sortOrder: true, updatedAt: true } }).execute(); // Create const created = await db.fieldBehavior.create({ data: { databaseId: '', fieldId: '', modifier: '', scope: '', sortOrder: '' }, select: { id: true } }).execute(); // Update const updated = await db.fieldBehavior.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.fieldBehavior.delete({ where: { id: '' } }).execute(); ``` ### `db.field` CRUD operations for Field records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `apiRequired` | Boolean | Yes | | `category` | ObjectCategory | Yes | | `chk` | JSON | Yes | | `chkExpr` | JSON | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `defaultValue` | JSON | Yes | | `description` | String | Yes | | `fieldOrder` | Int | Yes | | `generationExpression` | JSON | Yes | | `generationType` | String | Yes | | `id` | UUID | No | | `identityGeneration` | String | Yes | | `identityOptions` | JSON | Yes | | `isRequired` | Boolean | Yes | | `label` | String | Yes | | `max` | Float | Yes | | `min` | Float | Yes | | `name` | String | Yes | | `regexp` | String | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `type` | JSON | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all field records const items = await db.field.findMany({ select: { apiRequired: true, category: true, chk: true, chkExpr: true, createdAt: true, databaseId: true, defaultValue: true, description: true, fieldOrder: true, generationExpression: true, generationType: true, id: true, identityGeneration: true, identityOptions: true, isRequired: true, label: true, max: true, min: true, name: true, regexp: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true } }).execute(); // Get one by id const item = await db.field.findOne({ id: '', select: { apiRequired: true, category: true, chk: true, chkExpr: true, createdAt: true, databaseId: true, defaultValue: true, description: true, fieldOrder: true, generationExpression: true, generationType: true, id: true, identityGeneration: true, identityOptions: true, isRequired: true, label: true, max: true, min: true, name: true, regexp: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true } }).execute(); // Create const created = await db.field.create({ data: { apiRequired: '', category: '', chk: '', chkExpr: '', databaseId: '', defaultValue: '', description: '', fieldOrder: '', generationExpression: '', generationType: '', identityGeneration: '', identityOptions: '', isRequired: '', label: '', max: '', min: '', name: '', regexp: '', smartTags: '', tableId: '', tags: '', type: '' }, select: { id: true } }).execute(); // Update const updated = await db.field.update({ where: { id: '' }, data: { apiRequired: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.field.delete({ where: { id: '' } }).execute(); ``` ### `db.foreignKeyConstraintBehavior` CRUD operations for ForeignKeyConstraintBehavior records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `foreignKeyConstraintId` | UUID | Yes | | `id` | UUID | No | | `modifier` | String | Yes | | `scope` | String | Yes | | `sortOrder` | Int | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all foreignKeyConstraintBehavior records const items = await db.foreignKeyConstraintBehavior.findMany({ select: { createdAt: true, databaseId: true, foreignKeyConstraintId: true, id: true, modifier: true, scope: true, sortOrder: true, updatedAt: true } }).execute(); // Get one by id const item = await db.foreignKeyConstraintBehavior.findOne({ id: '', select: { createdAt: true, databaseId: true, foreignKeyConstraintId: true, id: true, modifier: true, scope: true, sortOrder: true, updatedAt: true } }).execute(); // Create const created = await db.foreignKeyConstraintBehavior.create({ data: { databaseId: '', foreignKeyConstraintId: '', modifier: '', scope: '', sortOrder: '' }, select: { id: true } }).execute(); // Update const updated = await db.foreignKeyConstraintBehavior.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.foreignKeyConstraintBehavior.delete({ where: { id: '' } }).execute(); ``` ### `db.foreignKeyConstraint` CRUD operations for ForeignKeyConstraint records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `deleteAction` | String | Yes | | `deleteSetFieldIds` | UUID | Yes | | `description` | String | Yes | | `fieldIds` | UUID | Yes | | `id` | UUID | No | | `initiallyDeferred` | Boolean | Yes | | `isDeferrable` | Boolean | Yes | | `name` | String | Yes | | `refFieldIds` | UUID | Yes | | `refTableId` | UUID | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `type` | String | Yes | | `updateAction` | String | Yes | | `updatedAt` | Datetime | No | | `withPeriod` | Boolean | Yes | **Operations:** ```typescript // List all foreignKeyConstraint records const items = await db.foreignKeyConstraint.findMany({ select: { category: true, createdAt: true, databaseId: true, deleteAction: true, deleteSetFieldIds: true, description: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, refFieldIds: true, refTableId: true, smartTags: true, tableId: true, tags: true, type: true, updateAction: true, updatedAt: true, withPeriod: true } }).execute(); // Get one by id const item = await db.foreignKeyConstraint.findOne({ id: '', select: { category: true, createdAt: true, databaseId: true, deleteAction: true, deleteSetFieldIds: true, description: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, refFieldIds: true, refTableId: true, smartTags: true, tableId: true, tags: true, type: true, updateAction: true, updatedAt: true, withPeriod: true } }).execute(); // Create const created = await db.foreignKeyConstraint.create({ data: { category: '', databaseId: '', deleteAction: '', deleteSetFieldIds: '', description: '', fieldIds: '', initiallyDeferred: '', isDeferrable: '', name: '', refFieldIds: '', refTableId: '', smartTags: '', tableId: '', tags: '', type: '', updateAction: '', withPeriod: '' }, select: { id: true } }).execute(); // Update const updated = await db.foreignKeyConstraint.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.foreignKeyConstraint.delete({ where: { id: '' } }).execute(); ``` ### `db.fullTextSearch` CRUD operations for FullTextSearch records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `fieldId` | UUID | Yes | | `fieldIds` | UUID | Yes | | `id` | UUID | No | | `langColumn` | String | Yes | | `langs` | String | Yes | | `tableId` | UUID | Yes | | `updatedAt` | Datetime | No | | `weights` | String | Yes | **Operations:** ```typescript // List all fullTextSearch records const items = await db.fullTextSearch.findMany({ select: { createdAt: true, databaseId: true, fieldId: true, fieldIds: true, id: true, langColumn: true, langs: true, tableId: true, updatedAt: true, weights: true } }).execute(); // Get one by id const item = await db.fullTextSearch.findOne({ id: '', select: { createdAt: true, databaseId: true, fieldId: true, fieldIds: true, id: true, langColumn: true, langs: true, tableId: true, updatedAt: true, weights: true } }).execute(); // Create const created = await db.fullTextSearch.create({ data: { databaseId: '', fieldId: '', fieldIds: '', langColumn: '', langs: '', tableId: '', weights: '' }, select: { id: true } }).execute(); // Update const updated = await db.fullTextSearch.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.fullTextSearch.delete({ where: { id: '' } }).execute(); ``` ### `db.function` CRUD operations for Function records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `apiExposed` | Boolean | Yes | | `arguments` | JSON | Yes | | `bodyAst` | JSON | Yes | | `category` | ObjectCategory | Yes | | `data` | JSON | Yes | | `databaseId` | UUID | Yes | | `functionType` | String | Yes | | `id` | UUID | No | | `isStrict` | Boolean | Yes | | `kind` | String | Yes | | `name` | String | Yes | | `returns` | JSON | Yes | | `schemaId` | UUID | Yes | | `securityInvoker` | Boolean | Yes | | `smartTags` | JSON | Yes | | `tags` | String | Yes | | `volatility` | String | Yes | **Operations:** ```typescript // List all function records const items = await db.function.findMany({ select: { apiExposed: true, arguments: true, bodyAst: true, category: true, data: true, databaseId: true, functionType: true, id: true, isStrict: true, kind: true, name: true, returns: true, schemaId: true, securityInvoker: true, smartTags: true, tags: true, volatility: true } }).execute(); // Get one by id const item = await db.function.findOne({ id: '', select: { apiExposed: true, arguments: true, bodyAst: true, category: true, data: true, databaseId: true, functionType: true, id: true, isStrict: true, kind: true, name: true, returns: true, schemaId: true, securityInvoker: true, smartTags: true, tags: true, volatility: true } }).execute(); // Create const created = await db.function.create({ data: { apiExposed: '', arguments: '', bodyAst: '', category: '', data: '', databaseId: '', functionType: '', isStrict: '', kind: '', name: '', returns: '', schemaId: '', securityInvoker: '', smartTags: '', tags: '', volatility: '' }, select: { id: true } }).execute(); // Update const updated = await db.function.update({ where: { id: '' }, data: { apiExposed: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.function.delete({ where: { id: '' } }).execute(); ``` ### `db.getSitePreviewsRecord` CRUD operations for GetSitePreviewsRecord records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `name` | String | Yes | **Operations:** ```typescript // List all getSitePreviewsRecord records const items = await db.getSitePreviewsRecord.findMany({ select: { commitId: true, name: true } }).execute(); // Get one by id const item = await db.getSitePreviewsRecord.findOne({ id: '', select: { commitId: true, name: true } }).execute(); // Update const updated = await db.getSitePreviewsRecord.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.getSitePreviewsRecord.delete({ where: { id: '' } }).execute(); ``` ### `db.identityProviderRegistry` CRUD operations for IdentityProviderRegistry records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `authorizationUrl` | String | Yes | | `displayName` | String | Yes | | `issuerUrl` | String | Yes | | `kind` | String | Yes | | `scopes` | String | Yes | | `slug` | String | No | | `tokenUrl` | String | Yes | | `userinfoUrl` | String | Yes | **Operations:** ```typescript // List all identityProviderRegistry records const items = await db.identityProviderRegistry.findMany({ select: { authorizationUrl: true, displayName: true, issuerUrl: true, kind: true, scopes: true, slug: true, tokenUrl: true, userinfoUrl: true } }).execute(); // Get one by slug const item = await db.identityProviderRegistry.findOne({ slug: '', select: { authorizationUrl: true, displayName: true, issuerUrl: true, kind: true, scopes: true, slug: true, tokenUrl: true, userinfoUrl: true } }).execute(); // Create const created = await db.identityProviderRegistry.create({ data: { authorizationUrl: '', displayName: '', issuerUrl: '', kind: '', scopes: '', tokenUrl: '', userinfoUrl: '' }, select: { slug: true } }).execute(); // Update const updated = await db.identityProviderRegistry.update({ where: { slug: '' }, data: { authorizationUrl: '' }, select: { slug: true } }).execute(); // Delete const deleted = await db.identityProviderRegistry.delete({ where: { slug: '' } }).execute(); ``` ### `db.index` CRUD operations for Index records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `accessMethod` | String | Yes | | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `fieldIds` | UUID | Yes | | `id` | UUID | No | | `includeFieldIds` | UUID | Yes | | `indexParams` | JSON | Yes | | `isUnique` | Boolean | Yes | | `name` | String | Yes | | `nullsNotDistinct` | Boolean | Yes | | `opClasses` | String | Yes | | `options` | JSON | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `updatedAt` | Datetime | No | | `whereClause` | JSON | Yes | **Operations:** ```typescript // List all index records const items = await db.index.findMany({ select: { accessMethod: true, category: true, createdAt: true, databaseId: true, fieldIds: true, id: true, includeFieldIds: true, indexParams: true, isUnique: true, name: true, nullsNotDistinct: true, opClasses: true, options: true, smartTags: true, tableId: true, tags: true, updatedAt: true, whereClause: true } }).execute(); // Get one by id const item = await db.index.findOne({ id: '', select: { accessMethod: true, category: true, createdAt: true, databaseId: true, fieldIds: true, id: true, includeFieldIds: true, indexParams: true, isUnique: true, name: true, nullsNotDistinct: true, opClasses: true, options: true, smartTags: true, tableId: true, tags: true, updatedAt: true, whereClause: true } }).execute(); // Create const created = await db.index.create({ data: { accessMethod: '', category: '', databaseId: '', fieldIds: '', includeFieldIds: '', indexParams: '', isUnique: '', name: '', nullsNotDistinct: '', opClasses: '', options: '', smartTags: '', tableId: '', tags: '', whereClause: '' }, select: { id: true } }).execute(); // Update const updated = await db.index.update({ where: { id: '' }, data: { accessMethod: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.index.delete({ where: { id: '' } }).execute(); ``` ### `db.listSuspendedDatabasesRecord` CRUD operations for ListSuspendedDatabasesRecord records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `id` | UUID | No | | `name` | String | Yes | | `ownerId` | UUID | Yes | | `suspendedAt` | Datetime | Yes | | `suspendedReason` | String | Yes | **Operations:** ```typescript // List all listSuspendedDatabasesRecord records const items = await db.listSuspendedDatabasesRecord.findMany({ select: { id: true, name: true, ownerId: true, suspendedAt: true, suspendedReason: true } }).execute(); // Get one by id const item = await db.listSuspendedDatabasesRecord.findOne({ id: '', select: { id: true, name: true, ownerId: true, suspendedAt: true, suspendedReason: true } }).execute(); // Update const updated = await db.listSuspendedDatabasesRecord.update({ where: { id: '' }, data: { name: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.listSuspendedDatabasesRecord.delete({ where: { id: '' } }).execute(); ``` ### `db.managedDomain` CRUD operations for ManagedDomain records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `allowPublicUsage` | Boolean | Yes | | `annotations` | JSON | Yes | | `certStatus` | String | Yes | | `createdAt` | Datetime | No | | `createdByPrincipal` | UUID | Yes | | `databaseId` | UUID | Yes | | `domain` | String | Yes | | `id` | UUID | No | | `isWildcard` | Boolean | Yes | | `publicPort` | Int | Yes | | `tlsReadyAt` | Datetime | Yes | | `tlsStatus` | String | Yes | | `updatedAt` | Datetime | No | | `updatedByPrincipal` | UUID | Yes | | `verificationStatus` | String | Yes | | `verifiedAt` | Datetime | Yes | **Operations:** ```typescript // List all managedDomain records const items = await db.managedDomain.findMany({ select: { allowPublicUsage: true, annotations: true, certStatus: true, createdAt: true, createdByPrincipal: true, databaseId: true, domain: true, id: true, isWildcard: true, publicPort: true, tlsReadyAt: true, tlsStatus: true, updatedAt: true, updatedByPrincipal: true, verificationStatus: true, verifiedAt: true } }).execute(); // Get one by id const item = await db.managedDomain.findOne({ id: '', select: { allowPublicUsage: true, annotations: true, certStatus: true, createdAt: true, createdByPrincipal: true, databaseId: true, domain: true, id: true, isWildcard: true, publicPort: true, tlsReadyAt: true, tlsStatus: true, updatedAt: true, updatedByPrincipal: true, verificationStatus: true, verifiedAt: true } }).execute(); // Create const created = await db.managedDomain.create({ data: { allowPublicUsage: '', annotations: '', certStatus: '', createdByPrincipal: '', databaseId: '', domain: '', isWildcard: '', publicPort: '', tlsReadyAt: '', tlsStatus: '', updatedByPrincipal: '', verificationStatus: '', verifiedAt: '' }, select: { id: true } }).execute(); // Update const updated = await db.managedDomain.update({ where: { id: '' }, data: { allowPublicUsage: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.managedDomain.delete({ where: { id: '' } }).execute(); ``` ### `db.nodeTypeRegistry` CRUD operations for NodeTypeRegistry records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | String | Yes | | `description` | String | Yes | | `displayName` | String | Yes | | `name` | String | No | | `parameterSchema` | JSON | Yes | | `slug` | String | Yes | | `tags` | String | Yes | **Operations:** ```typescript // List all nodeTypeRegistry records const items = await db.nodeTypeRegistry.findMany({ select: { category: true, description: true, displayName: true, name: true, parameterSchema: true, slug: true, tags: true } }).execute(); // Get one by name const item = await db.nodeTypeRegistry.findOne({ name: '', select: { category: true, description: true, displayName: true, name: true, parameterSchema: true, slug: true, tags: true } }).execute(); // Create const created = await db.nodeTypeRegistry.create({ data: { category: '', description: '', displayName: '', parameterSchema: '', slug: '', tags: '' }, select: { name: true } }).execute(); // Update const updated = await db.nodeTypeRegistry.update({ where: { name: '' }, data: { category: '' }, select: { name: true } }).execute(); // Delete const deleted = await db.nodeTypeRegistry.delete({ where: { name: '' } }).execute(); ``` ### `db.page` CRUD operations for Page records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `content` | JSON | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `seededFrom` | JSON | Yes | | `siteId` | UUID | Yes | | `slug` | String | Yes | | `storeId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all page records const items = await db.page.findMany({ select: { commitId: true, content: true, createdAt: true, databaseId: true, id: true, seededFrom: true, siteId: true, slug: true, storeId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.page.findOne({ id: '', select: { commitId: true, content: true, createdAt: true, databaseId: true, id: true, seededFrom: true, siteId: true, slug: true, storeId: true, updatedAt: true } }).execute(); // Create const created = await db.page.create({ data: { commitId: '', content: '', databaseId: '', seededFrom: '', siteId: '', slug: '', storeId: '' }, select: { id: true } }).execute(); // Update const updated = await db.page.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.page.delete({ where: { id: '' } }).execute(); ``` ### `db.partition` CRUD operations for Partition records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `interval` | String | Yes | | `isParented` | Boolean | Yes | | `namingPattern` | String | Yes | | `partitionKeyId` | UUID | Yes | | `premake` | Int | Yes | | `retention` | String | Yes | | `retentionKeepTable` | Boolean | Yes | | `strategy` | String | Yes | | `tableId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all partition records const items = await db.partition.findMany({ select: { createdAt: true, databaseId: true, id: true, interval: true, isParented: true, namingPattern: true, partitionKeyId: true, premake: true, retention: true, retentionKeepTable: true, strategy: true, tableId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.partition.findOne({ id: '', select: { createdAt: true, databaseId: true, id: true, interval: true, isParented: true, namingPattern: true, partitionKeyId: true, premake: true, retention: true, retentionKeepTable: true, strategy: true, tableId: true, updatedAt: true } }).execute(); // Create const created = await db.partition.create({ data: { databaseId: '', interval: '', isParented: '', namingPattern: '', partitionKeyId: '', premake: '', retention: '', retentionKeepTable: '', strategy: '', tableId: '' }, select: { id: true } }).execute(); // Update const updated = await db.partition.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.partition.delete({ where: { id: '' } }).execute(); ``` ### `db.platformApi` CRUD operations for PlatformApi records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `anonRole` | String | Yes | | `config` | JSON | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `isPublished` | Boolean | Yes | | `name` | String | Yes | | `roleName` | String | Yes | | `serviceHostname` | String | No | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformApi records const items = await db.platformApi.findMany({ select: { anonRole: true, config: true, createdAt: true, id: true, isPublished: true, name: true, roleName: true, serviceHostname: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformApi.findOne({ id: '', select: { anonRole: true, config: true, createdAt: true, id: true, isPublished: true, name: true, roleName: true, serviceHostname: true, updatedAt: true } }).execute(); // Create const created = await db.platformApi.create({ data: { anonRole: '', config: '', isPublished: '', name: '', roleName: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformApi.update({ where: { id: '' }, data: { anonRole: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformApi.delete({ where: { id: '' } }).execute(); ``` ### `db.platformApiSchema` CRUD operations for PlatformApiSchema records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `apiId` | UUID | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `schemaId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformApiSchema records const items = await db.platformApiSchema.findMany({ select: { apiId: true, createdAt: true, id: true, schemaId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformApiSchema.findOne({ id: '', select: { apiId: true, createdAt: true, id: true, schemaId: true, updatedAt: true } }).execute(); // Create const created = await db.platformApiSchema.create({ data: { apiId: '', schemaId: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformApiSchema.update({ where: { id: '' }, data: { apiId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformApiSchema.delete({ where: { id: '' } }).execute(); ``` ### `db.platformApiSetting` CRUD operations for PlatformApiSetting records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `apiId` | UUID | Yes | | `createdAt` | Datetime | No | | `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 platformApiSetting records const items = await db.platformApiSetting.findMany({ select: { apiId: true, createdAt: 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.platformApiSetting.findOne({ id: '', select: { apiId: true, createdAt: 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.platformApiSetting.create({ data: { apiId: '', 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.platformApiSetting.update({ where: { id: '' }, data: { apiId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformApiSetting.delete({ where: { id: '' } }).execute(); ``` ### `db.platformCorsSetting` CRUD operations for PlatformCorsSetting records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `allowedOrigins` | String | Yes | | `apiId` | UUID | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformCorsSetting records const items = await db.platformCorsSetting.findMany({ select: { allowedOrigins: true, apiId: true, createdAt: true, id: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformCorsSetting.findOne({ id: '', select: { allowedOrigins: true, apiId: true, createdAt: true, id: true, updatedAt: true } }).execute(); // Create const created = await db.platformCorsSetting.create({ data: { allowedOrigins: '', apiId: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformCorsSetting.update({ where: { id: '' }, data: { allowedOrigins: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformCorsSetting.delete({ where: { id: '' } }).execute(); ``` ### `db.platformDomain` CRUD operations for PlatformDomain records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `config` | JSON | Yes | | `createdAt` | Datetime | No | | `createdByPrincipal` | 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 platformDomain records const items = await db.platformDomain.findMany({ select: { config: true, createdAt: true, createdByPrincipal: 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.platformDomain.findOne({ id: '', select: { config: true, createdAt: true, createdByPrincipal: 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.platformDomain.create({ data: { config: '', createdByPrincipal: '', hostname: '', isPublished: '', isWildcard: '', managed: '', parentHostname: '', tlsReadyAt: '', tlsSecretName: '', tlsStatus: '', updatedByPrincipal: '', verificationStatus: '', verifiedAt: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformDomain.update({ where: { id: '' }, data: { config: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformDomain.delete({ where: { id: '' } }).execute(); ``` ### `db.platformDomainEvent` CRUD operations for PlatformDomainEvent records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `actorId` | UUID | Yes | | `createdAt` | Datetime | No | | `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 platformDomainEvent records const items = await db.platformDomainEvent.findMany({ select: { actorId: true, createdAt: 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.platformDomainEvent.findOne({ id: '', select: { actorId: true, createdAt: true, domainId: true, domainVerificationId: true, eventType: true, id: true, managedDomainId: true, message: true, metadata: true, updatedAt: true } }).execute(); // Create const created = await db.platformDomainEvent.create({ data: { actorId: '', domainId: '', domainVerificationId: '', eventType: '', managedDomainId: '', message: '', metadata: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformDomainEvent.update({ where: { id: '' }, data: { actorId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformDomainEvent.delete({ where: { id: '' } }).execute(); ``` ### `db.platformDomainVerification` CRUD operations for PlatformDomainVerification records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `attempts` | Int | Yes | | `createdAt` | Datetime | No | | `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 platformDomainVerification records const items = await db.platformDomainVerification.findMany({ select: { attempts: true, createdAt: 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.platformDomainVerification.findOne({ id: '', select: { attempts: true, createdAt: 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.platformDomainVerification.create({ data: { attempts: '', domainId: '', error: '', expiresAt: '', lastCheckedAt: '', managedDomainId: '', method: '', recordName: '', recordType: '', recordValue: '', status: '', verifiedAt: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformDomainVerification.update({ where: { id: '' }, data: { attempts: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformDomainVerification.delete({ where: { id: '' } }).execute(); ``` ### `db.platformEmailIdentity` CRUD operations for PlatformEmailIdentity records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `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 platformEmailIdentity records const items = await db.platformEmailIdentity.findMany({ select: { createdAt: 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.platformEmailIdentity.findOne({ id: '', select: { createdAt: 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.platformEmailIdentity.create({ data: { fromAddress: '', fromName: '', isActive: '', isDefault: '', name: '', providerAccountId: '', replyToAddress: '', supportAddress: '', transportMode: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformEmailIdentity.update({ where: { id: '' }, data: { fromAddress: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformEmailIdentity.delete({ where: { id: '' } }).execute(); ``` ### `db.platformEmailProviderAccount` CRUD operations for PlatformEmailProviderAccount records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `credentialsSecretName` | String | 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 platformEmailProviderAccount records const items = await db.platformEmailProviderAccount.findMany({ select: { createdAt: true, credentialsSecretName: 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.platformEmailProviderAccount.findOne({ id: '', select: { createdAt: true, credentialsSecretName: 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.platformEmailProviderAccount.create({ data: { credentialsSecretName: '', isActive: '', name: '', provider: '', providerAccountName: '', region: '', smtpHost: '', smtpPort: '', smtpSecure: '', smtpUser: '', webhookSigningSecretName: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformEmailProviderAccount.update({ where: { id: '' }, data: { credentialsSecretName: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformEmailProviderAccount.delete({ where: { id: '' } }).execute(); ``` ### `db.platformEmailSiteIdentity` CRUD operations for PlatformEmailSiteIdentity records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `emailIdentityId` | UUID | Yes | | `id` | UUID | No | | `siteId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformEmailSiteIdentity records const items = await db.platformEmailSiteIdentity.findMany({ select: { createdAt: true, emailIdentityId: true, id: true, siteId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformEmailSiteIdentity.findOne({ id: '', select: { createdAt: true, emailIdentityId: true, id: true, siteId: true, updatedAt: true } }).execute(); // Create const created = await db.platformEmailSiteIdentity.create({ data: { emailIdentityId: '', siteId: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformEmailSiteIdentity.update({ where: { id: '' }, data: { emailIdentityId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformEmailSiteIdentity.delete({ where: { id: '' } }).execute(); ``` ### `db.platformGetSitePreviewsRecord` CRUD operations for PlatformGetSitePreviewsRecord records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `name` | String | Yes | **Operations:** ```typescript // List all platformGetSitePreviewsRecord records const items = await db.platformGetSitePreviewsRecord.findMany({ select: { commitId: true, name: true } }).execute(); // Get one by id const item = await db.platformGetSitePreviewsRecord.findOne({ id: '', select: { commitId: true, name: true } }).execute(); // Update const updated = await db.platformGetSitePreviewsRecord.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformGetSitePreviewsRecord.delete({ where: { id: '' } }).execute(); ``` ### `db.platformManagedDomain` CRUD operations for PlatformManagedDomain records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `allowPublicUsage` | Boolean | Yes | | `annotations` | JSON | Yes | | `certStatus` | String | Yes | | `createdAt` | Datetime | No | | `createdByPrincipal` | UUID | Yes | | `domain` | String | Yes | | `id` | UUID | No | | `isWildcard` | Boolean | Yes | | `publicPort` | Int | Yes | | `tlsReadyAt` | Datetime | Yes | | `tlsStatus` | String | Yes | | `updatedAt` | Datetime | No | | `updatedByPrincipal` | UUID | Yes | | `verificationStatus` | String | Yes | | `verifiedAt` | Datetime | Yes | **Operations:** ```typescript // List all platformManagedDomain records const items = await db.platformManagedDomain.findMany({ select: { allowPublicUsage: true, annotations: true, certStatus: true, createdAt: true, createdByPrincipal: true, domain: true, id: true, isWildcard: true, publicPort: true, tlsReadyAt: true, tlsStatus: true, updatedAt: true, updatedByPrincipal: true, verificationStatus: true, verifiedAt: true } }).execute(); // Get one by id const item = await db.platformManagedDomain.findOne({ id: '', select: { allowPublicUsage: true, annotations: true, certStatus: true, createdAt: true, createdByPrincipal: true, domain: true, id: true, isWildcard: true, publicPort: true, tlsReadyAt: true, tlsStatus: true, updatedAt: true, updatedByPrincipal: true, verificationStatus: true, verifiedAt: true } }).execute(); // Create const created = await db.platformManagedDomain.create({ data: { allowPublicUsage: '', annotations: '', certStatus: '', createdByPrincipal: '', domain: '', isWildcard: '', publicPort: '', tlsReadyAt: '', tlsStatus: '', updatedByPrincipal: '', verificationStatus: '', verifiedAt: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformManagedDomain.update({ where: { id: '' }, data: { allowPublicUsage: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformManagedDomain.delete({ where: { id: '' } }).execute(); ``` ### `db.platformPage` CRUD operations for PlatformPage records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `content` | JSON | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `seededFrom` | JSON | Yes | | `siteId` | UUID | Yes | | `slug` | String | Yes | | `storeId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformPage records const items = await db.platformPage.findMany({ select: { commitId: true, content: true, createdAt: true, id: true, seededFrom: true, siteId: true, slug: true, storeId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformPage.findOne({ id: '', select: { commitId: true, content: true, createdAt: true, id: true, seededFrom: true, siteId: true, slug: true, storeId: true, updatedAt: true } }).execute(); // Create const created = await db.platformPage.create({ data: { commitId: '', content: '', seededFrom: '', siteId: '', slug: '', storeId: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformPage.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformPage.delete({ where: { id: '' } }).execute(); ``` ### `db.platformReservedSubdomain` CRUD operations for PlatformReservedSubdomain records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `createdByPrincipal` | UUID | Yes | | `id` | UUID | No | | `label` | String | Yes | | `match` | String | Yes | | `reason` | String | Yes | | `updatedAt` | Datetime | No | | `updatedByPrincipal` | UUID | Yes | **Operations:** ```typescript // List all platformReservedSubdomain records const items = await db.platformReservedSubdomain.findMany({ select: { createdAt: true, createdByPrincipal: true, id: true, label: true, match: true, reason: true, updatedAt: true, updatedByPrincipal: true } }).execute(); // Get one by id const item = await db.platformReservedSubdomain.findOne({ id: '', select: { createdAt: true, createdByPrincipal: true, id: true, label: true, match: true, reason: true, updatedAt: true, updatedByPrincipal: true } }).execute(); // Create const created = await db.platformReservedSubdomain.create({ data: { createdByPrincipal: '', label: '', match: '', reason: '', updatedByPrincipal: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformReservedSubdomain.update({ where: { id: '' }, data: { createdByPrincipal: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformReservedSubdomain.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteAppLink` CRUD operations for PlatformSiteAppLink records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `appStoreIdentityId` | UUID | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `pathComponents` | String | Yes | | `siteId` | UUID | Yes | | `updatedAt` | Datetime | No | | `webcredentials` | Boolean | Yes | **Operations:** ```typescript // List all platformSiteAppLink records const items = await db.platformSiteAppLink.findMany({ select: { appStoreIdentityId: true, createdAt: true, id: true, pathComponents: true, siteId: true, updatedAt: true, webcredentials: true } }).execute(); // Get one by id const item = await db.platformSiteAppLink.findOne({ id: '', select: { appStoreIdentityId: true, createdAt: true, id: true, pathComponents: true, siteId: true, updatedAt: true, webcredentials: true } }).execute(); // Create const created = await db.platformSiteAppLink.create({ data: { appStoreIdentityId: '', pathComponents: '', siteId: '', webcredentials: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteAppLink.update({ where: { id: '' }, data: { appStoreIdentityId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteAppLink.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSite` CRUD operations for PlatformSite records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `activeCommitId` | UUID | Yes | | `bucketId` | UUID | Yes | | `createdAt` | Datetime | No | | `createdByPrincipal` | UUID | Yes | | `description` | String | Yes | | `id` | UUID | No | | `installationId` | UUID | Yes | | `installationMemberSlug` | String | Yes | | `isPublished` | Boolean | Yes | | `name` | String | Yes | | `resourceId` | UUID | Yes | | `title` | String | Yes | | `updatedAt` | Datetime | No | | `updatedByPrincipal` | UUID | Yes | **Operations:** ```typescript // List all platformSite records const items = await db.platformSite.findMany({ select: { activeCommitId: true, bucketId: true, createdAt: true, createdByPrincipal: true, description: true, id: true, installationId: true, installationMemberSlug: true, isPublished: true, name: true, resourceId: true, title: true, updatedAt: true, updatedByPrincipal: true } }).execute(); // Get one by id const item = await db.platformSite.findOne({ id: '', select: { activeCommitId: true, bucketId: true, createdAt: true, createdByPrincipal: true, description: true, id: true, installationId: true, installationMemberSlug: true, isPublished: true, name: true, resourceId: true, title: true, updatedAt: true, updatedByPrincipal: true } }).execute(); // Create const created = await db.platformSite.create({ data: { activeCommitId: '', bucketId: '', createdByPrincipal: '', description: '', installationId: '', installationMemberSlug: '', isPublished: '', name: '', resourceId: '', title: '', updatedByPrincipal: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSite.update({ where: { id: '' }, data: { activeCommitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSite.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteDeepLink` CRUD operations for PlatformSiteDeepLink records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `appPath` | String | Yes | | `createdAt` | Datetime | No | | `fallbackUrl` | String | Yes | | `id` | UUID | No | | `metadata` | JSON | Yes | | `pageId` | UUID | Yes | | `siteId` | UUID | Yes | | `slug` | String | Yes | | `updatedAt` | Datetime | No | | `webPath` | String | Yes | **Operations:** ```typescript // List all platformSiteDeepLink records const items = await db.platformSiteDeepLink.findMany({ select: { appPath: true, createdAt: true, fallbackUrl: true, id: true, metadata: true, pageId: true, siteId: true, slug: true, updatedAt: true, webPath: true } }).execute(); // Get one by id const item = await db.platformSiteDeepLink.findOne({ id: '', select: { appPath: true, createdAt: true, fallbackUrl: true, id: true, metadata: true, pageId: true, siteId: true, slug: true, updatedAt: true, webPath: true } }).execute(); // Create const created = await db.platformSiteDeepLink.create({ data: { appPath: '', fallbackUrl: '', metadata: '', pageId: '', siteId: '', slug: '', webPath: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteDeepLink.update({ where: { id: '' }, data: { appPath: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteDeepLink.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteErrorPage` CRUD operations for PlatformSiteErrorPage records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `id` | UUID | No | | `objectPath` | String | Yes | | `siteId` | UUID | Yes | | `statusCode` | Int | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformSiteErrorPage records const items = await db.platformSiteErrorPage.findMany({ select: { createdAt: true, id: true, objectPath: true, siteId: true, statusCode: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformSiteErrorPage.findOne({ id: '', select: { createdAt: true, id: true, objectPath: true, siteId: true, statusCode: true, updatedAt: true } }).execute(); // Create const created = await db.platformSiteErrorPage.create({ data: { objectPath: '', siteId: '', statusCode: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteErrorPage.update({ where: { id: '' }, data: { objectPath: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteErrorPage.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteMetadatum` CRUD operations for PlatformSiteMetadatum records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `appleTouchIcon` | ConstructiveInternalTypeImage | Yes | | `appleTouchIconUrl` | String | No | | `appleTouchIconVersions` | FileVersion | No | | `canonicalUrl` | String | Yes | | `commitId` | UUID | Yes | | `createdAt` | Datetime | No | | `description` | String | Yes | | `favicon` | ConstructiveInternalTypeImage | Yes | | `faviconUrl` | String | No | | `faviconVersions` | FileVersion | No | | `id` | UUID | No | | `logo` | ConstructiveInternalTypeImage | Yes | | `logoUrl` | String | No | | `logoVersions` | FileVersion | No | | `ogImage` | ConstructiveInternalTypeImage | Yes | | `ogImageUrl` | String | No | | `ogImageVersions` | FileVersion | No | | `robots` | String | Yes | | `robotsSeededFrom` | JSON | Yes | | `siteId` | UUID | Yes | | `storeId` | UUID | Yes | | `title` | String | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformSiteMetadatum records const items = await db.platformSiteMetadatum.findMany({ select: { appleTouchIcon: true, canonicalUrl: true, commitId: true, createdAt: true, description: true, favicon: true, id: true, logo: true, ogImage: true, robots: true, robotsSeededFrom: true, siteId: true, storeId: true, title: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformSiteMetadatum.findOne({ id: '', select: { appleTouchIcon: true, canonicalUrl: true, commitId: true, createdAt: true, description: true, favicon: true, id: true, logo: true, ogImage: true, robots: true, robotsSeededFrom: true, siteId: true, storeId: true, title: true, updatedAt: true } }).execute(); // Create const created = await db.platformSiteMetadatum.create({ data: { appleTouchIcon: '', canonicalUrl: '', commitId: '', description: '', favicon: '', logo: '', ogImage: '', robots: '', robotsSeededFrom: '', siteId: '', storeId: '', title: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteMetadatum.update({ where: { id: '' }, data: { appleTouchIcon: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteMetadatum.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteModule` CRUD operations for PlatformSiteModule records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `data` | JSON | Yes | | `id` | UUID | No | | `isEnabled` | Boolean | Yes | | `name` | String | Yes | | `position` | Int | Yes | | `siteId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformSiteModule records const items = await db.platformSiteModule.findMany({ select: { createdAt: true, data: true, id: true, isEnabled: true, name: true, position: true, siteId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformSiteModule.findOne({ id: '', select: { createdAt: true, data: true, id: true, isEnabled: true, name: true, position: true, siteId: true, updatedAt: true } }).execute(); // Create const created = await db.platformSiteModule.create({ data: { data: '', isEnabled: '', name: '', position: '', siteId: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteModule.update({ where: { id: '' }, data: { data: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteModule.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteRelease` CRUD operations for PlatformSiteRelease records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `manifest` | JSON | Yes | | `siteId` | UUID | Yes | | `storeId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformSiteRelease records const items = await db.platformSiteRelease.findMany({ select: { commitId: true, createdAt: true, id: true, manifest: true, siteId: true, storeId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformSiteRelease.findOne({ id: '', select: { commitId: true, createdAt: true, id: true, manifest: true, siteId: true, storeId: true, updatedAt: true } }).execute(); // Create const created = await db.platformSiteRelease.create({ data: { commitId: '', manifest: '', siteId: '', storeId: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteRelease.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteRelease.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteTheme` CRUD operations for PlatformSiteTheme records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `isActive` | Boolean | Yes | | `name` | String | Yes | | `siteId` | UUID | Yes | | `storeId` | UUID | Yes | | `theme` | JSON | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformSiteTheme records const items = await db.platformSiteTheme.findMany({ select: { commitId: true, createdAt: true, id: true, isActive: true, name: true, siteId: true, storeId: true, theme: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformSiteTheme.findOne({ id: '', select: { commitId: true, createdAt: true, id: true, isActive: true, name: true, siteId: true, storeId: true, theme: true, updatedAt: true } }).execute(); // Create const created = await db.platformSiteTheme.create({ data: { commitId: '', isActive: '', name: '', siteId: '', storeId: '', theme: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteTheme.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteTheme.delete({ where: { id: '' } }).execute(); ``` ### `db.platformSiteWebConfig` CRUD operations for PlatformSiteWebConfig records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `cleanUrls` | Boolean | Yes | | `createdAt` | Datetime | No | | `id` | UUID | No | | `indexDocument` | String | Yes | | `metadata` | JSON | Yes | | `siteId` | UUID | Yes | | `spaFallback` | Boolean | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all platformSiteWebConfig records const items = await db.platformSiteWebConfig.findMany({ select: { cleanUrls: true, createdAt: true, id: true, indexDocument: true, metadata: true, siteId: true, spaFallback: true, updatedAt: true } }).execute(); // Get one by id const item = await db.platformSiteWebConfig.findOne({ id: '', select: { cleanUrls: true, createdAt: true, id: true, indexDocument: true, metadata: true, siteId: true, spaFallback: true, updatedAt: true } }).execute(); // Create const created = await db.platformSiteWebConfig.create({ data: { cleanUrls: '', indexDocument: '', metadata: '', siteId: '', spaFallback: '' }, select: { id: true } }).execute(); // Update const updated = await db.platformSiteWebConfig.update({ where: { id: '' }, data: { cleanUrls: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.platformSiteWebConfig.delete({ where: { id: '' } }).execute(); ``` ### `db.policy` CRUD operations for Policy records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `columnRefs` | String | Yes | | `createdAt` | Datetime | No | | `data` | JSON | Yes | | `databaseId` | UUID | Yes | | `derivedFromPolicyId` | UUID | Yes | | `derivedFromTableId` | UUID | Yes | | `disabled` | Boolean | Yes | | `granteeName` | String | Yes | | `id` | UUID | No | | `name` | String | Yes | | `permissive` | Boolean | Yes | | `policyType` | String | Yes | | `privilege` | String | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `updatedAt` | Datetime | No | | `withCheck` | JSON | Yes | **Operations:** ```typescript // List all policy records const items = await db.policy.findMany({ select: { category: true, columnRefs: true, createdAt: true, data: true, databaseId: true, derivedFromPolicyId: true, derivedFromTableId: true, disabled: true, granteeName: true, id: true, name: true, permissive: true, policyType: true, privilege: true, smartTags: true, tableId: true, tags: true, updatedAt: true, withCheck: true } }).execute(); // Get one by id const item = await db.policy.findOne({ id: '', select: { category: true, columnRefs: true, createdAt: true, data: true, databaseId: true, derivedFromPolicyId: true, derivedFromTableId: true, disabled: true, granteeName: true, id: true, name: true, permissive: true, policyType: true, privilege: true, smartTags: true, tableId: true, tags: true, updatedAt: true, withCheck: true } }).execute(); // Create const created = await db.policy.create({ data: { category: '', columnRefs: '', data: '', databaseId: '', derivedFromPolicyId: '', derivedFromTableId: '', disabled: '', granteeName: '', name: '', permissive: '', policyType: '', privilege: '', smartTags: '', tableId: '', tags: '', withCheck: '' }, select: { id: true } }).execute(); // Update const updated = await db.policy.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.policy.delete({ where: { id: '' } }).execute(); ``` ### `db.primaryKeyConstraint` CRUD operations for PrimaryKeyConstraint records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | 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 | | `withoutOverlaps` | Boolean | Yes | **Operations:** ```typescript // List all primaryKeyConstraint records const items = await db.primaryKeyConstraint.findMany({ select: { category: true, createdAt: true, databaseId: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true, withoutOverlaps: true } }).execute(); // Get one by id const item = await db.primaryKeyConstraint.findOne({ id: '', select: { category: true, createdAt: true, databaseId: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true, withoutOverlaps: true } }).execute(); // Create const created = await db.primaryKeyConstraint.create({ data: { category: '', databaseId: '', fieldIds: '', initiallyDeferred: '', isDeferrable: '', name: '', smartTags: '', tableId: '', tags: '', type: '', withoutOverlaps: '' }, select: { id: true } }).execute(); // Update const updated = await db.primaryKeyConstraint.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.primaryKeyConstraint.delete({ where: { id: '' } }).execute(); ``` ### `db.pubkeySetting` CRUD operations for PubkeySetting records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `cryptoNetwork` | String | Yes | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `schemaId` | UUID | Yes | | `signInRecordFailureFunctionId` | UUID | Yes | | `signInRequestChallengeFunctionId` | UUID | Yes | | `signInWithChallengeFunctionId` | UUID | Yes | | `signUpWithKeyFunctionId` | UUID | Yes | | `updatedAt` | Datetime | No | | `userField` | String | Yes | **Operations:** ```typescript // List all pubkeySetting records const items = await db.pubkeySetting.findMany({ select: { createdAt: true, cryptoNetwork: true, databaseId: true, id: true, schemaId: true, signInRecordFailureFunctionId: true, signInRequestChallengeFunctionId: true, signInWithChallengeFunctionId: true, signUpWithKeyFunctionId: true, updatedAt: true, userField: true } }).execute(); // Get one by id const item = await db.pubkeySetting.findOne({ id: '', select: { createdAt: true, cryptoNetwork: true, databaseId: true, id: true, schemaId: true, signInRecordFailureFunctionId: true, signInRequestChallengeFunctionId: true, signInWithChallengeFunctionId: true, signUpWithKeyFunctionId: true, updatedAt: true, userField: true } }).execute(); // Create const created = await db.pubkeySetting.create({ data: { cryptoNetwork: '', databaseId: '', schemaId: '', signInRecordFailureFunctionId: '', signInRequestChallengeFunctionId: '', signInWithChallengeFunctionId: '', signUpWithKeyFunctionId: '', userField: '' }, select: { id: true } }).execute(); // Update const updated = await db.pubkeySetting.update({ where: { id: '' }, data: { cryptoNetwork: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.pubkeySetting.delete({ where: { id: '' } }).execute(); ``` ### `db.redirect` CRUD operations for Redirect records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `name` | String | Yes | | `preservePath` | Boolean | Yes | | `preserveQuery` | Boolean | Yes | | `statusCode` | Int | Yes | | `toHost` | String | Yes | | `toPath` | String | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all redirect records const items = await db.redirect.findMany({ select: { createdAt: true, databaseId: true, id: true, name: true, preservePath: true, preserveQuery: true, statusCode: true, toHost: true, toPath: true, updatedAt: true } }).execute(); // Get one by id const item = await db.redirect.findOne({ id: '', select: { createdAt: true, databaseId: true, id: true, name: true, preservePath: true, preserveQuery: true, statusCode: true, toHost: true, toPath: true, updatedAt: true } }).execute(); // Create const created = await db.redirect.create({ data: { databaseId: '', name: '', preservePath: '', preserveQuery: '', statusCode: '', toHost: '', toPath: '' }, select: { id: true } }).execute(); // Update const updated = await db.redirect.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.redirect.delete({ where: { id: '' } }).execute(); ``` ### `db.rlsSetting` CRUD operations for RlsSetting records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `authenticateFunctionId` | UUID | Yes | | `authenticateSchemaId` | UUID | Yes | | `authenticateStrictFunctionId` | UUID | Yes | | `createdAt` | Datetime | No | | `currentIpAddressFunctionId` | UUID | Yes | | `currentRoleFunctionId` | UUID | Yes | | `currentRoleIdFunctionId` | UUID | Yes | | `currentUserAgentFunctionId` | UUID | Yes | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `roleSchemaId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all rlsSetting records const items = await db.rlsSetting.findMany({ select: { authenticateFunctionId: true, authenticateSchemaId: true, authenticateStrictFunctionId: true, createdAt: true, currentIpAddressFunctionId: true, currentRoleFunctionId: true, currentRoleIdFunctionId: true, currentUserAgentFunctionId: true, databaseId: true, id: true, roleSchemaId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.rlsSetting.findOne({ id: '', select: { authenticateFunctionId: true, authenticateSchemaId: true, authenticateStrictFunctionId: true, createdAt: true, currentIpAddressFunctionId: true, currentRoleFunctionId: true, currentRoleIdFunctionId: true, currentUserAgentFunctionId: true, databaseId: true, id: true, roleSchemaId: true, updatedAt: true } }).execute(); // Create const created = await db.rlsSetting.create({ data: { authenticateFunctionId: '', authenticateSchemaId: '', authenticateStrictFunctionId: '', currentIpAddressFunctionId: '', currentRoleFunctionId: '', currentRoleIdFunctionId: '', currentUserAgentFunctionId: '', databaseId: '', roleSchemaId: '' }, select: { id: true } }).execute(); // Update const updated = await db.rlsSetting.update({ where: { id: '' }, data: { authenticateFunctionId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.rlsSetting.delete({ where: { id: '' } }).execute(); ``` ### `db.route` CRUD operations for Route records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `anonymous` | Boolean | Yes | | `config` | JSON | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `domainId` | UUID | Yes | | `id` | UUID | No | | `isActive` | Boolean | Yes | | `method` | String | Yes | | `path` | String | Yes | | `previewRef` | String | Yes | | `priority` | Int | Yes | | `servingSiteId` | UUID | Yes | | `targetApiId` | UUID | Yes | | `targetBucketId` | UUID | Yes | | `targetFunctionId` | UUID | Yes | | `targetRedirectId` | UUID | Yes | | `targetServiceId` | UUID | Yes | | `targetSiteId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all route records const items = await db.route.findMany({ select: { anonymous: true, config: true, createdAt: true, databaseId: true, domainId: true, id: true, isActive: true, method: true, path: true, previewRef: true, priority: true, servingSiteId: true, targetApiId: true, targetBucketId: true, targetFunctionId: true, targetRedirectId: true, targetServiceId: true, targetSiteId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.route.findOne({ id: '', select: { anonymous: true, config: true, createdAt: true, databaseId: true, domainId: true, id: true, isActive: true, method: true, path: true, previewRef: true, priority: true, servingSiteId: true, targetApiId: true, targetBucketId: true, targetFunctionId: true, targetRedirectId: true, targetServiceId: true, targetSiteId: true, updatedAt: true } }).execute(); // Create const created = await db.route.create({ data: { anonymous: '', config: '', databaseId: '', domainId: '', isActive: '', method: '', path: '', previewRef: '', priority: '', servingSiteId: '', targetApiId: '', targetBucketId: '', targetFunctionId: '', targetRedirectId: '', targetServiceId: '', targetSiteId: '' }, select: { id: true } }).execute(); // Update const updated = await db.route.update({ where: { id: '' }, data: { anonymous: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.route.delete({ where: { id: '' } }).execute(); ``` ### `db.schema` CRUD operations for Schema records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `apiExposure` | ApiExposureLevel | Yes | | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `description` | String | Yes | | `id` | UUID | No | | `isPublic` | Boolean | Yes | | `label` | String | Yes | | `name` | String | Yes | | `schemaName` | String | Yes | | `smartTags` | JSON | Yes | | `tags` | String | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all schema records const items = await db.schema.findMany({ select: { apiExposure: true, category: true, createdAt: true, databaseId: true, description: true, id: true, isPublic: true, label: true, name: true, schemaName: true, smartTags: true, tags: true, updatedAt: true } }).execute(); // Get one by id const item = await db.schema.findOne({ id: '', select: { apiExposure: true, category: true, createdAt: true, databaseId: true, description: true, id: true, isPublic: true, label: true, name: true, schemaName: true, smartTags: true, tags: true, updatedAt: true } }).execute(); // Create const created = await db.schema.create({ data: { apiExposure: '', category: '', databaseId: '', description: '', isPublic: '', label: '', name: '', schemaName: '', smartTags: '', tags: '' }, select: { id: true } }).execute(); // Update const updated = await db.schema.update({ where: { id: '' }, data: { apiExposure: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.schema.delete({ where: { id: '' } }).execute(); ``` ### `db.schemaGrant` CRUD operations for SchemaGrant records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `granteeName` | String | Yes | | `id` | UUID | No | | `schemaId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all schemaGrant records const items = await db.schemaGrant.findMany({ select: { createdAt: true, databaseId: true, granteeName: true, id: true, schemaId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.schemaGrant.findOne({ id: '', select: { createdAt: true, databaseId: true, granteeName: true, id: true, schemaId: true, updatedAt: true } }).execute(); // Create const created = await db.schemaGrant.create({ data: { databaseId: '', granteeName: '', schemaId: '' }, select: { id: true } }).execute(); // Update const updated = await db.schemaGrant.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.schemaGrant.delete({ where: { id: '' } }).execute(); ``` ### `db.siteAppLink` CRUD operations for SiteAppLink records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `appStoreIdentityId` | UUID | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `pathComponents` | String | Yes | | `siteId` | UUID | Yes | | `updatedAt` | Datetime | No | | `webcredentials` | Boolean | Yes | **Operations:** ```typescript // List all siteAppLink records const items = await db.siteAppLink.findMany({ select: { appStoreIdentityId: true, createdAt: true, databaseId: true, id: true, pathComponents: true, siteId: true, updatedAt: true, webcredentials: true } }).execute(); // Get one by id const item = await db.siteAppLink.findOne({ id: '', select: { appStoreIdentityId: true, createdAt: true, databaseId: true, id: true, pathComponents: true, siteId: true, updatedAt: true, webcredentials: true } }).execute(); // Create const created = await db.siteAppLink.create({ data: { appStoreIdentityId: '', databaseId: '', pathComponents: '', siteId: '', webcredentials: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteAppLink.update({ where: { id: '' }, data: { appStoreIdentityId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteAppLink.delete({ where: { id: '' } }).execute(); ``` ### `db.site` CRUD operations for Site records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `activeCommitId` | UUID | Yes | | `bucketId` | UUID | Yes | | `createdAt` | Datetime | No | | `createdByPrincipal` | UUID | Yes | | `databaseId` | UUID | Yes | | `description` | String | Yes | | `id` | UUID | No | | `installationId` | UUID | Yes | | `installationMemberSlug` | String | Yes | | `isPublished` | Boolean | Yes | | `name` | String | Yes | | `resourceId` | UUID | Yes | | `title` | String | Yes | | `updatedAt` | Datetime | No | | `updatedByPrincipal` | UUID | Yes | **Operations:** ```typescript // List all site records const items = await db.site.findMany({ select: { activeCommitId: true, bucketId: true, createdAt: true, createdByPrincipal: true, databaseId: true, description: true, id: true, installationId: true, installationMemberSlug: true, isPublished: true, name: true, resourceId: true, title: true, updatedAt: true, updatedByPrincipal: true } }).execute(); // Get one by id const item = await db.site.findOne({ id: '', select: { activeCommitId: true, bucketId: true, createdAt: true, createdByPrincipal: true, databaseId: true, description: true, id: true, installationId: true, installationMemberSlug: true, isPublished: true, name: true, resourceId: true, title: true, updatedAt: true, updatedByPrincipal: true } }).execute(); // Create const created = await db.site.create({ data: { activeCommitId: '', bucketId: '', createdByPrincipal: '', databaseId: '', description: '', installationId: '', installationMemberSlug: '', isPublished: '', name: '', resourceId: '', title: '', updatedByPrincipal: '' }, select: { id: true } }).execute(); // Update const updated = await db.site.update({ where: { id: '' }, data: { activeCommitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.site.delete({ where: { id: '' } }).execute(); ``` ### `db.siteDeepLink` CRUD operations for SiteDeepLink records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `appPath` | String | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `fallbackUrl` | String | Yes | | `id` | UUID | No | | `metadata` | JSON | Yes | | `pageId` | UUID | Yes | | `siteId` | UUID | Yes | | `slug` | String | Yes | | `updatedAt` | Datetime | No | | `webPath` | String | Yes | **Operations:** ```typescript // List all siteDeepLink records const items = await db.siteDeepLink.findMany({ select: { appPath: true, createdAt: true, databaseId: true, fallbackUrl: true, id: true, metadata: true, pageId: true, siteId: true, slug: true, updatedAt: true, webPath: true } }).execute(); // Get one by id const item = await db.siteDeepLink.findOne({ id: '', select: { appPath: true, createdAt: true, databaseId: true, fallbackUrl: true, id: true, metadata: true, pageId: true, siteId: true, slug: true, updatedAt: true, webPath: true } }).execute(); // Create const created = await db.siteDeepLink.create({ data: { appPath: '', databaseId: '', fallbackUrl: '', metadata: '', pageId: '', siteId: '', slug: '', webPath: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteDeepLink.update({ where: { id: '' }, data: { appPath: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteDeepLink.delete({ where: { id: '' } }).execute(); ``` ### `db.siteErrorPage` CRUD operations for SiteErrorPage records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `objectPath` | String | Yes | | `siteId` | UUID | Yes | | `statusCode` | Int | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all siteErrorPage records const items = await db.siteErrorPage.findMany({ select: { createdAt: true, databaseId: true, id: true, objectPath: true, siteId: true, statusCode: true, updatedAt: true } }).execute(); // Get one by id const item = await db.siteErrorPage.findOne({ id: '', select: { createdAt: true, databaseId: true, id: true, objectPath: true, siteId: true, statusCode: true, updatedAt: true } }).execute(); // Create const created = await db.siteErrorPage.create({ data: { databaseId: '', objectPath: '', siteId: '', statusCode: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteErrorPage.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteErrorPage.delete({ where: { id: '' } }).execute(); ``` ### `db.siteMetadatum` CRUD operations for SiteMetadatum records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `appleTouchIcon` | ConstructiveInternalTypeImage | Yes | | `appleTouchIconUrl` | String | No | | `appleTouchIconVersions` | FileVersion | No | | `canonicalUrl` | String | Yes | | `commitId` | UUID | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `description` | String | Yes | | `favicon` | ConstructiveInternalTypeImage | Yes | | `faviconUrl` | String | No | | `faviconVersions` | FileVersion | No | | `id` | UUID | No | | `logo` | ConstructiveInternalTypeImage | Yes | | `logoUrl` | String | No | | `logoVersions` | FileVersion | No | | `ogImage` | ConstructiveInternalTypeImage | Yes | | `ogImageUrl` | String | No | | `ogImageVersions` | FileVersion | No | | `robots` | String | Yes | | `robotsSeededFrom` | JSON | Yes | | `siteId` | UUID | Yes | | `storeId` | UUID | Yes | | `title` | String | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all siteMetadatum records const items = await db.siteMetadatum.findMany({ select: { appleTouchIcon: true, canonicalUrl: true, commitId: true, createdAt: true, databaseId: true, description: true, favicon: true, id: true, logo: true, ogImage: true, robots: true, robotsSeededFrom: true, siteId: true, storeId: true, title: true, updatedAt: true } }).execute(); // Get one by id const item = await db.siteMetadatum.findOne({ id: '', select: { appleTouchIcon: true, canonicalUrl: true, commitId: true, createdAt: true, databaseId: true, description: true, favicon: true, id: true, logo: true, ogImage: true, robots: true, robotsSeededFrom: true, siteId: true, storeId: true, title: true, updatedAt: true } }).execute(); // Create const created = await db.siteMetadatum.create({ data: { appleTouchIcon: '', canonicalUrl: '', commitId: '', databaseId: '', description: '', favicon: '', logo: '', ogImage: '', robots: '', robotsSeededFrom: '', siteId: '', storeId: '', title: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteMetadatum.update({ where: { id: '' }, data: { appleTouchIcon: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteMetadatum.delete({ where: { id: '' } }).execute(); ``` ### `db.siteModule` CRUD operations for SiteModule records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `data` | JSON | Yes | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `isEnabled` | Boolean | Yes | | `name` | String | Yes | | `position` | Int | Yes | | `siteId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all siteModule records const items = await db.siteModule.findMany({ select: { createdAt: true, data: true, databaseId: true, id: true, isEnabled: true, name: true, position: true, siteId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.siteModule.findOne({ id: '', select: { createdAt: true, data: true, databaseId: true, id: true, isEnabled: true, name: true, position: true, siteId: true, updatedAt: true } }).execute(); // Create const created = await db.siteModule.create({ data: { data: '', databaseId: '', isEnabled: '', name: '', position: '', siteId: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteModule.update({ where: { id: '' }, data: { data: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteModule.delete({ where: { id: '' } }).execute(); ``` ### `db.siteRelease` CRUD operations for SiteRelease records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `manifest` | JSON | Yes | | `siteId` | UUID | Yes | | `storeId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all siteRelease records const items = await db.siteRelease.findMany({ select: { commitId: true, createdAt: true, databaseId: true, id: true, manifest: true, siteId: true, storeId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.siteRelease.findOne({ id: '', select: { commitId: true, createdAt: true, databaseId: true, id: true, manifest: true, siteId: true, storeId: true, updatedAt: true } }).execute(); // Create const created = await db.siteRelease.create({ data: { commitId: '', databaseId: '', manifest: '', siteId: '', storeId: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteRelease.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteRelease.delete({ where: { id: '' } }).execute(); ``` ### `db.siteTheme` CRUD operations for SiteTheme records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `commitId` | UUID | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `isActive` | Boolean | Yes | | `name` | String | Yes | | `siteId` | UUID | Yes | | `storeId` | UUID | Yes | | `theme` | JSON | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all siteTheme records const items = await db.siteTheme.findMany({ select: { commitId: true, createdAt: true, databaseId: true, id: true, isActive: true, name: true, siteId: true, storeId: true, theme: true, updatedAt: true } }).execute(); // Get one by id const item = await db.siteTheme.findOne({ id: '', select: { commitId: true, createdAt: true, databaseId: true, id: true, isActive: true, name: true, siteId: true, storeId: true, theme: true, updatedAt: true } }).execute(); // Create const created = await db.siteTheme.create({ data: { commitId: '', databaseId: '', isActive: '', name: '', siteId: '', storeId: '', theme: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteTheme.update({ where: { id: '' }, data: { commitId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteTheme.delete({ where: { id: '' } }).execute(); ``` ### `db.siteWebConfig` CRUD operations for SiteWebConfig records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `cleanUrls` | Boolean | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `indexDocument` | String | Yes | | `metadata` | JSON | Yes | | `siteId` | UUID | Yes | | `spaFallback` | Boolean | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all siteWebConfig records const items = await db.siteWebConfig.findMany({ select: { cleanUrls: true, createdAt: true, databaseId: true, id: true, indexDocument: true, metadata: true, siteId: true, spaFallback: true, updatedAt: true } }).execute(); // Get one by id const item = await db.siteWebConfig.findOne({ id: '', select: { cleanUrls: true, createdAt: true, databaseId: true, id: true, indexDocument: true, metadata: true, siteId: true, spaFallback: true, updatedAt: true } }).execute(); // Create const created = await db.siteWebConfig.create({ data: { cleanUrls: '', databaseId: '', indexDocument: '', metadata: '', siteId: '', spaFallback: '' }, select: { id: true } }).execute(); // Update const updated = await db.siteWebConfig.update({ where: { id: '' }, data: { cleanUrls: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.siteWebConfig.delete({ where: { id: '' } }).execute(); ``` ### `db.spatialRelation` CRUD operations for SpatialRelation records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `fieldId` | UUID | Yes | | `id` | UUID | No | | `name` | String | Yes | | `operator` | String | Yes | | `paramName` | String | Yes | | `refFieldId` | UUID | Yes | | `refTableId` | UUID | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all spatialRelation records const items = await db.spatialRelation.findMany({ select: { category: true, createdAt: true, databaseId: true, fieldId: true, id: true, name: true, operator: true, paramName: true, refFieldId: true, refTableId: true, tableId: true, tags: true, updatedAt: true } }).execute(); // Get one by id const item = await db.spatialRelation.findOne({ id: '', select: { category: true, createdAt: true, databaseId: true, fieldId: true, id: true, name: true, operator: true, paramName: true, refFieldId: true, refTableId: true, tableId: true, tags: true, updatedAt: true } }).execute(); // Create const created = await db.spatialRelation.create({ data: { category: '', databaseId: '', fieldId: '', name: '', operator: '', paramName: '', refFieldId: '', refTableId: '', tableId: '', tags: '' }, select: { id: true } }).execute(); // Update const updated = await db.spatialRelation.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.spatialRelation.delete({ where: { id: '' } }).execute(); ``` ### `db.sqlAction` CRUD operations for SqlAction records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `actionId` | UUID | Yes | | `actionName` | String | Yes | | `actorId` | UUID | Yes | | `content` | String | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `deploy` | String | Yes | | `deps` | String | Yes | | `id` | Int | No | | `name` | String | Yes | | `payload` | JSON | Yes | | `revert` | String | Yes | | `verify` | String | Yes | **Operations:** ```typescript // List all sqlAction records const items = await db.sqlAction.findMany({ select: { actionId: true, actionName: true, actorId: true, content: true, createdAt: true, databaseId: true, deploy: true, deps: true, id: true, name: true, payload: true, revert: true, verify: true } }).execute(); // Get one by id const item = await db.sqlAction.findOne({ id: '', select: { actionId: true, actionName: true, actorId: true, content: true, createdAt: true, databaseId: true, deploy: true, deps: true, id: true, name: true, payload: true, revert: true, verify: true } }).execute(); // Update const updated = await db.sqlAction.update({ where: { id: '' }, data: { actionId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.sqlAction.delete({ where: { id: '' } }).execute(); ``` ### `db.tableBehavior` CRUD operations for TableBehavior records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `modifier` | String | Yes | | `scope` | String | Yes | | `sortOrder` | Int | Yes | | `tableId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all tableBehavior records const items = await db.tableBehavior.findMany({ select: { createdAt: true, databaseId: true, id: true, modifier: true, scope: true, sortOrder: true, tableId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.tableBehavior.findOne({ id: '', select: { createdAt: true, databaseId: true, id: true, modifier: true, scope: true, sortOrder: true, tableId: true, updatedAt: true } }).execute(); // Create const created = await db.tableBehavior.create({ data: { databaseId: '', modifier: '', scope: '', sortOrder: '', tableId: '' }, select: { id: true } }).execute(); // Update const updated = await db.tableBehavior.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.tableBehavior.delete({ where: { id: '' } }).execute(); ``` ### `db.table` CRUD operations for Table records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `description` | String | Yes | | `id` | UUID | No | | `inheritsId` | UUID | Yes | | `label` | String | Yes | | `name` | String | Yes | | `partitionKeyNames` | String | Yes | | `partitionKeyTypes` | String | Yes | | `partitionStrategy` | String | Yes | | `partitioned` | Boolean | Yes | | `peoplestamps` | Boolean | Yes | | `pluralName` | String | Yes | | `principalstamps` | Boolean | Yes | | `schemaId` | UUID | Yes | | `singularName` | String | Yes | | `smartTags` | JSON | Yes | | `stepUp` | JSON | Yes | | `tags` | String | Yes | | `timestamps` | Boolean | Yes | | `updatedAt` | Datetime | No | | `useRls` | Boolean | Yes | **Operations:** ```typescript // List all table records const items = await db.table.findMany({ select: { category: true, createdAt: true, databaseId: true, description: true, id: true, inheritsId: true, label: true, name: true, partitionKeyNames: true, partitionKeyTypes: true, partitionStrategy: true, partitioned: true, peoplestamps: true, pluralName: true, principalstamps: true, schemaId: true, singularName: true, smartTags: true, stepUp: true, tags: true, timestamps: true, updatedAt: true, useRls: true } }).execute(); // Get one by id const item = await db.table.findOne({ id: '', select: { category: true, createdAt: true, databaseId: true, description: true, id: true, inheritsId: true, label: true, name: true, partitionKeyNames: true, partitionKeyTypes: true, partitionStrategy: true, partitioned: true, peoplestamps: true, pluralName: true, principalstamps: true, schemaId: true, singularName: true, smartTags: true, stepUp: true, tags: true, timestamps: true, updatedAt: true, useRls: true } }).execute(); // Create const created = await db.table.create({ data: { category: '', databaseId: '', description: '', inheritsId: '', label: '', name: '', partitionKeyNames: '', partitionKeyTypes: '', partitionStrategy: '', partitioned: '', peoplestamps: '', pluralName: '', principalstamps: '', schemaId: '', singularName: '', smartTags: '', stepUp: '', tags: '', timestamps: '', useRls: '' }, select: { id: true } }).execute(); // Update const updated = await db.table.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.table.delete({ where: { id: '' } }).execute(); ``` ### `db.tableGrant` CRUD operations for TableGrant records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `fieldIds` | UUID | Yes | | `granteeName` | String | Yes | | `id` | UUID | No | | `isGrant` | Boolean | Yes | | `privilege` | String | Yes | | `tableId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all tableGrant records const items = await db.tableGrant.findMany({ select: { createdAt: true, databaseId: true, fieldIds: true, granteeName: true, id: true, isGrant: true, privilege: true, tableId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.tableGrant.findOne({ id: '', select: { createdAt: true, databaseId: true, fieldIds: true, granteeName: true, id: true, isGrant: true, privilege: true, tableId: true, updatedAt: true } }).execute(); // Create const created = await db.tableGrant.create({ data: { databaseId: '', fieldIds: '', granteeName: '', isGrant: '', privilege: '', tableId: '' }, select: { id: true } }).execute(); // Update const updated = await db.tableGrant.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.tableGrant.delete({ where: { id: '' } }).execute(); ``` ### `db.trigger` CRUD operations for Trigger records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `event` | String | Yes | | `events` | String | Yes | | `forEachRow` | Boolean | Yes | | `functionId` | UUID | Yes | | `functionName` | String | Yes | | `id` | UUID | No | | `kind` | String | Yes | | `name` | String | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `timing` | String | Yes | | `updatedAt` | Datetime | No | | `whenAst` | JSON | Yes | **Operations:** ```typescript // List all trigger records const items = await db.trigger.findMany({ select: { category: true, createdAt: true, databaseId: true, event: true, events: true, forEachRow: true, functionId: true, functionName: true, id: true, kind: true, name: true, smartTags: true, tableId: true, tags: true, timing: true, updatedAt: true, whenAst: true } }).execute(); // Get one by id const item = await db.trigger.findOne({ id: '', select: { category: true, createdAt: true, databaseId: true, event: true, events: true, forEachRow: true, functionId: true, functionName: true, id: true, kind: true, name: true, smartTags: true, tableId: true, tags: true, timing: true, updatedAt: true, whenAst: true } }).execute(); // Create const created = await db.trigger.create({ data: { category: '', databaseId: '', event: '', events: '', forEachRow: '', functionId: '', functionName: '', kind: '', name: '', smartTags: '', tableId: '', tags: '', timing: '', whenAst: '' }, select: { id: true } }).execute(); // Update const updated = await db.trigger.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.trigger.delete({ where: { id: '' } }).execute(); ``` ### `db.triggerFunction` CRUD operations for TriggerFunction records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `code` | String | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `name` | String | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all triggerFunction records const items = await db.triggerFunction.findMany({ select: { code: true, createdAt: true, databaseId: true, id: true, name: true, updatedAt: true } }).execute(); // Get one by id const item = await db.triggerFunction.findOne({ id: '', select: { code: true, createdAt: true, databaseId: true, id: true, name: true, updatedAt: true } }).execute(); // Create const created = await db.triggerFunction.create({ data: { code: '', databaseId: '', name: '' }, select: { id: true } }).execute(); // Update const updated = await db.triggerFunction.update({ where: { id: '' }, data: { code: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.triggerFunction.delete({ where: { id: '' } }).execute(); ``` ### `db.uniqueConstraintBehavior` CRUD operations for UniqueConstraintBehavior records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `modifier` | String | Yes | | `scope` | String | Yes | | `sortOrder` | Int | Yes | | `uniqueConstraintId` | UUID | Yes | | `updatedAt` | Datetime | No | **Operations:** ```typescript // List all uniqueConstraintBehavior records const items = await db.uniqueConstraintBehavior.findMany({ select: { createdAt: true, databaseId: true, id: true, modifier: true, scope: true, sortOrder: true, uniqueConstraintId: true, updatedAt: true } }).execute(); // Get one by id const item = await db.uniqueConstraintBehavior.findOne({ id: '', select: { createdAt: true, databaseId: true, id: true, modifier: true, scope: true, sortOrder: true, uniqueConstraintId: true, updatedAt: true } }).execute(); // Create const created = await db.uniqueConstraintBehavior.create({ data: { databaseId: '', modifier: '', scope: '', sortOrder: '', uniqueConstraintId: '' }, select: { id: true } }).execute(); // Update const updated = await db.uniqueConstraintBehavior.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.uniqueConstraintBehavior.delete({ where: { id: '' } }).execute(); ``` ### `db.uniqueConstraint` CRUD operations for UniqueConstraint records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `description` | String | Yes | | `fieldIds` | UUID | Yes | | `id` | UUID | No | | `initiallyDeferred` | Boolean | Yes | | `isDeferrable` | Boolean | Yes | | `name` | String | Yes | | `nullsNotDistinct` | Boolean | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `type` | String | Yes | | `updatedAt` | Datetime | No | | `withoutOverlaps` | Boolean | Yes | **Operations:** ```typescript // List all uniqueConstraint records const items = await db.uniqueConstraint.findMany({ select: { category: true, createdAt: true, databaseId: true, description: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, nullsNotDistinct: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true, withoutOverlaps: true } }).execute(); // Get one by id const item = await db.uniqueConstraint.findOne({ id: '', select: { category: true, createdAt: true, databaseId: true, description: true, fieldIds: true, id: true, initiallyDeferred: true, isDeferrable: true, name: true, nullsNotDistinct: true, smartTags: true, tableId: true, tags: true, type: true, updatedAt: true, withoutOverlaps: true } }).execute(); // Create const created = await db.uniqueConstraint.create({ data: { category: '', databaseId: '', description: '', fieldIds: '', initiallyDeferred: '', isDeferrable: '', name: '', nullsNotDistinct: '', smartTags: '', tableId: '', tags: '', type: '', withoutOverlaps: '' }, select: { id: true } }).execute(); // Update const updated = await db.uniqueConstraint.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.uniqueConstraint.delete({ where: { id: '' } }).execute(); ``` ### `db.viewBehavior` CRUD operations for ViewBehavior records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `createdAt` | Datetime | No | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `modifier` | String | Yes | | `scope` | String | Yes | | `sortOrder` | Int | Yes | | `updatedAt` | Datetime | No | | `viewId` | UUID | Yes | **Operations:** ```typescript // List all viewBehavior records const items = await db.viewBehavior.findMany({ select: { createdAt: true, databaseId: true, id: true, modifier: true, scope: true, sortOrder: true, updatedAt: true, viewId: true } }).execute(); // Get one by id const item = await db.viewBehavior.findOne({ id: '', select: { createdAt: true, databaseId: true, id: true, modifier: true, scope: true, sortOrder: true, updatedAt: true, viewId: true } }).execute(); // Create const created = await db.viewBehavior.create({ data: { databaseId: '', modifier: '', scope: '', sortOrder: '', viewId: '' }, select: { id: true } }).execute(); // Update const updated = await db.viewBehavior.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.viewBehavior.delete({ where: { id: '' } }).execute(); ``` ### `db.view` CRUD operations for View records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `category` | ObjectCategory | Yes | | `checkOption` | String | Yes | | `data` | JSON | Yes | | `databaseId` | UUID | Yes | | `filterData` | JSON | Yes | | `filterType` | String | Yes | | `id` | UUID | No | | `isReadOnly` | Boolean | Yes | | `name` | String | Yes | | `schemaId` | UUID | Yes | | `securityBarrier` | Boolean | Yes | | `securityInvoker` | Boolean | Yes | | `smartTags` | JSON | Yes | | `tableId` | UUID | Yes | | `tags` | String | Yes | | `viewType` | String | Yes | **Operations:** ```typescript // List all view records const items = await db.view.findMany({ select: { category: true, checkOption: true, data: true, databaseId: true, filterData: true, filterType: true, id: true, isReadOnly: true, name: true, schemaId: true, securityBarrier: true, securityInvoker: true, smartTags: true, tableId: true, tags: true, viewType: true } }).execute(); // Get one by id const item = await db.view.findOne({ id: '', select: { category: true, checkOption: true, data: true, databaseId: true, filterData: true, filterType: true, id: true, isReadOnly: true, name: true, schemaId: true, securityBarrier: true, securityInvoker: true, smartTags: true, tableId: true, tags: true, viewType: true } }).execute(); // Create const created = await db.view.create({ data: { category: '', checkOption: '', data: '', databaseId: '', filterData: '', filterType: '', isReadOnly: '', name: '', schemaId: '', securityBarrier: '', securityInvoker: '', smartTags: '', tableId: '', tags: '', viewType: '' }, select: { id: true } }).execute(); // Update const updated = await db.view.update({ where: { id: '' }, data: { category: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.view.delete({ where: { id: '' } }).execute(); ``` ### `db.viewGrant` CRUD operations for ViewGrant records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `databaseId` | UUID | Yes | | `granteeName` | String | Yes | | `id` | UUID | No | | `isGrant` | Boolean | Yes | | `privilege` | String | Yes | | `viewId` | UUID | Yes | | `withGrantOption` | Boolean | Yes | **Operations:** ```typescript // List all viewGrant records const items = await db.viewGrant.findMany({ select: { databaseId: true, granteeName: true, id: true, isGrant: true, privilege: true, viewId: true, withGrantOption: true } }).execute(); // Get one by id const item = await db.viewGrant.findOne({ id: '', select: { databaseId: true, granteeName: true, id: true, isGrant: true, privilege: true, viewId: true, withGrantOption: true } }).execute(); // Create const created = await db.viewGrant.create({ data: { databaseId: '', granteeName: '', isGrant: '', privilege: '', viewId: '', withGrantOption: '' }, select: { id: true } }).execute(); // Update const updated = await db.viewGrant.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.viewGrant.delete({ where: { id: '' } }).execute(); ``` ### `db.viewRule` CRUD operations for ViewRule records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `action` | String | Yes | | `databaseId` | UUID | Yes | | `event` | String | Yes | | `id` | UUID | No | | `name` | String | Yes | | `viewId` | UUID | Yes | **Operations:** ```typescript // List all viewRule records const items = await db.viewRule.findMany({ select: { action: true, databaseId: true, event: true, id: true, name: true, viewId: true } }).execute(); // Get one by id const item = await db.viewRule.findOne({ id: '', select: { action: true, databaseId: true, event: true, id: true, name: true, viewId: true } }).execute(); // Create const created = await db.viewRule.create({ data: { action: '', databaseId: '', event: '', name: '', viewId: '' }, select: { id: true } }).execute(); // Update const updated = await db.viewRule.update({ where: { id: '' }, data: { action: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.viewRule.delete({ where: { id: '' } }).execute(); ``` ### `db.viewTable` CRUD operations for ViewTable records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `databaseId` | UUID | Yes | | `id` | UUID | No | | `joinOrder` | Int | Yes | | `tableId` | UUID | Yes | | `viewId` | UUID | Yes | **Operations:** ```typescript // List all viewTable records const items = await db.viewTable.findMany({ select: { databaseId: true, id: true, joinOrder: true, tableId: true, viewId: true } }).execute(); // Get one by id const item = await db.viewTable.findOne({ id: '', select: { databaseId: true, id: true, joinOrder: true, tableId: true, viewId: true } }).execute(); // Create const created = await db.viewTable.create({ data: { databaseId: '', joinOrder: '', tableId: '', viewId: '' }, select: { id: true } }).execute(); // Update const updated = await db.viewTable.update({ where: { id: '' }, data: { databaseId: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.viewTable.delete({ where: { id: '' } }).execute(); ``` ### `db.webauthnSetting` CRUD operations for WebauthnSetting records. **Fields:** | Field | Type | Editable | |-------|------|----------| | `attestationType` | String | Yes | | `challengeExpirySeconds` | BigInt | Yes | | `createdAt` | Datetime | No | | `credentialsSchemaId` | UUID | Yes | | `credentialsTableId` | UUID | Yes | | `databaseId` | UUID | Yes | | `id` | UUID | No | | `originAllowlist` | String | Yes | | `requireUserVerification` | Boolean | Yes | | `residentKey` | String | Yes | | `rpId` | String | Yes | | `rpName` | String | Yes | | `schemaId` | UUID | Yes | | `sessionCredentialsTableId` | UUID | Yes | | `sessionSecretsSchemaId` | UUID | Yes | | `sessionSecretsTableId` | UUID | Yes | | `sessionsSchemaId` | UUID | Yes | | `sessionsTableId` | UUID | Yes | | `updatedAt` | Datetime | No | | `userFieldId` | UUID | Yes | **Operations:** ```typescript // List all webauthnSetting records const items = await db.webauthnSetting.findMany({ select: { attestationType: true, challengeExpirySeconds: true, createdAt: true, credentialsSchemaId: true, credentialsTableId: true, databaseId: true, id: true, originAllowlist: true, requireUserVerification: true, residentKey: true, rpId: true, rpName: true, schemaId: true, sessionCredentialsTableId: true, sessionSecretsSchemaId: true, sessionSecretsTableId: true, sessionsSchemaId: true, sessionsTableId: true, updatedAt: true, userFieldId: true } }).execute(); // Get one by id const item = await db.webauthnSetting.findOne({ id: '', select: { attestationType: true, challengeExpirySeconds: true, createdAt: true, credentialsSchemaId: true, credentialsTableId: true, databaseId: true, id: true, originAllowlist: true, requireUserVerification: true, residentKey: true, rpId: true, rpName: true, schemaId: true, sessionCredentialsTableId: true, sessionSecretsSchemaId: true, sessionSecretsTableId: true, sessionsSchemaId: true, sessionsTableId: true, updatedAt: true, userFieldId: true } }).execute(); // Create const created = await db.webauthnSetting.create({ data: { attestationType: '', challengeExpirySeconds: '', credentialsSchemaId: '', credentialsTableId: '', databaseId: '', originAllowlist: '', requireUserVerification: '', residentKey: '', rpId: '', rpName: '', schemaId: '', sessionCredentialsTableId: '', sessionSecretsSchemaId: '', sessionSecretsTableId: '', sessionsSchemaId: '', sessionsTableId: '', userFieldId: '' }, select: { id: true } }).execute(); // Update const updated = await db.webauthnSetting.update({ where: { id: '' }, data: { attestationType: '' }, select: { id: true } }).execute(); // Delete const deleted = await db.webauthnSetting.delete({ where: { id: '' } }).execute(); ``` ## Custom Operations ### `db.query.applyRegistryDefaults` applyRegistryDefaults - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `data` | JSON | | `nodeType` | String | ```typescript const result = await db.query.applyRegistryDefaults({ data: '', nodeType: '' }).execute(); ``` ### `db.query.emailSharedAccount` emailSharedAccount - **Type:** query - **Arguments:** none ```typescript const result = await db.query.emailSharedAccount().execute(); ``` ### `db.query.getSitePreviewCommit` getSitePreviewCommit - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `targetName` | String | | `targetSiteId` | UUID | ```typescript const result = await db.query.getSitePreviewCommit({ targetName: '', targetSiteId: '' }).execute(); ``` ### `db.query.getSiteReleaseManifest` getSiteReleaseManifest - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `targetCommitId` | UUID | | `targetSiteId` | UUID | ```typescript const result = await db.query.getSiteReleaseManifest({ targetCommitId: '', targetSiteId: '' }).execute(); ``` ### `db.query.pagePublished` pagePublished - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `pageSlug` | String | | `targetSiteId` | UUID | ```typescript const result = await db.query.pagePublished({ pageSlug: '', targetSiteId: '' }).execute(); ``` ### `db.query.platformGetSitePreviewCommit` platformGetSitePreviewCommit - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `targetName` | String | | `targetSiteId` | UUID | ```typescript const result = await db.query.platformGetSitePreviewCommit({ targetName: '', targetSiteId: '' }).execute(); ``` ### `db.query.platformGetSiteReleaseManifest` platformGetSiteReleaseManifest - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `targetCommitId` | UUID | | `targetSiteId` | UUID | ```typescript const result = await db.query.platformGetSiteReleaseManifest({ targetCommitId: '', targetSiteId: '' }).execute(); ``` ### `db.query.platformPagePublished` platformPagePublished - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `pageSlug` | String | | `targetSiteId` | UUID | ```typescript const result = await db.query.platformPagePublished({ pageSlug: '', targetSiteId: '' }).execute(); ``` ### `db.query.platformSitesDeepLinkUrl` platformSitesDeepLinkUrl - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `linkSlug` | String | | `targetSiteId` | UUID | ```typescript const result = await db.query.platformSitesDeepLinkUrl({ linkSlug: '', targetSiteId: '' }).execute(); ``` ### `db.query.platformSitesSiteOrigin` platformSitesSiteOrigin - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `targetSiteId` | UUID | ```typescript const result = await db.query.platformSitesSiteOrigin({ targetSiteId: '' }).execute(); ``` ### `db.query.platformVerifySitePreviewToken` platformVerifySitePreviewToken - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `siteId` | UUID | | `token` | String | ```typescript const result = await db.query.platformVerifySitePreviewToken({ siteId: '', token: '' }).execute(); ``` ### `db.query.sitesDeepLinkUrl` sitesDeepLinkUrl - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `linkSlug` | String | | `targetSiteId` | UUID | ```typescript const result = await db.query.sitesDeepLinkUrl({ linkSlug: '', targetSiteId: '' }).execute(); ``` ### `db.query.sitesSiteOrigin` sitesSiteOrigin - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `targetSiteId` | UUID | ```typescript const result = await db.query.sitesSiteOrigin({ targetSiteId: '' }).execute(); ``` ### `db.query.verifySitePreviewToken` verifySitePreviewToken - **Type:** query - **Arguments:** | Argument | Type | |----------|------| | `siteId` | UUID | | `token` | String | ```typescript const result = await db.query.verifySitePreviewToken({ siteId: '', token: '' }).execute(); ``` ### `db.mutation.acceptDatabaseTransfer` acceptDatabaseTransfer - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | AcceptDatabaseTransferInput (required) | ```typescript const result = await db.mutation.acceptDatabaseTransfer({ input: { transferId: '' } }).execute(); ``` ### `db.mutation.applyRls` applyRls - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | ApplyRlsInput (required) | ```typescript const result = await db.mutation.applyRls({ input: '' }).execute(); ``` ### `db.mutation.cancelDatabaseTransfer` cancelDatabaseTransfer - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | CancelDatabaseTransferInput (required) | ```typescript const result = await db.mutation.cancelDatabaseTransfer({ input: { transferId: '' } }).execute(); ``` ### `db.mutation.createFunctionFromSource` Creates a `Function` from its `CREATE FUNCTION` source text. - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | CreateFunctionFromSourceInput (required) | ```typescript const result = await db.mutation.createFunctionFromSource({ input: { apiExposed: '', databaseId: '', schemaId: '', source: '' } }).execute(); ``` ### `db.mutation.deleteSitePreview` deleteSitePreview - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | DeleteSitePreviewInput (required) | ```typescript const result = await db.mutation.deleteSitePreview({ input: { targetName: '', targetSiteId: '' } }).execute(); ``` ### `db.mutation.domainsAssignSubdomain` domainsAssignSubdomain - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | DomainsAssignSubdomainInput (required) | ```typescript const result = await db.mutation.domainsAssignSubdomain({ input: { apex: '', label: '', maxAttempts: '' } }).execute(); ``` ### `db.mutation.mintSitePreviewToken` mintSitePreviewToken - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | MintSitePreviewTokenInput (required) | ```typescript const result = await db.mutation.mintSitePreviewToken({ input: { siteId: '', target: '', targetKind: '', ttlSeconds: '' } }).execute(); ``` ### `db.mutation.pagesInstallPages` pagesInstallPages - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PagesInstallPagesInput (required) | ```typescript const result = await db.mutation.pagesInstallPages({ input: { entityId: '', pagesPreset: '', siteId: '' } }).execute(); ``` ### `db.mutation.platformDeleteSitePreview` platformDeleteSitePreview - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformDeleteSitePreviewInput (required) | ```typescript const result = await db.mutation.platformDeleteSitePreview({ input: { targetName: '', targetSiteId: '' } }).execute(); ``` ### `db.mutation.platformDomainsAssignSubdomain` platformDomainsAssignSubdomain - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformDomainsAssignSubdomainInput (required) | ```typescript const result = await db.mutation.platformDomainsAssignSubdomain({ input: { apex: '', label: '', maxAttempts: '' } }).execute(); ``` ### `db.mutation.platformMintSitePreviewToken` platformMintSitePreviewToken - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformMintSitePreviewTokenInput (required) | ```typescript const result = await db.mutation.platformMintSitePreviewToken({ input: { siteId: '', target: '', targetKind: '', ttlSeconds: '' } }).execute(); ``` ### `db.mutation.platformPagesInstallPages` platformPagesInstallPages - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformPagesInstallPagesInput (required) | ```typescript const result = await db.mutation.platformPagesInstallPages({ input: { entityId: '', pagesPreset: '', siteId: '' } }).execute(); ``` ### `db.mutation.platformProvisionSitePreview` platformProvisionSitePreview - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformProvisionSitePreviewInput (required) | ```typescript const result = await db.mutation.platformProvisionSitePreview({ input: { apex: '', commitId: '', name: '', siteId: '' } }).execute(); ``` ### `db.mutation.platformSetSitePreview` platformSetSitePreview - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformSetSitePreviewInput (required) | ```typescript const result = await db.mutation.platformSetSitePreview({ input: { targetCommitId: '', targetName: '', targetSiteId: '' } }).execute(); ``` ### `db.mutation.platformSiteMetadataInstallRobots` platformSiteMetadataInstallRobots - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformSiteMetadataInstallRobotsInput (required) | ```typescript const result = await db.mutation.platformSiteMetadataInstallRobots({ input: { entityId: '', robotsPreset: '', siteId: '' } }).execute(); ``` ### `db.mutation.platformSitesInstallContentPreset` platformSitesInstallContentPreset - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformSitesInstallContentPresetInput (required) | ```typescript const result = await db.mutation.platformSitesInstallContentPreset({ input: { entityId: '', presetKind: '', presetSlug: '', siteId: '' } }).execute(); ``` ### `db.mutation.platformSitesInstallMantra` platformSitesInstallMantra - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformSitesInstallMantraInput (required) | ```typescript const result = await db.mutation.platformSitesInstallMantra({ input: { entityId: '', routePreset: '', siteId: '' } }).execute(); ``` ### `db.mutation.platformSitesProvisionStaticSite` platformSitesProvisionStaticSite - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | PlatformSitesProvisionStaticSiteInput (required) | ```typescript const result = await db.mutation.platformSitesProvisionStaticSite({ input: '' }).execute(); ``` ### `db.mutation.provisionBucket` Reconcile an S3 bucket for a logical bucket in the database. Records the request on the bucket row via RLS; the bucket's job trigger then enqueues the same storage:provision_bucket job used on INSERT, and repeated requests collapse into one pending job. This is idempotent for an already-reconciled bucket; failures become GraphQL errors. - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | ProvisionBucketInput (required) | ```typescript const result = await db.mutation.provisionBucket({ input: { bucketKey: '', ownerId: '' } }).execute(); ``` ### `db.mutation.provisionSitePreview` provisionSitePreview - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | ProvisionSitePreviewInput (required) | ```typescript const result = await db.mutation.provisionSitePreview({ input: { apex: '', commitId: '', name: '', siteId: '' } }).execute(); ``` ### `db.mutation.rejectDatabaseTransfer` rejectDatabaseTransfer - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | RejectDatabaseTransferInput (required) | ```typescript const result = await db.mutation.rejectDatabaseTransfer({ input: { transferId: '' } }).execute(); ``` ### `db.mutation.requestDatabase` Requests a database and returns a ticket (database_provision_module row) to poll. Pass exactly one of preset_slug or modules. Pass organization_id to have the organization own the database from the start (the caller must be an owner of that organization); the requesting user is still the identity bootstrapped into the new database. Omit it for a personal database. The pool, presets, and owner bootstrap are private implementation details: a warm pool hit fulfills the ticket immediately (fulfilled_at set, deferred owner bootstrap), otherwise the database is cold-provisioned asynchronously with exactly the requested modules. Poll the ticket until status = 'completed'; it then carries database_id and fulfilled_at. Example usage: SELECT * FROM metaschema_public.request_database('my_app', 'example.com', preset_slug := 'full'); SELECT * FROM metaschema_public.request_database('my_app', 'example.com', modules := '["users_module", "emails_module"]'::jsonb); SELECT * FROM metaschema_public.request_database('team_app', 'example.com', preset_slug := 'full', organization_id := '00000000-0000-0000-0000-000000000000'::uuid); - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | RequestDatabaseInput (required) | ```typescript const result = await db.mutation.requestDatabase({ input: '' }).execute(); ``` ### `db.mutation.setFieldOrder` setFieldOrder - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | SetFieldOrderInput (required) | ```typescript const result = await db.mutation.setFieldOrder({ input: { fieldIds: '' } }).execute(); ``` ### `db.mutation.setSitePreview` setSitePreview - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | SetSitePreviewInput (required) | ```typescript const result = await db.mutation.setSitePreview({ input: { targetCommitId: '', targetName: '', targetSiteId: '' } }).execute(); ``` ### `db.mutation.siteMetadataInstallRobots` siteMetadataInstallRobots - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | SiteMetadataInstallRobotsInput (required) | ```typescript const result = await db.mutation.siteMetadataInstallRobots({ input: { entityId: '', robotsPreset: '', siteId: '' } }).execute(); ``` ### `db.mutation.sitesInstallContentPreset` sitesInstallContentPreset - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | SitesInstallContentPresetInput (required) | ```typescript const result = await db.mutation.sitesInstallContentPreset({ input: { entityId: '', presetKind: '', presetSlug: '', siteId: '' } }).execute(); ``` ### `db.mutation.sitesInstallMantra` sitesInstallMantra - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | SitesInstallMantraInput (required) | ```typescript const result = await db.mutation.sitesInstallMantra({ input: { entityId: '', routePreset: '', siteId: '' } }).execute(); ``` ### `db.mutation.sitesProvisionStaticSite` sitesProvisionStaticSite - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | SitesProvisionStaticSiteInput (required) | ```typescript const result = await db.mutation.sitesProvisionStaticSite({ input: '' }).execute(); ``` ### `db.mutation.suspendDatabase` suspendDatabase - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | SuspendDatabaseInput (required) | ```typescript const result = await db.mutation.suspendDatabase({ input: { databaseId: '', reason: '' } }).execute(); ``` ### `db.mutation.unsuspendDatabase` unsuspendDatabase - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | UnsuspendDatabaseInput (required) | ```typescript const result = await db.mutation.unsuspendDatabase({ input: { databaseId: '', reason: '' } }).execute(); ``` ### `db.mutation.updateFunctionFromSource` Replaces a `Function`'s definition from its source text; its database, schema and exposure are unchanged. - **Type:** mutation - **Arguments:** | Argument | Type | |----------|------| | `input` | UpdateFunctionFromSourceInput (required) | ```typescript const result = await db.mutation.updateFunctionFromSource({ input: { id: '', source: '' } }).execute(); ```