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