Database Schema

[miguel-merlin]

Description of Problem

The size and direction of the sector lobes of the antennas need to be stored in a database so that it persists. The following database schema is proposed.

Table 1: Antennas

TABLE Antennas (
  id VARCHAR(255),
  name VARCHAR(255),
  hostname VARCHAR(255),
  model VARCHAR(255),
  modelName VARCHAR(255),
  frequency INT,
  location VARCHAR(255),
  heading INT,
  sectorLobe VARCHAR(255),
  FOREIGN KEY (sectorLobe) REFERENCES SectorLobes(sector_lobe_id)
);

Table 2: Sector Lobes

TABLE SectorLobes (
  sector_lobe_id VARCHAR(255),
  modelName VARCHAR(255),
  angle FLOAT,
  radius FLOAT,
  PRIMARY KEY (sector_lobe_id)
);