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