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