mdl_projectfeedback_editpdf_cmnt

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
gradeid	bigint	Not null	'0'	Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
x	bigint	Nullable	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
y	bigint	Nullable	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
width	bigint	Nullable	'120'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
rawtext	longtext	Nullable		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
pageno	bigint	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
colour	varchar(10)	Nullable	'black'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
draft	tinyint	Not null	'1'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference