cluster

Tables (9)

LOCATION (위치 정보)

  • LATITUDE (위도) — varchar
  • LONGITUDE (경도) — varchar
  • SPEED (주행속도) — double
  • HEADING (방향각) — double
  • REGIST_DATE (등록일시) — date

SENSOR_STATUS (센서 상태)

  • SENSOR_ID (센서ID) — varchar
  • SENSOR_TYPE (센서타입) — varchar
  • SENSOR_STATUS (센서상태) — varchar
  • VEHICLE_TYPE (차량타입) — char
  • REGIST_DATE (등록일자) — date

STREET_SWEEPER_INFO (청소차 정보)

  • Field

TRACTOR_INFO (트랙터 정보)

  • ENGINE_SPEED (엔진회전수) — double
  • ACTUAL_ENGINE_PERCENT_TORQUE (엔진부하율) — double
  • ENGINE_COOLANT_TEMPERATURE (엔진냉각수온도) — double
  • AMBIENT_AIR_TEMPERATURE (대기온도) — double
  • ENGINE_EXHAUST_GAS_TEMPERATURE (엔진배기온도) — double
  • FUEL_LEVEL (연료잔량) — double
  • REPRESENTS_POSITIONOF_HITCH (리프트암위치) — double
  • PTO_LAMP (PTO동작램프) — integer
  • FWD_LAMP (4WD동작램프) — integer
  • SHIFT_LAMP (주변속단수) — integer
  • SHIFT_AUTO_LAMP (자동변속) — integer
  • KEYSWITCH_BATTERY_POTENTIAL (배터리전압) — double
  • GPS_SENSOR_STATUS (GPS센서상태) — integer
  • GPS_SENSOR_STATUS (NTRIP상태) — integer
  • DRAFT_SENSOR_STATUS (드래프트센서상태) — integer
  • HITCH_SENSOR_STATUS (히치위치센서상태) — integer
  • VEHICLE_SPEED_SENSOR_STATUS (차속센서상태) — integer

USER (사용자 리스트)

  • USER_ID (사용자ID) — varchar — Primary key — NOT NULL
  • PASSWORD (비밀번호) — varchar
  • PHONE (연락처) — varchar
  • GROUP (소속) — varchar
  • REGIST_DATE (등록일자) — date

VEHICLE_ING_INFO (특장차 공통 테이블)

  • I_INDEX (자동증가 index(i_index_seq)) — integer — Primary key — NOT NULL
  • VEHICLE_ID (차량ID) — varchar
  • VEHICLE_TYPE (차량타입) — varchar
  • TTC (선행차량과의 Time To Collision) — varchar
  • ING_ACCELERAION (Field4) — varchar
  • HANDLE_ANGLE (핸들각) — varchar
  • C_SEQ (Field6) — varchar
  • LATITUDE (위도) — varchar
  • LONGITUDE (경도) — varchar
  • C_TIMESTAMP (control_timestamp) — varchar
  • INTER_VEHICLE_DISTANCE (차간거리) — varchar
  • SPEED (속도) — varchar
  • LATERAL_ACCELERATION (횡방향 가속도) — varchar
  • WIPER_STATUS (와이퍼 동작상태) — varchar
  • MDPS_ANGLE (mdps 각도) — varchar
  • EMERGENCY_LIGHT (비상등 정보) — varchar
  • WHEEL_SPEED (휠스피드) — varchar
  • AUTO_DRIVING_STATUS (자율주행모드) — varchar
  • TRANSMISSION (기어상태) — varchar
  • V_TIMESTAMP (vehicle_timestamp) — varchar
  • TURN_SIGNAL (방향지시등) — varchar
  • YAW_RATE (요레이트) — varchar
  • BRAKING_STATUS (브레이크 동작상태(0:정지 1:출발)) — varchar
  • BRAKING_TYPE (브레이크 타입) — varchar
  • SENSOR_TYPE (센서 타입) — varchar
  • S_TIMESTAMP (sensor_timestamp) — varchar
  • SENSOR_STATUS (센서 상태) — varchar
  • SENSOR_ID (센서ID) — varchar
  • GOAL_LONGITUDE (목표경도) — varchar
  • J_SEQ (Field29) — varchar
  • MOTION_PLAN (행위계획) — varchar
  • GOAL_SPEED (목표속도) — varchar
  • TARGET_OBJ_SPEED (Field32) — varchar
  • TARGET_OBJ_PREDICT (Field33) — varchar
  • TARGET_OBJ (Field34) — varchar
  • GOAL_ACCELERATION (목표가속도) — varchar
  • TARGET_OBJ_DISTANCE (Field36) — varchar
  • J_TIMESTAMP (judgement_timestamp) — varchar
  • GOAL_LATITUDE (목표위도) — varchar
  • GOAL_WHEEL_ANGLE (목표조향각도) — varchar
  • L_LATITUDE (위치_위도) — varchar
  • L_TIMESTAMP (location_timestamp) — varchar
  • L_SPEED (위치_속도) — varchar
  • HEADING (위치_헤딩) — varchar
  • L_LONGITUDE (위치_경도) — varchar
  • LANE (보류(안정함)) — varchar
  • OBSTACLE_ARR (사용안함1) — varchar
  • TRAFFIC_LIGHT_ARR (사용안함2) — varchar
  • REGIST_DATE (등록일자) — date
  • T_TIMESTAMP (traffic_timestamp) — varchar
  • TRAFFIC_LIGHT_ID (신호등ID) — varchar
  • TRAFFIC_LIGHT (신호등 인지정보) — varchar
  • OBSTACLE_WIDTH (객체의 너비) — varchar
  • OBSTACLE_LNG_SPEED (Field53) — varchar
  • OBSTACLE_ID (객체ID) — varchar
  • OBSTACLE_LATERAL_ABS_SPEED (객체의 횡방향절대속도) — varchar
  • O_TIMESTAMP (obstacle_timestamp) — varchar
  • OBSTACLE_DISTANCE (객체와의거리) — varchar
  • OBSTACLE_HEADING (객체의 방향) — varchar
  • OBSTACLE_LATERAL_SPEED (Field59) — varchar
  • … +7

VEHICLE_LIST (특장차 리스트)

  • SEQ (자동증가) — integer — Primary key — NOT NULL
  • VEHICLE_ID (차량ID) — varchar
  • VEHICLE_NAME (차량명) — varchar
  • VEHICLE_TYPE (차량타입) — varchar
  • REGIST_DATE (등록일자) — date
  • USER_ID (사용자ID) — varchar — Foreign key → USER.USER_ID — NOT NULL

WORK_INFO_STREET_SWEEPER (청소차 작업 정보)

  • WORK_AREA (작업지영역) — varchar
  • WORK_PATH (작업경로) — varchar
  • REGIST_DATE (등록일자) — date

WORK_INFO_TRACTOR (트랙터 작업 정보)

  • WORK_AREA (작업지영역) — varchar
  • WORK_PATH (작업경로) — varchar
  • REGIST_DATE (등록일자) — date