mdl_attendance_log

ARCHIVELogs / analytics / technical history · 9 columns

Proposed target

Archive compressed; selectively transform required reporting aggregates

Migration rule

Usually not required for core LMS runtime

Verification required

Identify compliance/audit and analytics use cases before exclusion

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
sessionid	bigint	Not null	'0'	Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
studentid	bigint	Not null	'0'	Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
statusid	bigint	Not null	'0'	Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
statusset	varchar(1333)	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
timetaken	bigint	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
takenby	bigint	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
remarks	varchar(1333)	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
ipaddress	varchar(45)	Nullable	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference