mirror of https://github.com/n8n-io/n8n.git synced 2026-10-19 16:55:02 +02:00

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

2.9 KiB

Generated

Raw Permalink Blame History

public.app_version

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
appId	varchar(36)		false		public.app
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
createdById	uuid		true		public.user	User who published this version; null once they are deleted
id	varchar(36)		false	public.app
snapshot	json		false			Frozen page tree + theme, see AppVersionSnapshot
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
FK_e4eab717688459a6681c9f67cff	FOREIGN KEY	FOREIGN KEY ("createdById") REFERENCES "user"(id) ON DELETE SET NULL
FK_e9aeab5b1db8dc77708231ae44e	FOREIGN KEY	FOREIGN KEY ("appId") REFERENCES app(id) ON DELETE CASCADE
PK_f2573b981a7eac664875e7483ac	PRIMARY KEY	PRIMARY KEY (id)
app_version_appId_not_null	n	NOT NULL "appId"
app_version_createdAt_not_null	n	NOT NULL "createdAt"
app_version_id_not_null	n	NOT NULL id
app_version_snapshot_not_null	n	NOT NULL snapshot
app_version_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_e9aeab5b1db8dc77708231ae44	CREATE INDEX "IDX_e9aeab5b1db8dc77708231ae44" ON public.app_version USING btree ("appId")
PK_f2573b981a7eac664875e7483ac	CREATE UNIQUE INDEX "PK_f2573b981a7eac664875e7483ac" ON public.app_version USING btree (id)

Relations

erDiagram

"public.app_version" }o--|| "public.app" : "FOREIGN KEY (#quot;appId#quot;) REFERENCES app(id) ON DELETE CASCADE"
"public.app_version" }o--o| "public.user" : "FOREIGN KEY (#quot;createdById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL"
"public.app" }o--o| "public.app_version" : "FOREIGN KEY (#quot;activeVersionId#quot;) REFERENCES app_version(id) ON DELETE SET NULL"

"public.app_version" {
  varchar_36_ appId FK
  timestamp_3__with_time_zone createdAt
  uuid createdById FK
  varchar_36_ id
  json snapshot
  timestamp_3__with_time_zone updatedAt
}
"public.app" {
  varchar_36_ activeVersionId FK
  varchar_16_ auth
  text components
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  varchar_128_ name
  varchar_128_ namespace
  varchar_36_ projectId FK
  json theme
  timestamp_3__with_time_zone updatedAt
}
"public.user" {
  timestamp_3__with_time_zone createdAt
  boolean disabled
  varchar_255_ email
  varchar_32_ firstName
  uuid id
  date lastActiveAt
  varchar_32_ lastName
  boolean mfaEnabled
  text mfaRecoveryCodes
  text mfaSecret
  varchar_255_ password
  json personalizationAnswers
  varchar_128_ roleSlug FK
  json settings
  timestamp_3__with_time_zone updatedAt
}

Generated by tbls

2.9 KiB Generated Raw Permalink Blame History

public.app_version

Columns

Constraints

Indexes

Relations

2.9 KiB

Generated

Raw Permalink Blame History