public.certificate_fonts

Description

When renderding certificates, we will load all the fonts from this table to be available during rendering. Fonts that are not in this table will not be rendered.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
created_at	timestamp with time zone	now()	false			Timestamp when the record was created.
deleted_at	timestamp with time zone		true			Timestamp when the record was deleted. If null, the record is not deleted.
display_name	text		false			A name so that we can remember which record is for which font. Does not affect the font name used in the rendering – that comes from the font file itself.
file_path	text		false			Path to the uploaded font file. The same path can be found though file_upload_id -> path. This field is copied here so that we can avoid a join. The file_uploads table is expected to grow very large.
file_upload_id	uuid		false		public.file_uploads	The record for the uploaded font file.
id	uuid	uuid_generate_v4()	false			A unique, stable identifier for the record.
updated_at	timestamp with time zone	now()	false			Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger.

Constraints

Name	Type	Definition
certificate_fonts_file_upload_id_fkey	FOREIGN KEY	FOREIGN KEY (file_upload_id) REFERENCES file_uploads(id)
certificate_fonts_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
certificate_fonts_pkey	CREATE UNIQUE INDEX certificate_fonts_pkey ON public.certificate_fonts USING btree (id)

Triggers

Name	Definition
set_timestamp	CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.certificate_fonts FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp()

Relations

er

Generated by tbls