LMS database & relationship between tables

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

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