test2
Tables (5)
CurrentStateInfo
- areaIndex — number — Foreign key → ParkAreaInfo.areaIndex — NOT NULL
- placeIndex — number — Foreign key → ParkAreaInfo.placeIndex — NOT NULL
- auto — count
- beaconState — boolean
- volumeState — number
- connectState — number
- prevCheckTime — timestamp
- parkState — varchar(16)
- plateNumber — varchar(20)
- plateType — varchar(20)
- plateCheck — boolean
- fuelType — varchar(16)
- crackDownTarget — boolean
- chargeStartTime — timestamp
- chargeEndTime — timestamp
- ipAddress — varchar(20) — NOT NULL
ParkAreaInfo
- areaIndex — number — Primary key — NOT NULL
- placeIndex — number — Foreign key → ParkPlaceInfo.placeIndex — NOT NULL
- ipAddress — varchar(20)
- auto — count
- chargeType — number — NOT NULL
- systemVersion — varchar(20)
- createDate — timestamp — NOT NULL
- createUser — varchar(20)
- updateDate — timestamp
- updateUser — varchar(20)
- delFlg — boolean — NOT NULL
ParkLogs
- ID — bigint — Primary key — NOT NULL
- auto — count
- ipAddr — varchar(20)
- plateNumber — varchar(20)
- plateType — varchar(20)
- vehicleType — varchar(20)
- offenseCode — varchar(16)
- parkStartTime — timestamp
- parkStartImg — use
- parkEndTime — timestamp
- parkEndImg — use
- delFlg — boolean
- areaIndex — number — NOT NULL
- ipAddress — varchar(20)
- placeIndex — number — NOT NULL
- auto — count
ParkPlaceInfo
- placeIndex — number — Primary key — NOT NULL
- auto — count
- placeName — varchar(20) — NOT NULL
- placeAddress — varchar(256) — NOT NULL
- latitude — float
- longitude — float
- createDate — timestamp — NOT NULL
- createUser — varchar(20)
- updateDate — timestamp
- updateUser — varchar(20)
- delFlg — boolean — NOT NULL
VehicleNumberData
- indexNumber — number — Primary key — NOT NULL
- plateNumber — varchar(20) — Primary key — NOT NULL
- auto — count
- plateType — varchar(20)
- fuelType — varchar(20)
- vehicleImg — use — 640*480 jpg 이미지 파일 저장
- crackDown — boolean
- createDate — timestamp — NOT NULL
- createUser — varchar(20) — NOT NULL
- updateDate — timestamp — NOT NULL
- updateUser — varchar(20) — NOT NULL
- delFlg — boolean