Test

Tables (50)

AiMessage

  • id — SERIAL — Primary key — NOT NULL
  • sessionId — INTEGER — Foreign key → AiSession.id — NOT NULL
  • role — "AiRole" — NOT NULL
  • content — TEXT
  • type — "AiMessageType" — NOT NULL
  • payload — JSON
  • toolCallId — TEXT
  • createdAt — TIMESTAMP(3) — NOT NULL

AiSession

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — Foreign key → Project.id — NOT NULL
  • title — TEXT
  • tokenUsage — INTEGER — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

CanonicalDataType

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT

CheckConstraint

  • id — SERIAL — Primary key — NOT NULL
  • tableId — INTEGER — Foreign key → Table.id — NOT NULL
  • name — TEXT
  • checkExpression — TEXT — NOT NULL

Column

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • isNullable — BOOLEAN — NOT NULL
  • isUnique — BOOLEAN — NOT NULL
  • isPrimaryKey — BOOLEAN — NOT NULL
  • defaultValue — TEXT
  • comment — TEXT
  • length — INTEGER
  • precision — INTEGER
  • scale — INTEGER
  • isUnsigned — BOOLEAN — NOT NULL
  • isAutoIncrement — BOOLEAN — NOT NULL
  • isArray — BOOLEAN — NOT NULL
  • isUpdatedAt — BOOLEAN — NOT NULL
  • generatedExpression — TEXT
  • generationType — "GeneratedType"
  • order — INTEGER — NOT NULL
  • tableId — INTEGER — Foreign key → Table.id — NOT NULL
  • dataTypeId — INTEGER — Foreign key → DialectDataType.id
  • enumId — INTEGER — Foreign key → Enum.id
  • compositeTypeId — INTEGER — Foreign key → CompositeType.id

CompositeAttribute

  • id — SERIAL — Primary key — NOT NULL
  • compositeTypeId — INTEGER — Foreign key → CompositeType.id — NOT NULL
  • name — TEXT — NOT NULL
  • dataTypeId — INTEGER — Foreign key → DialectDataType.id
  • enumId — INTEGER — Foreign key → Enum.id
  • nestedCompositeTypeId — INTEGER — Foreign key → CompositeType.id
  • isArray — BOOLEAN — NOT NULL

CompositeType

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — Foreign key → Project.id — NOT NULL
  • name — TEXT — NOT NULL
  • comment — TEXT

DialectDataType

  • id — SERIAL — Primary key — NOT NULL
  • dialectId — INTEGER — Foreign key → SqlDialect.id — NOT NULL
  • canonicalTypeId — INTEGER — Foreign key → CanonicalDataType.id — NOT NULL
  • sqlType — TEXT — NOT NULL

DialectOverride

  • id — SERIAL — Primary key — NOT NULL
  • columnId — INTEGER — Foreign key → Column.id — NOT NULL
  • dialectId — INTEGER — Foreign key → SqlDialect.id — NOT NULL
  • overrideData — JSON — NOT NULL

Entitlement

  • id — SERIAL — Primary key — NOT NULL
  • key — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • type — "EntitlementType" — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

EntitlementUsagePeriod

  • id — SERIAL — Primary key — NOT NULL
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL
  • entitlementId — INTEGER — Foreign key → Entitlement.id — NOT NULL
  • grantedAmount — INTEGER — NOT NULL
  • consumedAmount — INTEGER — NOT NULL
  • periodStart — TIMESTAMP(3) — NOT NULL
  • periodEnd — TIMESTAMP(3) — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Enum

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — Foreign key → Project.id — NOT NULL
  • name — TEXT — NOT NULL
  • comment — TEXT

EnumValue

  • id — SERIAL — Primary key — NOT NULL
  • enumId — INTEGER — Foreign key → Enum.id — NOT NULL
  • value — TEXT — NOT NULL

FileAsset

  • id — TEXT — Primary key — NOT NULL
  • key — TEXT — NOT NULL
  • active — BOOLEAN — NOT NULL
  • expiresAt — TIMESTAMP(3) — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

GatewayCustomer

  • id — SERIAL — Primary key — NOT NULL
  • gatewayType — "PaymentGatewayType" — NOT NULL
  • gatewayCustomerId — TEXT — NOT NULL
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL

GatewayPrice

  • id — SERIAL — Primary key — NOT NULL
  • gatewayPriceId — TEXT — NOT NULL
  • gateway — "PaymentGatewayType" — NOT NULL
  • currency — TEXT — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • priceId — INTEGER — Foreign key → Price.id — NOT NULL

GrantedEntitlement

  • id — SERIAL — Primary key — NOT NULL
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL
  • entitlementId — INTEGER — Foreign key → Entitlement.id — NOT NULL
  • currentValue — INTEGER — NOT NULL
  • lastGrantedAt — TIMESTAMP(3)
  • nextResetAt — TIMESTAMP(3)
  • expiresAt — TIMESTAMP(3)
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Index

  • id — SERIAL — Primary key — NOT NULL
  • tableId — INTEGER — Foreign key → Table.id — NOT NULL
  • name — TEXT
  • type — "IndexType" — NOT NULL
  • algorithm — "IndexAlgorithm"
  • parser — TEXT
  • isVisible — BOOLEAN — NOT NULL
  • isClustered — BOOLEAN — NOT NULL

