installed_packages

Description

Table Definition

CREATE TABLE "installed_packages" ("packageName"    char(214) NOT NULL,"installedVersion"   char(50) NOT NULL,"authorName"  char(70) NULL,"authorEmail" char(70) NULL,"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'')',PRIMARY KEY("packageName"))

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
authorEmail	char(70)		true
authorName	char(70)		true
createdAt	datetime(3)	'STRFTIME(''%Y-%m-%d %H:%M:%f'', ''NOW'')'	false
installedVersion	char(50)		false
packageName	char(214)		false	installed_nodes
updatedAt	datetime(3)	'STRFTIME(''%Y-%m-%d %H:%M:%f'', ''NOW'')'	false

Constraints

Name	Type	Definition
packageName	PRIMARY KEY	PRIMARY KEY (packageName)
sqlite_autoindex_installed_packages_1	PRIMARY KEY	PRIMARY KEY (packageName)

Indexes

Name	Definition
sqlite_autoindex_installed_packages_1	PRIMARY KEY (packageName)

Relations

erDiagram

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

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

---

Generated by tbls