자바,mySql ORM 분석

테이블 (5)

CalbrationData (CALIBRATION_DATA)

  • calibrationId (calibration_id) — int — 기본 키 — NOT NULL
  • carId (car_id) — int — 외래 키 → Car.carId — NOT NULL
  • calibrationTime (calibration_time) — timestamp — NOT NULL
  • sensorType (sensor_type) — enum — NOT NULL
  • pressureMax (pressure_max) — float — NOT NULL
  • pressureMin (pressure_min) — float — NOT NULL

Car (CAR)

  • carId (car_id) — int — 기본 키 — NOT NULL
  • user (user_id) — int — 외래 키 → User.id — NOT NULL
  • carName (car_name) — varchar(255) — NOT NULL
  • carSize (car_size) — enum — NOT NULL
  • totalDistance (total_distance) — int — NOT NULL
  • carNumber (car_number) — varchar(255) — NOT NULL
  • photo — BLOB — NOT NULL
  • modelYear (model_year) — timestamp — NOT NULL
  • insurance — varchar(255) — NOT NULL
  • purchaseDate (purchase_dat) — timestamp — NOT NULL
  • driving_score (drivingScore) — int — NOT NULL

DrivingSession (DRIVING_SESSIONS)

  • driveId (drive_id) — int — 기본 키 — NOT NULL
  • id (user_id) — int — 외래 키 → User.id — NOT NULL
  • carId (car_id) — int — 외래 키 → Car.carId — NOT NULL
  • drivingStatus (driving_status) — enum
  • errorStatus (error_status) — enum — NOT NULL
  • errorTime (error_time) — timestamp — NOT NULL
  • startTime (start_time) — timestamp — NOT NULL
  • endTime (end_time) — timestamp — NOT NULL

SensorData (SENSOR_DATA)

  • sensorId (sensor_id) — int — 기본 키 — NOT NULL
  • drivingSession (drive_id) — int — 외래 키 → DrivingSession.driveId — NOT NULL
  • meassuredTime (meassured_time) — timestamp — NOT NULL
  • breakPressure (brake_pressure) — float — NOT NULL
  • accelPressure (accel_Pressure) — float — NOT NULL
  • speed — float — NOT NULL
  • latitude — varchar(255) — NOT NULL
  • longitude — varchar(255) — NOT NULL
  • id (user_id) — int — 외래 키 → DrivingSession.id — NOT NULL
  • carId (car_id) — int — 외래 키 → DrivingSession.carId — NOT NULL

User (USER)

  • id (user_id) — int — 기본 키 — NOT NULL
  • oauthProvider (oauth_provider) — enum — NOT NULL
  • email (oauth_id) — varchar(255) — NOT NULL
  • password (oauth_password) — varchar(255)
  • name (user_name) — varchar(100) — NOT NULL
  • mobile (user_mobile) — varchar(255) — NOT NULL
  • birtyhday (user_birthday) — date — NOT NULL
  • birthyear (user_birthyear) — timestamp — NOT NULL
  • gender (user_gender) — varchar(255) — NOT NULL
  • createdDate (created_date) — timestamp — NOT NULL