public.jwt_keys

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
key_id	varchar(64)		false
key_type	varchar(50)		false
private_key_encrypted	text		false
public_key_pem	text		false
is_active	boolean		false
created_at	timestamp with time zone		false
rotated_at	timestamp with time zone		true

Viewpoints

Name	Definition
Authentication & Sessions	User authentication, MFA, sessions, and audit logs

Constraints

Name	Type	Definition
jwt_keys_pkey	PRIMARY KEY	PRIMARY KEY (key_id)

Indexes

Name	Definition
jwt_keys_pkey	CREATE UNIQUE INDEX jwt_keys_pkey ON public.jwt_keys USING btree (key_id)
ix_jwt_keys_is_active	CREATE INDEX ix_jwt_keys_is_active ON public.jwt_keys USING btree (is_active)
ix_jwt_keys_key_type	CREATE INDEX ix_jwt_keys_key_type ON public.jwt_keys USING btree (key_type)

Relations

---

Generated by tbls