Jeonse-ive

Tables (4)

FraudReading

  • fraud_id — bigint — Primary key — NOT NULL
  • city — varchar(20) — NOT NULL
  • gu — varchar(20) — NOT NULL
  • damagedHouses (Field) — bigint

NoiseReading

  • noise_id — bigint — Primary key — NOT NULL
  • year — int — NOT NULL
  • month — int — NOT NULL
  • value — double — NOT NULL
  • noiseStation_id — bigint — Foreign key → NoiseStation.noiseStation_id — NOT NULL

NoiseStation

  • noiseStation_id — bigint — Primary key — NOT NULL
  • station_name — varchar(50) — NOT NULL
  • shortAddress — varchar(20) — NOT NULL
  • latitude — double — NOT NULL
  • longitude — double — NOT NULL

User

  • User_id (user_id) — bigint — Primary key — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(200) — NOT NULL
  • nickname — varchar(15) — NOT NULL
  • role — varchar(10) — NOT NULL