n8n/docs/generated/postgres-schema/public.page.md

public.page

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
appId	varchar(36)		false		public.app
content	json		true			Block tree (Editor.js-shaped); empty until the renderer lands
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
dataWorkflowId	varchar(36)		true		public.workflow_entity	Workflow this page calls to fetch its data
id	varchar(36)		false	public.page
parentPageId	varchar(36)		true		public.page	Self-reference; null for a top-level page
route	varchar(255)		false			Path segment under its parent, may contain :params
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
FK_5e3cf5ed8328c4993a910bd239b	FOREIGN KEY	FOREIGN KEY ("appId") REFERENCES app(id) ON DELETE CASCADE
FK_b85a31f0bff1e857156d27ea152	FOREIGN KEY	FOREIGN KEY ("parentPageId") REFERENCES page(id) ON DELETE CASCADE
PK_742f4117e065c5b6ad21b37ba1f	PRIMARY KEY	PRIMARY KEY (id)
page_appId_not_null	n	NOT NULL "appId"
page_createdAt_not_null	n	NOT NULL "createdAt"
page_dataWorkflowId_foreign	FOREIGN KEY	FOREIGN KEY ("dataWorkflowId") REFERENCES workflow_entity(id) ON DELETE SET NULL
page_id_not_null	n	NOT NULL id
page_route_not_null	n	NOT NULL route
page_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_page_appId	CREATE INDEX "IDX_page_appId" ON public.page USING btree ("appId")
IDX_page_parentPageId	CREATE INDEX "IDX_page_parentPageId" ON public.page USING btree ("parentPageId")
PK_742f4117e065c5b6ad21b37ba1f	CREATE UNIQUE INDEX "PK_742f4117e065c5b6ad21b37ba1f" ON public.page USING btree (id)

Relations

erDiagram

"public.page" }o--|| "public.app" : "FOREIGN KEY (#quot;appId#quot;) REFERENCES app(id) ON DELETE CASCADE"
"public.page" }o--o| "public.workflow_entity" : "FOREIGN KEY (#quot;dataWorkflowId#quot;) REFERENCES workflow_entity(id) ON DELETE SET NULL"
"public.page" }o--o| "public.page" : "FOREIGN KEY (#quot;parentPageId#quot;) REFERENCES page(id) ON DELETE CASCADE"

"public.page" {
  varchar_36_ appId FK
  json content
  timestamp_3__with_time_zone createdAt
  varchar_36_ dataWorkflowId FK
  varchar_36_ id
  varchar_36_ parentPageId FK
  varchar_255_ route
  timestamp_3__with_time_zone updatedAt
}
"public.app" {
  varchar_36_ activeVersionId FK
  json bindings
  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.workflow_entity" {
  boolean active
  varchar_36_ activeVersionId FK
  json connections
  timestamp_3__with_time_zone createdAt
  text description
  varchar_36_ id
  boolean isArchived
  json meta
  varchar_128_ name
  json nodeGroups
  json nodes
  varchar_36_ parentFolderId FK
  json pinData
  json settings
  varchar sourceWorkflowId
  json staticData
  integer triggerCount
  timestamp_3__with_time_zone updatedAt
  integer versionCounter
  character_36_ versionId
}

---

Generated by tbls