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