Skip to main content

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

Status group​

No, this table does not include a statusgroup column.

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