epic: pristine vendor-neutral internal data model (MVP)

[pskillen]

Epic

Get the internal codeplug model to a pristine, format- and radio-agnostic state ahead of the MVP import → modify → export → write-to-radio loop, without regressing the OpenGD77/Baofeng 1701 round-trip. Radio-specific wire mapping is the adapter's job; the internal model owes nothing to any vendor. This is the umbrella for the data-model refactor that pays down OpenGD77 leakage so adding a second radio/format later is cheap.

Planning input / findings: docs/features/data-model/vendor-agnostic-review.md

Definition of done

• Every internal foreign key is an internal UUID (no name-based FKs).
• Every channel scalar is correctly typed (bool / number / enum), not an opaque OpenGD77 wire string.
• Import provenance ("what we imported originally / most recently") lives in a per-entity meta field, not in load-bearing model fields.
• Channel.number is gone from the model and assigned at OpenGD77 export.
• vendorExtras renamed to opengd77Extras; vendor specifics live only at the adapter.
• OpenGD77/1701 import → edit → export → re-import round-trip stays green throughout.

In-scope tickets

• docs/chore: audit OpenGD77/1701 import-export implementation against reference docs #91 — audit OpenGD77/1701 import-export vs reference docs (review doc + this plan are the deliverable)
• refactor: drop channel number from internal model (assign at export) #53 — drop Channel.number, assign at export
• refactor: rationalise channel data model field types and vendor mappings #52 — rationalise channel field types and vendor mappings
• feat: first-class callsign, display name, and export name composition #54 — first-class callsign / display name / description / note + export-name composition

Also folded in under this epic (no separate child tickets): convert FKs to UUID (discriminated { kind: 'talkGroup' | 'contact'; id } refs), and move import provenance into per-entity meta + rename vendorExtras → opengd77Extras.

Locked decisions

• Delivered as a phased epic across separate agent sessions; each phase is its own subplan + branch + PR, merged to main sequentially.
• Dual-kind FK = discriminated ref { kind: 'talkGroup' | 'contact'; id }; TalkGroup and Contact stay separate entities.
• scanSkip first-class; zoneSkip stays an OpenGD77 extra.
• Field types: frequencies as integer Hz; power / squelch as percent with null = master; tones as a CTCSS/DCS string enum; colourCode / timeslot / dmrId / transmitTimeout nullable numbers/enums; rxOnly boolean.
• aprsConfigName stays a string FK until APRS is modelled.
• Vendor cardinality/limits belong at export only — never in model / mutations / validation / CRUD UI.

Phases

0. Audit close-out + scaffold (docs/chore: audit OpenGD77/1701 import-export implementation against reference docs #91): land review doc, create the OpenGD77 export-issues tracker, fix the stale persistence schema-version doc.
1. Drop Channel.number (refactor: drop channel number from internal model (assign at export) #53).
2. Typed channel fields + shared test builders (refactor: rationalise channel data model field types and vendor mappings #52).
3. Import provenance → per-entity meta + opengd77Extras rename.
4. FKs by UUID (discriminated refs).
5. First-class naming + export-name composition (feat: first-class callsign, display name, and export name composition #54).

Each phase bumps CODEPLUG_SCHEMA_VERSION with a migration + fixture.

Tracking docs

• Progress / handoff: docs/features/data-model/pristine-model-refactor-progress.md
• Outstanding: docs/features/data-model/pristine-model-refactor-outstanding.md

Related / out of scope

• feat(export): OpenGD77 radio profile selection at export time #72 — OpenGD77 radio-variant picker at export (related; not done here).
• Second-format adapters (DM32, qDMR, CHIRP) — model made ready, not implemented.
• APRS/DTMF entity modelling.

[pskillen]

Phase 3 (import provenance meta + opengd77Extras rename) PR: #99

Schema v6; EntityMeta.imported with memberWireNames; accessors in src/lib/entityProvenance.ts.