public.deployment_key

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
algorithm	varchar(20)		true
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
id	varchar(36)		false
status	varchar(20)		false
type	varchar(64)		false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
value	text		false

Constraints

Name	Type	Definition
PK_94bb7aeb5def5a0284a5fe9f9a0	PRIMARY KEY	PRIMARY KEY (id)
deployment_key_createdAt_not_null	n	NOT NULL "createdAt"
deployment_key_id_not_null	n	NOT NULL id
deployment_key_status_not_null	n	NOT NULL status
deployment_key_type_not_null	n	NOT NULL type
deployment_key_updatedAt_not_null	n	NOT NULL "updatedAt"
deployment_key_value_not_null	n	NOT NULL value

Indexes

Name	Definition
IDX_deployment_key_data_encryption_active	CREATE UNIQUE INDEX "IDX_deployment_key_data_encryption_active" ON public.deployment_key USING btree (type) WHERE (((status)::text = 'active'::text) AND ((type)::text = 'data_encryption'::text))
IDX_deployment_key_instance_id_active	CREATE UNIQUE INDEX "IDX_deployment_key_instance_id_active" ON public.deployment_key USING btree (type) WHERE (((status)::text = 'active'::text) AND ((type)::text = 'instance.id'::text))
IDX_deployment_key_jwe_private_key_active	CREATE UNIQUE INDEX "IDX_deployment_key_jwe_private_key_active" ON public.deployment_key USING btree (type, algorithm) WHERE (((status)::text = 'active'::text) AND ((type)::text = 'jwe.private-key'::text))
IDX_deployment_key_oauth_signing_key_active	CREATE UNIQUE INDEX "IDX_deployment_key_oauth_signing_key_active" ON public.deployment_key USING btree (type, algorithm) WHERE (((status)::text = 'active'::text) AND ((type)::text = 'oauth-server.signing-key'::text))
IDX_deployment_key_signing_binary_data_active	CREATE UNIQUE INDEX "IDX_deployment_key_signing_binary_data_active" ON public.deployment_key USING btree (type) WHERE (((status)::text = 'active'::text) AND ((type)::text = 'signing.binary_data'::text))
IDX_deployment_key_signing_hmac_active	CREATE UNIQUE INDEX "IDX_deployment_key_signing_hmac_active" ON public.deployment_key USING btree (type) WHERE (((status)::text = 'active'::text) AND ((type)::text = 'signing.hmac'::text))
IDX_deployment_key_signing_jwt_active	CREATE UNIQUE INDEX "IDX_deployment_key_signing_jwt_active" ON public.deployment_key USING btree (type) WHERE (((status)::text = 'active'::text) AND ((type)::text = 'signing.jwt'::text))
PK_94bb7aeb5def5a0284a5fe9f9a0	CREATE UNIQUE INDEX "PK_94bb7aeb5def5a0284a5fe9f9a0" ON public.deployment_key USING btree (id)

Triggers

Name	Definition
prevent_deployment_key_delete	CREATE TRIGGER prevent_deployment_key_delete BEFORE DELETE ON public.deployment_key FOR EACH STATEMENT EXECUTE FUNCTION prevent_deployment_key_delete()
prevent_deployment_key_truncate	CREATE TRIGGER prevent_deployment_key_truncate BEFORE TRUNCATE ON public.deployment_key FOR EACH STATEMENT EXECUTE FUNCTION prevent_deployment_key_delete()

Relations

erDiagram


"public.deployment_key" {
  varchar_20_ algorithm
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  varchar_20_ status
  varchar_64_ type
  timestamp_3__with_time_zone updatedAt
  text value
}

---

Generated by tbls