mdl_tag

INVESTIGATEUnclassified Moodle core/plugin table · 10 columns

Proposed target

Owner decision: migrate, transform, archive or exclude

Migration rule

No safe target inferred from schema name alone

Verification required

Inspect columns, row counts, code references, reports and retention requirements

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
userid	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
tagcollid	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
name	varchar(255)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
rawname	varchar(255)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
isstandard	tinyint(1)	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
description	longtext	Nullable		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
descriptionformat	tinyint	Not null	'0'	Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
flag	smallint	Nullable	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
timemodified	bigint	Nullable		Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference