Goal
Extend the spqueryfield table with a Term column to store the DwC IRI or term name associated with an output field. Include stub columns for V2 static value support (#7720).
Background
Term-to-field associations must be stored at the field level so each output column has its own concept mapping. The Term column is the primary V1 addition; IsStatic and StaticValue are deferred to V2.
Schema Addition
| Field |
Type |
Notes |
| Term |
VarChar (nullable) |
IRI or term name; null = unmapped |
| IsStatic |
Boolean (V2) |
Default false |
| StaticValue |
Text (V2) |
Nullable |
Acceptance Criteria
Goal
Extend the
spqueryfieldtable with aTermcolumn to store the DwC IRI or term name associated with an output field. Include stub columns for V2 static value support (#7720).Background
Term-to-field associations must be stored at the field level so each output column has its own concept mapping. The
Termcolumn is the primary V1 addition;IsStaticandStaticValueare deferred to V2.Schema Addition
Acceptance Criteria
Termcolumn added tospqueryfieldin a migration (nullable, default null).spqueryfieldrows are unaffected (nullTerm= standard query field, no mapping).Termfield.IsStaticandStaticValuecolumns added as nullable stubs (no UI wired for V2 yet).Termfromspqueryfieldto set CSV column headers.