exam_questions

Questions inside an exam.

• ETL strategy: merge
• PK: id

Columns

Column	Type	Description
id	BIGINT	PK.
id_tenant	BIGINT	FK → tenants.id.
id_origin	BIGINT	Parent question id when replicated.
id_exam	BIGINT	FK → exams.id.
question	TEXT	Question text.
format	TEXT	Question type. Enum — see below.
image	TEXT	Optional image URL.
answers	JSONB	Choices and answer key.
created_at	TIMESTAMPTZ
deleted_at	TIMESTAMPTZ

Enum · format

Value	Meaning
multiple_choice	Multiple choice.
(others)	Other formats preserved unchanged. Empty strings become NULL.

Relationships

• Parent: tenants, exams.