ACS

Tables (11)

Charger_History (충전 이력)

    Charger_Master (충전기정보)

      Job_Master (작업기본정보)

      • Job_Master_Id (Key) — Primary key — NOT NULL
      • Job_Type (Field)
      • Job_State (Field2)
      • Vehicle_Id (Field3)
      • Receive_Time (Field4)
      • HSMS_Body (Field5)

      Job_Move (이동명령)

      • Job_Move_Id (Key) — Primary key — NOT NULL
      • From (시작점)
      • To (도착점)
      • Move_status (이동상태)

      Job_Move_History (이동명령이력)

        Load_Reservation (경로예약정보)

        • Load_Reservation_Id (Key) — Primary key — NOT NULL
        • Vehicle_Id (Field)
        • Node_Id (Field2)
        • Reserve_state (Field3)

        MQTT_Msg_Log (메시지이력)

        • MQTT_Msg_Log_Id (Key) — Long — Primary key — NOT NULL
        • Topic
        • Payload (본문)
        • Recieve_Time (수신시간)

        Vehicle_Alarm (AGV알람이력)

        • Vehicle_Alarm_Id (Key) — Primary key — NOT NULL
        • Level (레벨)
        • Body (내용)
        • Alert_Time (발생시간)
        • Clear_Time (조치완료시간)

        Vehicle_CurrentState (AGV 운영상태)

        • Vehicle_CurrentState_Id (Key) — Primary key — NOT NULL
        • Vehicle_State (운행상태)
        • Vehicle_Mode (수동/자동)
        • Battery_Level (배터리잔량)
        • Vehicle_CMD (현재명령상태)

        Vehicle_Master (AGV 기본정보)

        • Vehicle_Mater_Id (Key) — LONG — Primary key — NOT NULL
        • Vehicle_Name (AGV명)
        • Topic_State (ACS가 메시지받는 경로)
        • Topic_Command (AGV에게 메시지보내는경로)
        • Create_Time (생성시간)

        Vehicle_PositionLog (AGV위치정보)

        • Vehicle_PositionLog_Id (Key) — Primary key — NOT NULL
        • PosCurrX (현재X좌표)
        • PosCurrY (현재Y좌표)
        • PosID (현재위치)