DB API: plan + idea thread

,

I believe that we should expose the whole database to the API. But it is not the API that needs to be rewritten at this point; it is the schema that we need to redesign/fix. Although we basically have only 3 models, Transmitter, Satellite and DemodData, the relationships are very messy. For instance, we have both satellite and transmitter fields in DemodData but the transmitter also has a satellite field (as FK) creating a circular relationship. The reason for this mess, is that we tried to use the same model (and even interface) to store verified, trusted data (SatNOGS Network) with unverified, incomplete data (e.g. SiDS). I think, we need to fix these issues first before extending the schema further.