← All tables

mdl_feedback_item

MIGRATECore learning content / activity / progress / assessment · 13 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

Sign in to update status, owner and notes.

ColumnTypeNullDefaultTarget mappingRisk
idbigintNot nullPreserve as legacy source ID; generate target PK unless target accepts stable legacy key.High: verify semantics/relationship/security
feedbackbigintNot null'0'Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.Schema-only inference
templatebigintNot null'0'Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
namevarchar(255)Not null''Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
labelvarchar(255)Not null''Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
presentationlongtextNot nullMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
typvarchar(255)Not null''Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
hasvaluetinyint(1)Not null'0'Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
positionsmallintNot null'0'Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
requiredtinyint(1)Not null'0'Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
dependitembigintNot null'0'Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
dependvaluevarchar(255)Not null''Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
optionsvarchar(255)Not null''Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference