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)