Frequency Tracker

From CTWUG Wiki
Jump to: navigation, search

Frequency Tracker – Phase 1

CTWUG requires a web-based application for keeping track of frequencies used on the wireless interfaces of all the highsites.

Users should only have access to highsites assigned to them. Users should be able to access the frequency tracker from both the wug and the internet.

Requirements

  • Web-Based.
  • Database driven.
  • Login per user
  • Accessible via CTWUG and Internet.
  • Hosted on Linux machine. (Apache)

Forms

  • Highsite (add, update and delete)
  • Interface (add, update and delete)
  • User (add, update and delete)
  • Frequency (add, update, delete) (might be static)
  • Country (add, update, delete) (might be static)

Reports

  • Availability of frequencies.
  • Overlapping frequencies used.
  • Neighboring frequencies used.

Database Design

Possible Database Design (very basic).

Freqtrac.png