mdl_university_master

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	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
name	longtext	Not null	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
address	longtext	Not null	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
state	bigint	Nullable	Map through explicit enum/boolean translation; retain source value and test edge cases.	High: verify semantics/relationship/security
city	bigint	Nullable	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
country	bigint	Nullable	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
district	bigint	Nullable	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
pincode	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