The trap records table has some of the trap attributes added which are very useful to flatten the trap-to-records relation. But one key item is missing - retired. This makes it difficult to filter records on current traps.
Similarly the Traps table has the project name (user editiable) but not the project ID. The trap_records does have the project ID.
What are the chances of adding extra fields?