certificatefields

Each row represents a name-value pair for a custom or template-driven field on an issued certificate.

Full schema

View all columns and table relationships

Status group

Yes, this table includes a statusgroup column. See Status Group for details.

Sample query

select
  t.fieldid,
  t.certificateid,
  t.fieldshortid,
  t.value
from certificatefields as t
limit 100