github-mirror/n8n
1
0
Fork 0
mirror of https://github.com/n8n-io/n8n.git synced 2026-10-22 12:31:57 +02:00
Code Issues Actions 19 Packages Projects Releases Wiki Activity Graph
hackweek/n8nable-json-content
n8n/docs/generated/sqlite-schema/app_version.md
Dimitri Lavrenük 76385b3d3e
wip(core): Apps round 7 stream A: action fixes and shared contracts (no-changelog) 
Row actions accept only rows the table shows on the rendered page; actions on a dynamic page redirect back to it (the action URL carries the rendered path). The layout preview keeps form controls, inert. create-page accepts a layout. Contracts for the parallel streams: agent-chat block, theme.contentWidth, App.components with migration and snapshot field, layout presets placeholder, access token mode, shared request authorizer.

Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>
2026-09-10 11:13:58 +02:00

3.0 KiB
Generated
Raw Permalink Blame History

app_version

Description

Table Definition 
CREATE TABLE "app_version" ("id" varchar(36) PRIMARY KEY NOT NULL, "appId" varchar(36) NOT NULL, "snapshot" text NOT NULL, "createdById" varchar, "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), CONSTRAINT "FK_e9aeab5b1db8dc77708231ae44e" FOREIGN KEY ("appId") REFERENCES "app" ("id") ON DELETE CASCADE, CONSTRAINT "FK_e4eab717688459a6681c9f67cff" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL)

Columns

Name Type Default Nullable Children Parents Comment
appId varchar(36) false app
createdAt datetime(3) STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') false
createdById varchar true user
id varchar(36) false app
snapshot TEXT false
updatedAt datetime(3) STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') false

Constraints

Name Type Definition
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
- (Foreign key ID: 1) FOREIGN KEY FOREIGN KEY (appId) REFERENCES app (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
id PRIMARY KEY PRIMARY KEY (id)
sqlite_autoindex_app_version_1 PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
IDX_e9aeab5b1db8dc77708231ae44 CREATE INDEX "IDX_e9aeab5b1db8dc77708231ae44" ON "app_version" ("appId")
sqlite_autoindex_app_version_1 PRIMARY KEY (id)

Relations

erDiagram

"app_version" }o--|| "app" : "FOREIGN KEY (appId) REFERENCES app (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"app_version" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"app" }o--o| "app_version" : "FOREIGN KEY (activeVersionId) REFERENCES app_version (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"

"app_version" {
  varchar_36_ appId FK
  datetime_3_ createdAt
  varchar createdById FK
  varchar_36_ id PK
  TEXT snapshot
  datetime_3_ updatedAt
}
"app" {
  varchar_36_ activeVersionId FK
  varchar_16_ auth
  TEXT components
  datetime_3_ createdAt
  varchar_36_ id PK
  varchar_128_ name
  varchar_128_ namespace
  varchar_36_ projectId FK
  TEXT theme
  datetime_3_ updatedAt
}
"user" {
  datetime_3_ createdAt
  boolean disabled
  varchar_255_ email
  varchar_32_ firstName
  varchar id PK
  date lastActiveAt
  varchar_32_ lastName
  boolean mfaEnabled
  TEXT mfaRecoveryCodes
  TEXT mfaSecret
  varchar password
  TEXT personalizationAnswers
  varchar_128_ roleSlug FK
  TEXT settings
  datetime_3_ updatedAt
}

Generated by tbls