Page 1 of 1

LMS database & relationship between tables

Posted: Fri Jun 09, 2017 12:13 pm
by w9wi
Has anyone been messing with the new LMS database?

I'm having trouble figuring out a relationship path between the facility table and the various application tables. Facility seems to have the same purpose as in CDBS -- non-technical information like call letters & principal community. The technical data seems to be spread among the various application_ tables. I can find keys relating the application_ tables to each other, but I'm not finding a path to facility.

I've not been able to blow up the entity relationship diagram to anything large enough to read. (it loses too much resolution)