n8n/docs/generated/sqlite-schema/app_version.md

app_version

Description

Table Definition

CREATE TABLE "app_version" ("id" varchar(36) PRIMARY KEY NOT NULL, "appId" varchar(36) NOT NULL, "storedAt" varchar(8) NOT NULL, "sourceStorageKey" varchar(255) NOT NULL, "distStorageKey" varchar(255), "sourceSizeBytes" integer NOT NULL DEFAULT (0), "distSizeBytes" integer, "label" varchar(128), "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 "CHK_app_version_storedAt" CHECK ("storedAt" IN ('db', 'fs', 's3', 'az')), CONSTRAINT "FK_e9aeab5b1db8dc77708231ae44e" FOREIGN KEY ("appId") REFERENCES "app" ("id") ON DELETE CASCADE)

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
distSizeBytes	INTEGER		true
distStorageKey	varchar(255)		true
id	varchar(36)		false	app
label	varchar(128)		true
sourceSizeBytes	INTEGER	0	false
sourceStorageKey	varchar(255)		false
storedAt	varchar(8)		false
updatedAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false

Constraints

Name	Type	Definition
-	CHECK	CHECK ("storedAt" IN ('db', 'fs', 's3', 'az'))
- (Foreign key ID: 0)	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" }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
  INTEGER distSizeBytes
  varchar_255_ distStorageKey
  varchar_36_ id PK
  varchar_128_ label
  INTEGER sourceSizeBytes
  varchar_255_ sourceStorageKey
  varchar_8_ storedAt
  datetime_3_ updatedAt
}
"app" {
  varchar_36_ activeVersionId FK
  TEXT bindings
  datetime_3_ createdAt
  varchar_36_ id PK
  varchar_128_ name
  varchar_128_ namespace
  varchar_36_ projectId FK
  TEXT theme
  datetime_3_ updatedAt
}

---

Generated by tbls