search

m2ms / fragalysis-frontend

The React, Redux frontend built by webpack
Other
1 stars 1 forks source link

Does Target record need ManyToMany Project (Proposal) references? #1488

Open alanbchristie opened 1 month ago

alanbchristie commented 1 month ago

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