IndexColumn

  • id — SERIAL — Primary key — NOT NULL
  • indexId — INTEGER — Foreign key → Index.id — NOT NULL
  • columnName — TEXT — NOT NULL
  • sortOrder — "SortOrder" — NOT NULL
  • length — INTEGER

Invoice

  • id — SERIAL — Primary key — NOT NULL
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL
  • subscriptionId — INTEGER — Foreign key → Subscription.id
  • status — "InvoiceStatus" — NOT NULL
  • subtotal — DECIMAL(10,2) — NOT NULL
  • taxAmount — DECIMAL(10,2) — NOT NULL
  • totalAmount — DECIMAL(10,2) — NOT NULL
  • currency — TEXT — NOT NULL
  • periodStart — TIMESTAMP(3)
  • periodEnd — TIMESTAMP(3)
  • paidAt — TIMESTAMP(3)
  • gatewayInvoiceId — TEXT
  • invoicePdfUrl — TEXT
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Migration

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — Foreign key → Project.id — NOT NULL
  • name — TEXT — NOT NULL
  • fromVersion — INTEGER — NOT NULL
  • toVersion — INTEGER — NOT NULL
  • status — "MigrationStatus" — NOT NULL
  • changesSummary — JSON
  • appliedAt — TIMESTAMP(3)
  • rolledBackAt — TIMESTAMP(3)
  • createdAt — TIMESTAMP(3) — NOT NULL

MigrationScript

  • id — SERIAL — Primary key — NOT NULL
  • migrationId — INTEGER — Foreign key → Migration.id — NOT NULL
  • dialectId — INTEGER — Foreign key → SqlDialect.id — NOT NULL
  • upScript — TEXT — NOT NULL
  • downScript — TEXT — NOT NULL

Organization

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • creatorId — INTEGER — Foreign key → User.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

OrganizationInvitation

  • id — SERIAL — Primary key — NOT NULL
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL
  • invitedByUserId — INTEGER — Foreign key → User.id — NOT NULL
  • roleId — INTEGER — Foreign key → OrganizationRole.id — NOT NULL
  • email — TEXT — NOT NULL
  • status — "InvitationStatus" — NOT NULL
  • token — TEXT — NOT NULL
  • expiresAt — TIMESTAMP(3) — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

OrganizationRole

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

OrganizationRolePermission

  • id — SERIAL — Primary key — NOT NULL
  • permissionId — INTEGER — Foreign key → Permission.id — NOT NULL
  • organizationRoleId — INTEGER — Foreign key → OrganizationRole.id — NOT NULL
  • active — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Otp

  • id — SERIAL — Primary key — NOT NULL
  • purpose — "OtpPurpose" — NOT NULL
  • referenceId — INTEGER — NOT NULL
  • otp — TEXT — NOT NULL
  • expiresAt — TIMESTAMP(3) — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

Permission

  • id — SERIAL — Primary key — NOT NULL
  • title — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Plan

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • active — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

PlanEntitlement

  • id — SERIAL — Primary key — NOT NULL
  • value — INTEGER
  • resetInterval — "ResetInterval"
  • planId — INTEGER — Foreign key → Plan.id — NOT NULL
  • entitlementId — INTEGER — Foreign key → Entitlement.id — NOT NULL

Price

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • interval — "BillingInterval"
  • pricingType — "PricingType" — NOT NULL
  • trialDays — INTEGER
  • active — BOOLEAN — NOT NULL
  • planId — INTEGER — Foreign key → Plan.id

Project

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • workspaceId — INTEGER — Foreign key → Workspace.id — NOT NULL
  • dialectId — INTEGER — Foreign key → SqlDialect.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

ProjectAccess

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — Foreign key → Project.id — NOT NULL
  • userOrganizationId — INTEGER — Foreign key → UserOrganization.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

Relationship

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — NOT NULL
  • name — TEXT
  • fromTableId — INTEGER — Foreign key → Table.id — NOT NULL
  • toTableId — INTEGER — Foreign key → Table.id — NOT NULL
  • type — "RelationshipType" — NOT NULL
  • onDelete — "ReferentialAction" — NOT NULL
  • onUpdate — "ReferentialAction" — NOT NULL

RelationshipColumnMapping

  • id — SERIAL — Primary key — NOT NULL
  • relationshipId — INTEGER — Foreign key → Relationship.id — NOT NULL
  • fromColumnName — TEXT — NOT NULL
  • toColumnName — TEXT — NOT NULL

Role

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

RolePermission

  • id — SERIAL — Primary key — NOT NULL
  • permissionId — INTEGER — Foreign key → Permission.id — NOT NULL
  • roleId — INTEGER — Foreign key → Role.id — NOT NULL
  • active — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

