Skip to content

Certificates Schema

Schema: ext_certificates | Auto-generated on 2026-03-30


Certificate design templates with HTML/CSS content.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
instructor_iduuidNO—
course_iduuidYES—
titletextNO—
descriptiontextYES—
body_htmltextYES''
csstextYES—
background_imagetextYES—
orientationtextNO'landscape'
variablesjsonbNO'[]'
statustextNO'active'
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Certificates issued to users.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
template_iduuidNO—
user_iduuidNO—
course_iduuidYES—
instructor_iduuidNO—
certificate_codetextNO—
codetextYES—
datajsonbNO'{}'
variable_datajsonbNO'{}'
statustextNO'active'
issued_attimestamptzNOnow()
expires_attimestamptzYES—
revoked_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()