mdl_competency_usercompplan

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	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
competencyid	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
planid	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
proficiency	tinyint	Nullable	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
grade	bigint	Nullable	Map through explicit enum/boolean translation; retain source value and test edge cases.	High: verify semantics/relationship/security
sortorder	bigint	Nullable	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
timecreated	bigint	Not null	Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference
timemodified	bigint	Nullable	Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference
usermodified	bigint	Not null	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference