Skip to content

public.promotion_environment_project

Columns

Name Type Default Nullable Children Parents Comment
createdAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false
direction varchar(16) false PromotionDirection enum: "apply", "promote". The direction of the environment.
environmentId uuid false public.promotion_environment
projectId varchar(36) false public.project
updatedAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false

Constraints

Name Type Definition
CHK_promotion_environment_project_direction CHECK CHECK (((direction)::text = ANY ((ARRAY['apply'::character varying, 'promote'::character varying])::text[])))
FK_promotion_environment_project_environmentId FOREIGN KEY FOREIGN KEY ("environmentId") REFERENCES promotion_environment(id) ON DELETE CASCADE
FK_promotion_environment_project_projectId FOREIGN KEY FOREIGN KEY ("projectId") REFERENCES project(id) ON DELETE CASCADE
PK_b24efcd0701a03db59013dbafc8 PRIMARY KEY PRIMARY KEY ("projectId", direction)
promotion_environment_project_createdAt_not_null n NOT NULL "createdAt"
promotion_environment_project_direction_not_null n NOT NULL direction
promotion_environment_project_environmentId_not_null n NOT NULL "environmentId"
promotion_environment_project_projectId_not_null n NOT NULL "projectId"
promotion_environment_project_updatedAt_not_null n NOT NULL "updatedAt"

Indexes

Name Definition
IDX_7e9db6a9fc5e58a6ed613387aa CREATE INDEX "IDX_7e9db6a9fc5e58a6ed613387aa" ON public.promotion_environment_project USING btree ("environmentId")
PK_b24efcd0701a03db59013dbafc8 CREATE UNIQUE INDEX "PK_b24efcd0701a03db59013dbafc8" ON public.promotion_environment_project USING btree ("projectId", direction)

Relations

erDiagram

"public.promotion_environment_project" }o--|| "public.promotion_environment" : "FOREIGN KEY (#quot;environmentId#quot;) REFERENCES promotion_environment(id) ON DELETE CASCADE"
"public.promotion_environment_project" }o--|| "public.project" : "FOREIGN KEY (#quot;projectId#quot;) REFERENCES project(id) ON DELETE CASCADE"

"public.promotion_environment_project" {
  timestamp_3__with_time_zone createdAt
  varchar_16_ direction
  uuid environmentId FK
  varchar_36_ projectId FK
  timestamp_3__with_time_zone updatedAt
}
"public.promotion_environment" {
  timestamp_3__with_time_zone createdAt
  varchar_16_ direction
  uuid id
  varchar_128_ name
  varchar_36_ providerId FK
  json remote
  varchar_16_ scope
  json settings
  timestamp_3__with_time_zone updatedAt
}
"public.project" {
  timestamp_3__with_time_zone createdAt
  uuid creatorId FK
  json customTelemetryTags
  varchar_512_ description
  json icon
  varchar_36_ id
  varchar_255_ name
  varchar_36_ type
  timestamp_3__with_time_zone updatedAt
}

Generated by tbls