Add secrets table and related procedures #63

New issue

Closed

opened 2026-03-17 18:43:15 +00:00 by charlie · 0 comments

charlie commented

2026-03-17 18:43:15 +00:00

Owner

secrets table

Diagram

Purpose

Store the JWT minting key

Default values

issueancetime -> current_timestamp

insert_secret

Purpose

Insert a new key into the table

Input parameters

secret varchar(255)

get_secret

Purpose

Fetch the key that was added last

Requirement

The procedure should only have one key in the output cursor

# secrets table ## Diagram ![image](/attachments/65a7bb74-11fd-4c09-b7d9-f1c5e7dba82a) ## Purpose Store the JWT minting key ## Default values issueancetime -> current_timestamp # insert_secret ## Purpose Insert a new key into the table ## Input parameters secret varchar(255) # get_secret ## Purpose Fetch the key that was added last ## Requirement The procedure should only have one key in the output cursor

image.png

22 KiB