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

app_version

Description

Table Definition

CREATE TABLE "app_version" ("id" varchar PRIMARY KEY NOT NULL, "appId" varchar NOT NULL, "label" varchar(255), "sourceArtifactId" integer NOT NULL, "bundleArtifactId" integer, "buildAttempts" integer NOT NULL DEFAULT (0), "buildStatus" varchar(16) NOT NULL DEFAULT ('queued'), "buildStatusUpdatedAt" datetime(3), "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_buildStatus" CHECK ("buildStatus" IN ('queued', 'running', 'succeeded', 'failed')), CONSTRAINT "FK_e9aeab5b1db8dc77708231ae44e" FOREIGN KEY ("appId") REFERENCES "app" ("id") ON DELETE CASCADE, CONSTRAINT "FK_9f1db6f02f5a0d1ae2f2b41a327" FOREIGN KEY ("sourceArtifactId") REFERENCES "app_artifact" ("id") ON DELETE RESTRICT, CONSTRAINT "FK_2ab536cbf97d71bad59517afee5" FOREIGN KEY ("bundleArtifactId") REFERENCES "app_artifact" ("id") ON DELETE SET NULL)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
appId	varchar		false		app
buildAttempts	INTEGER	0	false
buildStatus	varchar(16)	'queued'	false
buildStatusUpdatedAt	datetime(3)		true
bundleArtifactId	INTEGER		true		app_artifact
createdAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
id	varchar		false	app
label	varchar(255)		true
sourceArtifactId	INTEGER		false		app_artifact
updatedAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false

Constraints

Name	Type	Definition
-	CHECK	CHECK ("buildStatus" IN ('queued', 'running', 'succeeded', 'failed'))
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (bundleArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (sourceArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE RESTRICT MATCH NONE
- (Foreign key ID: 2)	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_2ab536cbf97d71bad59517afee	CREATE INDEX "IDX_2ab536cbf97d71bad59517afee" ON "app_version" ("bundleArtifactId")
IDX_9f1db6f02f5a0d1ae2f2b41a32	CREATE INDEX "IDX_9f1db6f02f5a0d1ae2f2b41a32" ON "app_version" ("sourceArtifactId")
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| "app_artifact" : "FOREIGN KEY (bundleArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"app" }o--o| "app_version" : "FOREIGN KEY (publishedVersionId) REFERENCES app_version (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"app" }o--o| "app_version" : "FOREIGN KEY (draftVersionId) REFERENCES app_version (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"app_version" }o--|| "app_artifact" : "FOREIGN KEY (sourceArtifactId) REFERENCES app_artifact (id) ON UPDATE NO ACTION ON DELETE RESTRICT MATCH NONE"

"app_version" {
  varchar appId FK
  INTEGER buildAttempts
  varchar_16_ buildStatus
  datetime_3_ buildStatusUpdatedAt
  INTEGER bundleArtifactId FK
  datetime_3_ createdAt
  varchar id PK
  varchar_255_ label
  INTEGER sourceArtifactId FK
  datetime_3_ updatedAt
}
"app" {
  datetime_3_ createdAt
  varchar draftVersionId FK
  varchar id PK
  varchar_128_ name
  varchar_128_ namespace
  varchar_36_ projectId FK
  varchar publishedVersionId FK
  datetime_3_ updatedAt
  varchar_16_ visibility
}
"app_artifact" {
  varchar appId
  datetime_3_ createdAt
  INTEGER id
  INTEGER sizeBytes
  TEXT storageKey
  varchar_2_ storedAt
  datetime_3_ updatedAt
  varchar_16_ uploadStatus
}

---

Generated by tbls