installed_nodes¶

Description¶

Table Definition

CREATE TABLE "installed_nodes" (
                "name" char(200) NOT NULL,
                "type" char(200) NOT NULL,
                "latestVersion" REAL DEFAULT 1,
                "package" char(214) NOT NULL,
                PRIMARY KEY ("name"),
                FOREIGN KEY ("package") REFERENCES "installed_packages" ("packageName") ON DELETE CASCADE ON UPDATE CASCADE
            )

Columns¶

Name	Type	Default	Nullable	Parents
latestVersion	REAL	1	true
name	char(200)		false
package	char(214)		false	installed_packages
type	char(200)		false

Constraints¶

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (package) REFERENCES installed_packages (packageName) ON UPDATE CASCADE ON DELETE CASCADE MATCH NONE
name	PRIMARY KEY	PRIMARY KEY (name)
sqlite_autoindex_installed_nodes_1	PRIMARY KEY	PRIMARY KEY (name)

Indexes¶

Name	Definition
sqlite_autoindex_installed_nodes_1	PRIMARY KEY (name)

Relations¶

erDiagram

"installed_nodes" }o--|| "installed_packages" : "FOREIGN KEY (package) REFERENCES installed_packages (packageName) ON UPDATE CASCADE ON DELETE CASCADE MATCH NONE"

"installed_nodes" {
  REAL latestVersion
  char_200_ name PK
  char_214_ package FK
  char_200_ type
}
"installed_packages" {
  char_70_ authorEmail
  char_70_ authorName
  datetime_3_ createdAt
  char_50_ installedVersion
  char_214_ packageName PK
  datetime_3_ updatedAt
}

Generated by tbls