← All tables
mdl_projectbase
INVESTIGATEPlugin / custom business / integration data · 27 columnsProposed 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
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 | |
| title | varchar(255) | Not null | '' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| team_size | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| type | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| certificate | tinyint(1) | Not null | '0' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| problem_statement | longtext | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| summary | longtext | Nullable | Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references. | Schema-only inference | |
| synopsis | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| guide | tinyint(1) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| assessment | tinyint(1) | Not null | '0' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| startdate | bigint | Nullable | Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics. | Schema-only inference | |
| enddate | bigint | Nullable | Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics. | Schema-only inference | |
| skills | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| nda | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| 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 | |
| status | tinyint(1) | Not null | '0' | Map through explicit enum/boolean translation; retain source value and test edge cases. | High: verify semantics/relationship/security |
| usermodified | 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 | |
| timemodified | bigint | Nullable | Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics. | Schema-only inference | |
| deleted | tinyint(1) | Nullable | '0' | Map through explicit enum/boolean translation; retain source value and test edge cases. | Schema-only inference |
| currency_type | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| price | varchar(150) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| tax_applicable | tinyint(1) | Nullable | '0' | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |
| taxes | varchar(255) | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| enrollment_from_date | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference | |
| companyid | 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 |
| teamnumber | bigint | Nullable | Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning. | Schema-only inference |