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.
| 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. |
| Name | Type | Definition |
|---|---|---|
| certificate_fonts_created_at_not_null | n | NOT NULL created_at |
| certificate_fonts_display_name_not_null | n | NOT NULL display_name |
| certificate_fonts_file_path_not_null | n | NOT NULL file_path |
| certificate_fonts_file_upload_id_fkey | FOREIGN KEY | FOREIGN KEY (file_upload_id) REFERENCES file_uploads(id) |
| certificate_fonts_file_upload_id_not_null | n | NOT NULL file_upload_id |
| certificate_fonts_id_not_null | n | NOT NULL id |
| certificate_fonts_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| certificate_fonts_updated_at_not_null | n | NOT NULL updated_at |
| Name | Definition |
|---|---|
| certificate_fonts_pkey | CREATE UNIQUE INDEX certificate_fonts_pkey ON public.certificate_fonts USING btree (id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.certificate_fonts FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls