Table

certificatefieldsblocks

Each row represents a field definition configured in a certificate-field block, including label, type, slug, and display settings.

Redshift

All tables

certificatefieldsblocks

Each row represents a field definition configured in a certificate-field block, including label, type, slug, and display settings.

Full schema

View all columns and table relationships (SchemaSpy)

Status group

No, this table does not include a statusgroup column.

Column details

Column	Type
`companyid`	varchar(36)
`id`	varchar(36)
`shortid`	varchar(36)
`customfieldslug`	varchar(65535)
`includeonexternalcertificate`	bool
`includeontranscript`	bool
`label`	varchar(65535)
`type`	varchar(65535)

Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.

Sample query

select
  t.shortid,
  t.customfieldslug,
  t.includeonexternalcertificate,
  t.includeontranscript,
  t.label
from certificatefieldsblocks as t
limit 100

Joining fields to the certificate template labels that use them

Certificate fields define the data that can appear on a certificate (learner name, course title, issue date, identifier, etc.). Each certificatetemplatelabels row places one of these fields at a specific position on a template. Join via certificatefieldid:

select
  cfb.label as field_label,
  cfb.type as field_type,
  ctl.certificatetemplateid,
  ctl.x,
  ctl.y,
  ctl.fontsize,
  ctl.textalign
from certificatefieldsblocks as cfb
  left join certificatetemplatelabels as ctl on ctl.certificatefieldid = cfb.id
limit 100