KEPSIpowerData

Tables (5)

MonthlyData (Untitled4)

  • UserID (Foreign key) — String — Foreign key → User.UserID — NOT NULL
  • year (Field) — String
  • Month (Field2) — String
  • TotalUsage (Field3) — Number
  • TotalCost (Field4) — Number

PowerData (Untitled5)

  • UserID (Foreign key) — String — Foreign key → User.UserID — NOT NULL
  • Data (Field) — Number
  • Hour (Field2) — Number
  • Usage (Field3) — Number
  • Cost (Field4) — Number

PowerDataRequestParameter (Untitled2)

  • year (Field) — String
  • monthCd (Field2) — String
  • cityCd (Field3) — String
  • apiKey (Field4) — String
  • returnType (Field5) — String

PowerDataResponse (Untitled3)

  • toData (Field) — LIST
  • Data (Field2) — LIST
  • year (Field3) — String
  • month (Field4) — String
  • city (Field5) — String
  • cntr (Field6) — String
  • custCnt (Field7) — Number
  • powerUsage (Field8) — Number
  • bill (Field9) — Number
  • unitCost (Field10) — Number
  • metro (Field11) — String
  • PowerMeasurementData (Field13) — LIST
  • UniqueldentificationNumber (Field14) — LIST

User (Untitled)

  • UserID (primary key) — String — Primary key — NOT NULL
  • UserName (Field) — String
  • Email (Field2) — String
  • Password (Field3) — String
  • Address (Field4) — String
  • createdAt (Field5) — String
  • UpdatedAt (Field6) — String