KEPSIpowerData

Tables (3)

PowerDataRequestParameters (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → PowerDataResponseResult.Key — NOT NULL
  • Key (Key22) — Foreign key → PowerDataResponseResult.Key — NOT NULL
  • Key (Key3) — Foreign key → User.Key — NOT NULL
  • year (Field) — String
  • monthCd (Field2) — String
  • cityCd (Field3) — String
  • cntrCd (Field4) — String
  • apiKey (Field5) — String
  • returnType (Field6) — String

PowerDataResponseResult (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • totData (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
  • hourlyPawerData (Field12) — LIST
  • PowerMeasurementData (Field13) — LIST
  • UniqueIdentificationNumber (Field14) — LIST

User (Untitled)

  • Key — Primary key — NOT NULL
  • UserName (Field2) — String
  • Email (Field3) — String
  • PassWord (Field4) — String
  • PhoneNumber (Field5) — String
  • Address (Field6) — String
  • CreateAt (Field7) — String
  • UpdateAt (Field8) — String
  • UserID (Field9) — String