mirror of
https://github.com/n8n-io/n8n.git
synced 2026-07-27 19:15:01 +02:00
55 lines
1.8 KiB
Markdown
55 lines
1.8 KiB
Markdown
# 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](public.installed_packages.md) | |
|
|
| 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
|
|
|
|
```mermaid
|
|
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](https://github.com/k1LoW/tbls)
|