mdl_quizaccess_seb_template

MIGRATECore learning content / activity / progress / assessment · 9 columns

Proposed target

Transform into target course, module, attempt, grade, completion, credential and content models

Migration rule

Preserve history and relationships; retain original IDs in legacy_id fields

Verification required

Plugin behavior, attempt state, grading rules, file references and completion logic require application-level verification

Tracking

Column	Type	Null	Default	Target mapping	Risk
id	bigint	Not null		Preserve as legacy source ID; generate target PK unless target accepts stable legacy key.	High: verify semantics/relationship/security
name	varchar(255)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
description	longtext	Not null		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
content	longtext	Not null		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	High: verify semantics/relationship/security
enabled	tinyint(1)	Not null		Map through explicit enum/boolean translation; retain source value and test edge cases.	Schema-only inference
sortorder	bigint	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
usermodified	bigint	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
timecreated	bigint	Not null	'0'	Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference
timemodified	bigint	Not null	'0'	Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference