← All tables
mdl_itrackpayment_ccavenue_transaction
INVESTIGATEUnclassified Moodle core/plugin table · 32 columnsProposed 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.
| 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 | |
| paymentid | bigint | Nullable | Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs. | High: verify semantics/relationship/security | |
| paymentccavenueid | 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 | |
| orderid | varchar(255) | Not null | '' | Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs. | High: verify semantics/relationship/security |
| producttype | varchar(100) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| currency | varchar(5) | Not null | '' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| amount | decimal(10,2) | Not null | '0.00' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| language | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| billingaddressid | 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 | |
| deliveryaddressid | 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 | |
| merchantparam1 | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| merchantparam2 | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| merchantparam3 | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| merchantparam4 | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| merchantparam5 | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| transactionstartedat | bigint | Not null | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| splitjsondata | longtext | Nullable | Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references. | High: verify semantics/relationship/security | |
| processed | tinyint(1) | Not null | '0' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| transactionfinishedat | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| trackingid | bigint | Nullable | Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs. | High: verify semantics/relationship/security | |
| bankrefnumber | varchar(50) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| orderstatus | varchar(100) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| failuremessage | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| paymentmode | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| statuscode | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| statusmessage | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| offertype | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| offercode | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| discountvalue | decimal(15,2) | Nullable | '0.00' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| meramount | decimal(15,2) | Nullable | '0.00' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| billingnotes | longtext | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| invoicenumber | varchar(100) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |