자바,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