ipd

Tables (10)

Admin (Untitled)

  • adminId (Key) — Integer — Primary key — NOT NULL
  • email (Field) — STRING
  • password (Field2) — STRING
  • adminNmae (Field3) — STRING
  • phoneNumber (Field4) — STRING
  • roles (Field5) — String
  • createDate (Field6) — LocalDte

Block (Untitled2)

  • block_id (Key) — Integer — Primary key — NOT NULL
  • sewer_Id (Key2) — Integer — Foreign key → Sewer.sewer_Id — NOT NULL
  • States (Field) — STRING
  • BlockCount (Field2) — Integer
  • jan_Count (Field3) — Integer
  • feb_Count (Field4) — Integer
  • mar_Count (Field5) — Integer
  • apr_Count (Field6) — Integer
  • may_Count (Field7) — Integer
  • jun_Count (Field8) — Integer
  • july_Count (Field9) — Integer
  • aug_Count (Field10) — Integer
  • sep_Count (Field11) — Integer
  • oct_Count (Field12) — Integer
  • nov_Count (Field13) — Integer
  • dec_Count (Field14) — Integer
  • blockDate (Field15) — LocalDate
  • blockTime (Field16) — LocalTime

ChangeBlock (Untitled8)

  • id (Key) — Integer — Primary key — NOT NULL
  • block_id (Key2) — Integer — Foreign key → Block.block_id — NOT NULL
  • sewer_Id (Key22) — Integer — Foreign key → Block.sewer_Id — NOT NULL
  • value (Field) — Double
  • createDate (Field2) — LocalDate

ChangeH (Untitled9)

  • Id (Key) — Integer — Primary key — NOT NULL
  • h_Id (Key2) — Integer — Foreign key → H_Sensor.h_Id — NOT NULL
  • sewer_Id (Key22) — Integer — Foreign key → H_Sensor.sewer_Id — NOT NULL
  • value (Field) — Double
  • createDate (Field2) — LocalDateTime

ChangeSmall (Untitled7)

  • id (Key) — Integer — Primary key — NOT NULL
  • small_Id (Key2) — Integer — Foreign key → Small_Sensor.small_Id — NOT NULL
  • sewer_Id (Key22) — Integer — Foreign key → Small_Sensor.sewer_Id — NOT NULL
  • value (Field) — Double
  • createDate (Field2) — LocalDateTime

ChangeT (Untitled10)

  • Id (Key) — Integer — Primary key — NOT NULL
  • t_Id (Key2) — Integer — Foreign key → TH_Sensor.t_Id — NOT NULL
  • sewer_Id (Key22) — Integer — Foreign key → TH_Sensor.sewer_Id — NOT NULL
  • value (Field) — Double
  • createDate (Field2) — LocalDateTime

H_Sensor (Untitled6)

  • h_Id (Key) — Integer — Primary key — NOT NULL
  • sewer_Id (Key2) — Integer — Foreign key → Sewer.sewer_Id — NOT NULL
  • value (Field) — Double
  • LocalDateTime (Field2) — LocalDateTime

Sewer (Untitled3)

  • sewer_Id (Key) — Integer — Primary key — NOT NULL
  • lat (Field) — STRING
  • lon (Field2) — STRING
  • address_Name (Field3) — STRING
  • region_Name (Field4) — STRING
  • state (Field5) — STRING

Small_Sensor (Untitled4)

  • small_Id (Key) — Integer — Primary key — NOT NULL
  • sewer_Id (Key2) — Integer — Foreign key → Sewer.sewer_Id — NOT NULL
  • states (Field) — STRING
  • smallCoun t (Field2) — Integer
  • jan_Count (Field3) — Integer
  • feb_Count (Field4) — Integer
  • mar_Count (Field5) — Integer
  • apr_Count (Field6) — Integer
  • may_Count (Field7) — Integer
  • jun_Count (Field8) — Integer
  • july_Count (Field9) — Integer
  • aug_Count (Field10) — Integer
  • sep_Count (Field11) — Integer
  • oct_Count (Field12) — Integer
  • nov_Count (Field13) — Integer
  • dec_Count (Field14) — Integer
  • smallDate (Field15) — LocalDate
  • smallTime (Field16) — LocalTime

TH_Sensor (Untitled5)

  • t_Id (Key) — Integer — Primary key — NOT NULL
  • sewer_Id (Key2) — Integer — Foreign key → Sewer.sewer_Id — NOT NULL
  • value (Field) — Double
  • LocalDateTime (Field2) — LocalDateTime