-
Notifications
You must be signed in to change notification settings - Fork 40
Open
Description
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
-
Termcolumn added tospqueryfieldin a migration (nullable, default null). - Existing
spqueryfieldrows are unaffected (nullTerm= standard query field, no mapping). - ORM model updated to expose the
Termfield. -
IsStaticandStaticValuecolumns added as nullable stubs (no UI wired for V2 yet). - All export generation code reads
Termfromspqueryfieldto set CSV column headers.
Reactions are currently unavailable