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