public.jwt_keys

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
key_id	varchar(64)		false			Key identifier used as 'kid' in JWT header.
key_type	varchar(50)		false			Key type: HUMAN or DEVICE.
private_key_encrypted	text		false			Encrypted EC P-256 private key (PEM).
public_key_pem	text		false			EC P-256 public key (PEM).
is_active	boolean		false			Key active status. Inactive keys cannot sign new tokens.
created_at	timestamp with time zone		false			Key creation timestamp.
rotated_at	timestamp with time zone		true			Key rotation timestamp.

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