certificate_template

-1 rows


Description

Module: Learning Management
Purpose: Used to store certificate templates for generating course completion certificates.
Data: One row is created for each unique certificate template design.
Process Usage:
- Utilized by the system to generate certificates dynamically based on stored HTML templates.
- The active template (currently “Template 1”) is fetched by name during certificate generation.
Key Points:
- Stores HTML content with placeholders for dynamic data such as learner name, course title, and completion date.
- Supports scalability for multiple certificate designs in the future.
Business Impact: Enables automated, consistent, and branded certificate generation across the Learning Management module.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('certificate_template_id_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for each certificate template.

name varchar 255 null

Template name
Format: VARCHAR(255)
Meaning: Identifies the certificate template by name (e.g., “Template 1”).
Usage: Used by the system to fetch and apply the correct template during certificate generation.

html_content text 2147483647 null

HTML structure of the certificate template.
Format: TEXT
Meaning: Contains the complete HTML layout with dynamic parameters (e.g., {{learnerName}}, {{courseName}}, {{date}}).
Usage: Rendered at runtime to produce the final certificate document.

description text 2147483647 null

Optional description for the certificate template.
Format: TEXT
Status: Currently unused.
Potential Use: Can be used to document template purpose, version, or notes in the future.

is_active bool 1 true

Template activation flag
Format: BOOLEAN (default: true)
Meaning: Indicates whether the certificate template is active and available for use.
Usage: Only active templates are considered during certificate generation.

Indexes

Constraint Name Type Sort Column(s)
certificate_template_pkey Primary key Asc id

Relationships