NOWATT

Tables (6)

Location (location)

  • Location Id (location_id) — INTEGER — Primary key — NOT NULL
  • Longtitude (longtitude) — FLOAT
  • Latitude (latitude) — FLOAT

RevokedToken (revoked_token)

  • RevokedToken Id (revoked_token_id) — LONG — Primary key — NOT NULL
  • Token (token) — TEXT

Schedule (schedule)

  • Schdule Id (schedule_id) — INTEGER — Primary key — NOT NULL
  • User Id (user_id) — INTEGER — Foreign key → User.User Id — NOT NULL
  • Weekday (weekday) — SMALLINT

SolarSetup (solar_setup)

  • Solar Setup Id (solar_setup_id) — INTEGER — Primary key — NOT NULL
  • Location Id (location_id) — INTEGER — Foreign key → Location.Location Id — NOT NULL
  • Panel Count (panel_count) — SMALLINT
  • Panel Type (panel_type) — SMALLINT
  • Panel Area (panel_area) — FLOAT
  • Tilt (tilt) — FLOAT
  • Azimuth (azimuth) — FLOAT
  • Peak Power (peak_power) — FLOAT

Time (time)

  • Time Id (time_id) — INTEGER — Primary key — NOT NULL
  • Schedule Id (schedule_id) — INTEGER — Foreign key → Schedule.Schdule Id — NOT NULL
  • Start Time (start_time) — TIME
  • End Time (end_time) — TIME

User (user)

  • User Id (user_id) — INTEGER — Primary key — NOT NULL
  • Location Id (location_id) — INTEGER — Foreign key → Location.Location Id — NOT NULL
  • First Name (first_name) — VARCHAR(20)
  • Email (email) — VARCHAR(255)
  • Password (password) — VARCHAR(255)