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

public.installed_nodes

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
latestVersion	double precision	1	false
name	varchar(200)		false
package	varchar(241)		false		public.installed_packages
type	varchar(200)		false

Constraints

Name	Type	Definition
FK_73f857fc5dce682cef8a99c11dbddbc969618951	FOREIGN KEY	FOREIGN KEY (package) REFERENCES installed_packages("packageName") ON UPDATE CASCADE ON DELETE CASCADE
PK_8ebd28194e4f792f96b5933423fc439df97d9689	PRIMARY KEY	PRIMARY KEY (name)
installed_nodes_latestVersion_not_null	n	NOT NULL "latestVersion"
installed_nodes_name_not_null	n	NOT NULL name
installed_nodes_package_not_null	n	NOT NULL package
installed_nodes_type_not_null	n	NOT NULL type

Indexes

Name	Definition
PK_8ebd28194e4f792f96b5933423fc439df97d9689	CREATE UNIQUE INDEX "PK_8ebd28194e4f792f96b5933423fc439df97d9689" ON public.installed_nodes USING btree (name)

Relations

erDiagram

"public.installed_nodes" }o--|| "public.installed_packages" : "FOREIGN KEY (package) REFERENCES installed_packages(#quot;packageName#quot;) ON UPDATE CASCADE ON DELETE CASCADE"

"public.installed_nodes" {
  double_precision latestVersion
  varchar_200_ name
  varchar_241_ package FK
  varchar_200_ type
}
"public.installed_packages" {
  varchar_70_ authorEmail
  varchar_70_ authorName
  timestamp_3__with_time_zone createdAt
  varchar_50_ installedVersion
  varchar_214_ packageName
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls