github-mirror/n8n
1
0
Fork 0
mirror of https://github.com/n8n-io/n8n.git synced 2026-07-27 11:05:14 +02:00
Code Issues Actions 14 Packages Projects Releases Wiki Activity Graph
master
n8n/docs/generated/postgres-schema/public.instance_credential_assignment.md
Albert Alises 13becf336c
feat(core): Add instance credential database schema (#34709) 
Co-authored-by: Danny Martini <danny@n8n.io>
Co-authored-by: Claude Fable 5 <noreply@anthropic.com>
2026-07-24 09:37:33 +00:00

2.4 KiB
Raw Permalink Blame History

public.instance_credential_assignment

Columns

Name Type Default Nullable Children Parents Comment
createdAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false
credentialId varchar(36) false public.credentials_entity Credential assigned to the registered use; repositories enforce instance usage scope
credentialUseId varchar(128) false Stable credential use registered with the instance credential broker
updatedAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false

Constraints

Name Type Definition
FK_instance_credential_assignment_credential FOREIGN KEY FOREIGN KEY ("credentialId") REFERENCES credentials_entity(id) ON DELETE RESTRICT
PK_984b0a98726485c9a330cde6b2f PRIMARY KEY PRIMARY KEY ("credentialUseId")
instance_credential_assignment_createdAt_not_null n NOT NULL "createdAt"
instance_credential_assignment_credentialId_not_null n NOT NULL "credentialId"
instance_credential_assignment_credentialUseId_not_null n NOT NULL "credentialUseId"
instance_credential_assignment_updatedAt_not_null n NOT NULL "updatedAt"

Indexes

Name Definition
IDX_9626b8dc1bee96a86a3ee09d73 CREATE INDEX "IDX_9626b8dc1bee96a86a3ee09d73" ON public.instance_credential_assignment USING btree ("credentialId")
PK_984b0a98726485c9a330cde6b2f CREATE UNIQUE INDEX "PK_984b0a98726485c9a330cde6b2f" ON public.instance_credential_assignment USING btree ("credentialUseId")

Relations

erDiagram

"public.instance_credential_assignment" }o--|| "public.credentials_entity" : "FOREIGN KEY (#quot;credentialId#quot;) REFERENCES credentials_entity(id) ON DELETE RESTRICT"

"public.instance_credential_assignment" {
  timestamp_3__with_time_zone createdAt
  varchar_36_ credentialId FK
  varchar_128_ credentialUseId
  timestamp_3__with_time_zone updatedAt
}
"public.credentials_entity" {
  timestamp_3__with_time_zone createdAt
  text data
  varchar_36_ id
  boolean isGlobal
  boolean isManaged
  boolean isResolvable
  varchar_128_ name
  boolean resolvableAllowFallback
  varchar_16_ resolverId FK
  varchar_128_ type
  timestamp_3__with_time_zone updatedAt
  varchar_16_ usageScope
}

Generated by tbls