Certificates Schema

ext_certificates - Certificates

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

---

templates

Certificate design templates with HTML/CSS content.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
instructor_id	uuid	NO	—
course_id	uuid	YES	—
title	text	NO	—
description	text	YES	—
body_html	text	YES	''
css	text	YES	—
background_image	text	YES	—
orientation	text	NO	'landscape'
variables	jsonb	NO	'[]'
status	text	NO	'active'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

issued_certificates

Certificates issued to users.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
template_id	uuid	NO	—
user_id	uuid	NO	—
course_id	uuid	YES	—
instructor_id	uuid	NO	—
certificate_code	text	NO	—
code	text	YES	—
data	jsonb	NO	'{}'
variable_data	jsonb	NO	'{}'
status	text	NO	'active'
issued_at	timestamptz	NO	now()
expires_at	timestamptz	YES	—
revoked_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()