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

public.promotion_connection

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
id	varchar(36)		false	public.promotion_config public.promotion_connection_project public.promotion_review
name	varchar(128)		false
providerId	varchar(36)		false		public.promotion_provider	The provider whose credentials this connection uses.
scope	varchar(16)		false			PromotionConnectionScope enum: "instance", "projects". Cannot change after creation.
target	json		false			Where to push and pull, with its own schemaVersion. Plain Git stores the full remote URL.
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
CHK_promotion_connection_scope	CHECK	CHECK (((scope)::text = ANY ((ARRAY['instance'::character varying, 'projects'::character varying])::text[])))
FK_promotion_connection_providerId	FOREIGN KEY	FOREIGN KEY ("providerId") REFERENCES promotion_provider(id) ON DELETE RESTRICT
PK_65cec79aba16950b45592335204	PRIMARY KEY	PRIMARY KEY (id)
promotion_connection_createdAt_not_null	n	NOT NULL "createdAt"
promotion_connection_id_not_null	n	NOT NULL id
promotion_connection_name_not_null	n	NOT NULL name
promotion_connection_providerId_not_null	n	NOT NULL "providerId"
promotion_connection_scope_not_null	n	NOT NULL scope
promotion_connection_target_not_null	n	NOT NULL target
promotion_connection_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_9917feaa6ed5705046432b117f	CREATE INDEX "IDX_9917feaa6ed5705046432b117f" ON public.promotion_connection USING btree ("providerId")
IDX_promotion_connection_scope	CREATE UNIQUE INDEX "IDX_promotion_connection_scope" ON public.promotion_connection USING btree (scope) WHERE ((scope)::text = 'instance'::text)
PK_65cec79aba16950b45592335204	CREATE UNIQUE INDEX "PK_65cec79aba16950b45592335204" ON public.promotion_connection USING btree (id)

Relations

erDiagram

"public.promotion_config" }o--|| "public.promotion_connection" : "FOREIGN KEY (#quot;connectionId#quot;) REFERENCES promotion_connection(id) ON DELETE CASCADE"
"public.promotion_connection_project" }o--|| "public.promotion_connection" : "FOREIGN KEY (#quot;connectionId#quot;) REFERENCES promotion_connection(id) ON DELETE CASCADE"
"public.promotion_review" }o--o| "public.promotion_connection" : "FOREIGN KEY (#quot;connectionId#quot;) REFERENCES promotion_connection(id) ON DELETE SET NULL"
"public.promotion_connection" }o--|| "public.promotion_provider" : "FOREIGN KEY (#quot;providerId#quot;) REFERENCES promotion_provider(id) ON DELETE RESTRICT"

"public.promotion_connection" {
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  varchar_128_ name
  varchar_36_ providerId FK
  varchar_16_ scope
  json target
  timestamp_3__with_time_zone updatedAt
}
"public.promotion_config" {
  varchar_36_ connectionId FK
  timestamp_3__with_time_zone createdAt
  varchar_16_ direction
  varchar_36_ id
  varchar_128_ name
  json settings
  timestamp_3__with_time_zone updatedAt
}
"public.promotion_connection_project" {
  varchar_36_ connectionId FK
  timestamp_3__with_time_zone createdAt
  varchar_36_ projectId FK
  timestamp_3__with_time_zone updatedAt
}
"public.promotion_review" {
  timestamp_3__with_time_zone approvedAt
  uuid approvedById FK
  varchar_36_ connectionId FK
  timestamp_3__with_time_zone createdAt
  uuid createdById FK
  uuid id
  timestamp_3__with_time_zone lastStateChangeAt
  varchar_255_ remoteReviewId
  varchar_32_ state
  varchar_16_ type
}
"public.promotion_provider" {
  text auth
  varchar_32_ authType
  json config
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  varchar_128_ name
  varchar_32_ type
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls