LMS database & relationship between tables

Discuss FCC rules, regulations, news, and information!
Post Reply
Posts: 857
Joined: Tue Feb 05, 2008 11:40 am
Location: Pleasant View, Tennessee

LMS database & relationship between tables

Post by w9wi » Fri Jun 09, 2017 12:13 pm

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)
Doug Smith W9WI
Pleasant View, TN EM66

Post Reply