← All tables

mdl_ai_action_summarise_text

INVESTIGATEUnclassified Moodle core/plugin table · 8 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

Sign in to update status, owner and notes.

ColumnTypeNullDefaultTarget mappingRisk
idbigintNot nullPreserve as legacy source ID; generate target PK unless target accepts stable legacy key.High: verify semantics/relationship/security
promptlongtextNullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
responseidvarchar(128)NullableResolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.High: verify semantics/relationship/security
fingerprintvarchar(128)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
generatedcontentlongtextNullableTransform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.High: verify semantics/relationship/security
finishreasonvarchar(128)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
prompttokensbigintNullableEXCLUDE from app migration; credential/secret handling requires security review.High: verify semantics/relationship/security
completiontokenbigintNullableEXCLUDE from app migration; credential/secret handling requires security review.High: verify semantics/relationship/security