Evaluate data model

amigan commented

2024-11-10 15:57:01 -05:00

Owner

Maybe p25 talkgroups should have a layer of indirection (kind of like sdrtrunk aliases) and not use the P25 IDs as their record IDs.

amigan added the

Kind/Enhancement

label 2024-11-10 15:57:27 -05:00

amigan commented

2024-11-10 15:58:28 -05:00

Author

Owner

Thinking:

talkgroups table as now (without tgid and sys, just using uuid or serial as PK)
mapping table of p25 sys:tg to talkgroups many-to-one

Thinking: * talkgroups table as now (without tgid and sys, just using uuid or serial as PK) * mapping table of p25 sys:tg to talkgroups many-to-one

amigan commented

2024-11-16 18:50:31 -05:00

Author

Owner

This is half-done as of #25. Still need to figure out foreign key constraints that can map either to learned or actual talkgroups.

amigan commented

2024-11-17 15:11:25 -05:00

Author

Owner

To do in callsnormalize branch:

Change monster UNION learned queries to do JOIN with learned table.
Change to repository pattern

To do in callsnormalize branch: - [x] Change monster `UNION` learned queries to do `JOIN` with learned table. - [ ] Change to repository pattern

amigan commented

2024-11-19 10:16:35 -05:00

Author

Owner

All that is left:

Repository pattern
Add ways to learn talkgroups (move out of learned, update talkgroups table with all fields and learned = false)

All that is left: - [ ] Repository pattern - [ ] Add ways to learn talkgroups (move out of learned, update talkgroups table with all fields and learned = false)

amigan referenced this issue

2024-11-19 10:16:57 -05:00

callsnormalize #40

amigan commented

2024-11-20 09:41:30 -05:00

Author

Owner

Collapse learned and talkgroups tables, add talkgroups versions table, simplify queries

amigan closed this issue

2024-11-25 16:38:04 -05:00

Evaluate data model #31