mdl_logstore_standard_log

ARCHIVEMoodle standard event log · 21 columns

Proposed target

Compressed object storage archive (partitioned by date/table; JSONL or Parquet)

Migration rule

Do not load millions of log rows into primary application DB by default

Verification required

Confirm statutory retention, data minimization, security access and whether analytics requires queryable archive.

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
eventname	varchar(255)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
component	varchar(100)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
action	varchar(100)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
target	varchar(100)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
objecttable	varchar(50)	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
objectid	bigint	Nullable		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
crud	varchar(1)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
edulevel	tinyint(1)	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
contextid	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
contextlevel	bigint	Not null		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
contextinstanceid	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
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
courseid	bigint	Nullable		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
relateduserid	bigint	Nullable		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
anonymous	tinyint(1)	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
other	longtext	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
origin	varchar(10)	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
ip	varchar(45)	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
realuserid	bigint	Nullable		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security