mdl_tool_usertours_steps

INVESTIGATEPlugin / custom business / integration data · 9 columns

Proposed target

Map only after owner and UI/API usage review; migrate active business records, archive obsolete history

Migration rule

Target model depends on workflows, relationships, status semantics and plugin code

Verification required

Inspect plugin source, controllers, scheduled tasks, external APIs, sample data and foreign-key conventions

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
tourid	bigint	Not null		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
title	longtext	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
content	longtext	Nullable		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	High: verify semantics/relationship/security
contentformat	smallint	Not null	'0'	Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	High: verify semantics/relationship/security
targettype	tinyint	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
targetvalue	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
sortorder	bigint	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
configdata	longtext	Not null		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	High: verify semantics/relationship/security