Does Target record need ManyToMany Project (Proposal) references?
Opened this issue · 0 comments
alanbchristie commented
Work on #1485 exposed the fact that the current Target table has a project_id column, a ManyToMany relationship. The question is ... Can a Target record legitimately refer to more than one Project (Proposal)? If not the project_id record can be replaced by a simpler relationship.
Interestingly...
The existing (legacy) Production stack does have 16 Targets that have two Project relationships: -
FIH 2
GLUK1 2
NS3HEL 2
PGN_RS02895PGA 2
EBNA_A2 2
ADARB1A 2
Nprot 2
CD73 2
SERC 2
TCRUFPPS 2
UP1 2
GLUA2 2
HPRP 2
OXA10 2
PBP5 2
TIF6 2