SchemaVersion

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — Foreign key → Project.id — NOT NULL
  • versionNumber — INTEGER — NOT NULL
  • source — "VersionSource" — NOT NULL
  • name — TEXT
  • description — TEXT
  • snapshotData — JSON — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • createdBy — TEXT

SqlDialect

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • slug — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Subscription

  • id — SERIAL — Primary key — NOT NULL
  • gatewaySubscriptionId — TEXT — NOT NULL
  • status — "SubscriptionStatus" — NOT NULL
  • currentPeriodStart — TIMESTAMP(3)
  • currentPeriodEnd — TIMESTAMP(3)
  • canceledAt — TIMESTAMP(3)
  • endedAt — TIMESTAMP(3)
  • cancelAtPeriodEnd — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL

SubscriptionItem

  • id — SERIAL — Primary key — NOT NULL
  • subscriptionId — INTEGER — Foreign key → Subscription.id — NOT NULL
  • priceId — INTEGER — Foreign key → Price.id — NOT NULL
  • quantity — INTEGER — NOT NULL
  • gatewayItemId — TEXT
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

SubscriptionPendingChange

  • id — SERIAL — Primary key — NOT NULL
  • subscriptionId — INTEGER — Foreign key → Subscription.id — NOT NULL
  • effectiveDate — TIMESTAMP(3) — NOT NULL
  • actionType — "ChangeAction" — NOT NULL
  • nextPriceId — INTEGER — Foreign key → Price.id
  • source — "ChangeSource" — NOT NULL
  • polarMetadata — JSON
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Table

  • id — SERIAL — Primary key — NOT NULL
  • projectId — INTEGER — Foreign key → Project.id — NOT NULL
  • name — TEXT — NOT NULL
  • comment — TEXT
  • engine — TEXT
  • charset — TEXT
  • collation — TEXT
  • autoIncrementStart — INTEGER
  • order — INTEGER — NOT NULL
  • color — TEXT
  • posX — INTEGER — NOT NULL
  • posY — INTEGER — NOT NULL

Transaction

  • id — SERIAL — Primary key — NOT NULL
  • gatewayCustomerId — INTEGER — Foreign key → GatewayCustomer.id
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL
  • priceId — INTEGER — Foreign key → Price.id
  • gatewayPriceId — INTEGER — Foreign key → GatewayPrice.id
  • subscriptionId — INTEGER — Foreign key → Subscription.id
  • invoiceId — INTEGER — Foreign key → Invoice.id
  • gatewayTransactionId — TEXT
  • amount — DECIMAL(10,2) — NOT NULL
  • currency — TEXT — NOT NULL
  • status — "TransactionStatus" — NOT NULL
  • gatewayType — "PaymentGatewayType" — NOT NULL
  • processedAt — TIMESTAMP(3) — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

User

  • id — SERIAL — Primary key — NOT NULL
  • uuid — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • photo — TEXT
  • email — TEXT — NOT NULL
  • password — TEXT
  • phone — TEXT
  • bio — TEXT
  • active — BOOLEAN — NOT NULL
  • deletedAt — TIMESTAMP(3)
  • emailVerifiedAt — TIMESTAMP(3)
  • phoneVerifiedAt — TIMESTAMP(3)
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • roleId — INTEGER — Foreign key → Role.id — NOT NULL

UserLogin

  • id — SERIAL — Primary key — NOT NULL
  • userId — INTEGER — Foreign key → User.id — NOT NULL
  • deviceType — TEXT — NOT NULL
  • deviceOs — TEXT — NOT NULL
  • deviceOsVersion — TEXT — NOT NULL
  • browser — TEXT — NOT NULL
  • browserVersion — TEXT — NOT NULL
  • ipAddress — TEXT — NOT NULL
  • loginAt — TIMESTAMP(3) — NOT NULL
  • logoutAt — TIMESTAMP(3)
  • lastActivityAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

UserOauthTokens

  • id — SERIAL — Primary key — NOT NULL
  • userId — INTEGER — Foreign key → User.id — NOT NULL
  • provider — "AuthProvider" — NOT NULL
  • providerId — TEXT — NOT NULL
  • refreshToken — TEXT
  • refreshTokenIv — TEXT
  • refreshTokenTag — TEXT
  • refreshTokenExpiresAt — TIMESTAMP(3)
  • tokenType — TEXT
  • scopes — TEXT
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

UserOrganization

  • id — SERIAL — Primary key — NOT NULL
  • userId — INTEGER — Foreign key → User.id — NOT NULL
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL
  • roleId — INTEGER — Foreign key → OrganizationRole.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

Workspace

  • id — SERIAL — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • organizationId — INTEGER — Foreign key → Organization.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

WorkspaceAccess

  • id — SERIAL — Primary key — NOT NULL
  • workspaceId — INTEGER — Foreign key → Workspace.id — NOT NULL
  • userOrganizationId — INTEGER — Foreign key → UserOrganization.id — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL