ACS

Tables (6)

Command

  • command_cd (PK1) — Primary key — NOT NULL
  • command_desc (Field)
  • command_state (Field2)
  • from_location (Field3)
  • to_location (Field4)
  • to_action (Field7)
  • create_date (Field8)
  • update_date (Field9)
  • device_cd (FK1) — Foreign key → Vehicle.device_cd — NOT NULL
  • port_cd (FK2) — Foreign key → Port.port_cd — NOT NULL
  • Item_cd (FK3) — Foreign key → Item.Item_cd — NOT NULL
  • from_location (FK4) — Foreign key → Location.vehicle_location — NOT NULL
  • to_location (FK5) — Foreign key → Location.vehicle_location — NOT NULL

Device

  • device_cd (PK) — Primary key — NOT NULL
  • device_type (Field)
  • inf_ip (Field2)
  • inf_port (Field3)
  • server_port (Field4)
  • inf_yn (Field5)
  • create_date (Field6)
  • update_date (Field7)

Item

  • Item_cd (PK) — Primary key — NOT NULL
  • item_name (Field)
  • item_weight (Field2)
  • item_height (Field3)
  • item_weight (Field4)
  • item_width (Field5)
  • create_date (Field6)
  • update_date (Field7)

Location (location)

  • vehicle_location (PK) — Primary key — NOT NULL
  • port_location (Field)

Port

  • port_cd (PK) — Primary key — NOT NULL
  • port_type (Field)
  • inf_YN (Field2)
  • current_state (Field3)
  • create_date (Field4)
  • update_date (Field5)

Vehicle

  • device_cd (PK/FK) — Foreign key → Device.device_cd — NOT NULL
  • vehicle_model (Field)
  • vehicle_type (Field2)
  • current_state (Field3)
  • current_task (Field4)
  • to_location (Field5)
  • destination (Field7)
  • section_distance (Field8)
  • location_state (Field9)
  • batteryCapacity (Field10)
  • x_coordinate (Field11)
  • y_corrdinate (Field12)
  • angle (Field13)
  • speed (Field14)
  • row_batterCapacity (Field15)
  • error_desc (Field16)
  • create_date (Field17)
  • update_date (Field18)
  • Item_cd (FK2) — Foreign key → Item.Item_cd — NOT NULL
  • to_location (FK3) — Foreign key → Location.vehicle_location — NOT NULL
  • from_location (FK4) — Foreign key → Location.vehicle_location — NOT NULL