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