mdl_course_request

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
fullname	varchar(254)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
shortname	varchar(100)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
summary	longtext	Not null		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
summaryformat	tinyint	Not null	'0'	Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
category	bigint	Not null	'0'	Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	Schema-only inference
reason	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
requester	bigint	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
password	varchar(50)	Not null	''	EXCLUDE from app migration; credential/secret handling requires security review.	High: verify semantics/relationship/security